To open credit limit page to preview Customer Credit Balance
| Step | Description |
|---|
| 1 | (1) Customer Credit Limit - Click on the link “Available Credit (LCY)” link in the Sales Order Fact Box. (2) Group Credit Limit - Click the link in Customer Group Detail box.  Image Modified
|
| 2 | Customer Credit Balance Page | Header Field (GENERAL TAB) | Data Source | Condition |
|---|
| Customer Group | Customer Group Name | Only shows if the customer is use Group Credit Limit | AR Balance (LCY) (*JIRA304) | Customer Ledger Entries | 1. Open = Ture (i.e. Outstanding) and Deposit Entry = No 2. Payment Terms in Related Document No. is NOT SKIP CREDIT CONTROL |
|
3. If entries is "Deposit Entry", credit balance to be increase
e.g. Credit Limit is 100, Import order is 80, Deposit is 20
Credit Balance is 40 (100-80+20)
Open Export Order Balance (LCY) (*JIRA293 |
|
Export Order Balance (LCY) | Sales Order Line | 1. Sales Order Status = Open and Re-opened = No. 2. Order Status = Open 3. Payment Terms NOT "Skip Credit Control" |
|
34. Less Group Shipment Amount if related group shipment status = Released and Posting Status = |
|
Pending Pending 5. Exclude the sales order line which has negative amount (*JIRA289) Remarks: Generally, the sales order line with negative amount is use for handle the sales return.
Case example as below: 1) Invoice posted via Group Shipment 2) Create Credit Memo for reverse posted sales invoice 3) In the original Sales Order, create SO Line -neg. and +pos. for create the correct Group shipment 4) Create Group shipment for the new +pos. line then post the invoice. | Released Export Order Balance (LCY) (*JIRA293) | Sales Order Line | 1. Sales Order Status = Released or Sales Order Status = Open and Re-open = Yes *Other condition same as Open Export Order Balance point 2-5 | | Invoice Balance (LCY) | Group Shipment Line | 1. Status = Released
2. Posting Status = Pending | Total Deposit Amount (*JIRA304) | Customer Ledger Entries | Customer Ledger Entries Remaining Balance. - Open = True
- Deposit Entry = Yes
| Order Deposit (*JIRA304) | Customer Ledger Entries | Same as Total Deposit Amount in Customer Credit Balance List | Total Balance (LCY) (*JIRA304) | Calculate | AR Balance + Open Export Order Balance + Invoice Balance - Order Deposit | | Credit Limit (LCY) | Customer/Customer Group | Credit Limit | | Available Credit (LCY) | Calculate | Credit Limit - Total Balance | | Released Credit Balance | Calculate | Same as total Released Credit Balance in Customer Credit Balance list. | | Balance (LCY) |
| AR Balance, click for open related customer ledger entry | | Outstanding Orders (LCY) |
| Export Order - click for open related sales order line | | Outstanding Invoice (LCY) |
| BC Standard | | Overdue Amount (LCY) |
| BC Standard |
|
Image Removed
Customer Credit Balance (*1-JIRA293) / (*2-JIRA304) / (*3-JIRA313) | 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. | '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" | 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 |
|
Image Removed