Customer Name | Order/Invoice No | Document Date | Bill of Landing Date | Document Type | Payment Terms Description | Status (*1) | Open Export Order Balance (*1) | Released Export Order Balance (*1) | Deposit Amount (*2) (*3) | Order Amount (exclude deposit) (*2)
| Invoice Balance | AR Balance
| Credit Balance (*1) | Released Credit Balance (*1) | AR Due Date |
"Customer Name" |
|
|
| Credit Limit for Customer |
|
|
|
|
|
|
|
| Group Credit Limit / Credit Limit | Group Credit Limit / Credit Limit |
|
"Customer Name" | <Customer Ledger Entries_Document No> | <Customer Ledger Entries_Document Date> | "Lookup group shipment" | Export Invoice | "Look up Sales Invoice" | "N/A" | "N/A" | "N/A" | "N/A" | "N/A" | "N/A" | Customer Ledger Entries_Remaining Amount if Open is True, Payment Terms not Skip Control Deposit Entry = False | Decrease AR Balance | <Increase if deposit entry> | Customer Ledger Entries_Due Date |
"Customer Name" | <Sales Order_SO No> | <Sales Order_Order Date> | "N/A" | Order | Sales Order_Payment Terms | <SO Status> Show "Re-open" if the status is Open but the order is released before. | Same as header "Open Export Order Balance (LCY)" | Same as header "Released Export Order Balance (LCY)" | Use the SALESORDER dimension value to match the deposit Remaining Amount If the related Group Shipment status is Released and Posting Status is Pending, the Deposit amount to be less the Group Shipment amount. 'Customer Ledger Entry.Remaining Amount if Customer Ledger Entries: Deposit Entry = Yes and Open = Yes and Customer Ledger Entry.Dimension Set Entry. Dimension Code = SALESORDER, Dimension Value = Sales Order.Dimension Set Entry.Dimension Code = SALESORDER, Dimension Value - Group Shipment Amount if related group shipment status is released and posting status = pending | 'Open Export Order Balance or Released Export Order Balance - Deposit Amount | "N/A" | "N/A" | <Decrease credit balance> Open Export Order Balance + Deposit | <Decrease credit balance> Released Export Order Balance + Deposit Amount | N/A |
"Customer Name" | <Group Shipment_Invoice No> | <Group Shipmnet_Document Date> | <Group Shipmnet_Bill Lading Date> | Shipped | Group Shipment_Payment Terms | <Group Shipment Status> | "N/A" | "N/A" | 'Customer Ledger Entry.Remaining Amount if Customer Ledger Entries: Deposit Entry = Yes and Open = Yes and Customer Ledger Entry.Dimension Set Entry. Dimension Code = SALESORDER, Dimension Value = Sales Order.Dimension Set Entry.Dimension Code = SALESORDER, Dimension Value If the sales order satus is Closed Use the SALESORDER dimension value to match the deposit Remaining Amount | "N/A" | <Group Shipment_Amount> | "N/A" | <Decrease credit balance> | <Decrease credit balance> | Group Shipment_Due Date |
Total |
|
|
|
|
|
|
|
|
|
|
|
| Calculate | Calculate |