Case Handling
1) Entry to be create when document line with Type is "Item" created in document such as PO, SO, SI, DN, TO, Item Journal, Item Reclass Journal, Virtual Item Reclass Journal, Production Journal, Assembly Order
2) If user delete the line before post (i.e. Recd./Shipped Qty is "0") the VWA entry to be deleted.
3) Sales Order
- not allow delete line if Shipped.
- system auto update Virtual Location to source document, only update 1 times, e.g. if SI get line from SO and user change the virtual location in the SI, system auto update the virtual location from the SI to SO and the VWA entry
4) Sales Document Reverse **Below is the user process. pls document how it handle in backend if needs**
Case (1) if source document is SO and need reverse the DN or Invoice
- Create Credit Memo with Prefix "INC"
- Get Posted Document (get the posted SI)
- Post the Credit Memo
- The Qty to be revert in original Sales Order Line and user can get the SO line to SI or DN again
- VWA to be create once get line again
Reverse Case (2) if source document is SI
- Create Credit Memo with Prefix "INC"
- Get Posted Document (get the posted SI)
- Post the Credit Memo
- User will create new sales invoice manually or use Copy Document Function
Reverse Case (3) if source document is DN
- Create Credit Memo with Prefix "INC"
- Get Posted Document (get the posted SI)
- Post the Credit Memo
- User will create new DN manually, use Copy Document Function or Import function
- Create invoice by get line form the DN
Field (Visible on User Interface)
| Field | Description | Remarks |
|---|---|---|
| Entry Date | VWA Entry Date | |
| Entry No | VWA Entry No | |
| Entry Type | Source Document Type | Purchase = Purchase Order Sales = Sales Order/Sales Invoice/Delivery Note Transfer = Virtual Item Reclass Journal / Item Reclass Journal / Transfer Order Negative Adjmt./Postive Adjmt = Item Journal Consumption / Output = Production Order Assembly Consumption / Assembly Output = Assembly Order |
| Document No | Source Document No | If Type is Purchase = Purchase Order No. If Type is Sales = Sales Order No. / Sales Invoice No. / Delivery Note No. **the source document for Sales e.g. if the SI or DN is get line from SO, then only sales order to be show |
| Document Line No, | Source Document - Line No | |
| Item No | Item No | |
| Virtual Location | Virtual Location Code | |
| Phy Location | Physical Location Code | |
| Qty Planned | Qty of the source document line | |
| Qty Recd/Shipped | Qty of the Shipped Qty or Received Qty of the source document line | |
| Unit of Measure | Qty UOM of the source document line | |
| Qty Planned (Base) | ||
| Qty Recd/Shipped (Base) | ||
| Qty Per Unit of Measure | ||
| External Document No. | External Document No. entered in Journal | Only capture the External Document No. if the entry is created from "Journal" |
| Expected Receipt Date | ||
| Expected Ship Date | ||
| Document Date | ||
| Posting Date |