Credit Control
1. Credit limit for individual customer or customer group
2. Credit limit calculation to be according to Customer Group if Customer Group is recorded in Customer Card for the group credit limit
3. Credit limit calculation exclude the Sales Order which is Cancelled or Closed marked in SO Line Order Status
Enhanced (JIRA289) - exclude the negative sales order line
The negative sales order line created for handle the return shipment case
- once the group shipment is posted then user use credit memo to reverse the invoice, user need to add the new sales order line for get the line to group shipment for create correct invoice.
- the negative sales order line is created for offset the new sales order line for prevent total sales amount increased due to the revision.
4. Credit limit calculation exclude if the payment terms is marked Skip Credit Limit Control
5. All credit limit calculation are base in LCY (CNA is use USD for LCY)
Approval Workflow
1. Multiple Approvers, document can be release if approved by either one approver. Approval Request entries to be deleted for the approver who have not approve the order and the order have been approved.
2. No notification send for the approval request
3. Allow user to change the SO/PO order for non-amount impact after Released
4. Buffer for re-approval amount. System will record last approved sales order amount for comparison
'- The % for compare the sales order amount can be config. in Sales & Receivable Setup
Customer Credit Balance Page
Available Credit (Page 7177) - Consolidate all credit control information and shows the Customer Credit Balance breakdown
Information including: AR Balance, Export Order Balance (i.e. Sales Order), Invoice Balance (i.e. Group Shipment), Overdue amount
ID | Field | Source | Condition |
---|---|---|---|
1 | AR Balance (LCY) | Customer Ledger Entries | 1. Open = Ture (i.e. Outstanding) |
2. Payment Terms in Related Document No is NOT "Skip Credit Control" | |||
*remarks: if entries is [Deposit Entry] Credit Balance will increase | |||
2 | Outstanding Orders (LCY) | Sales Order Line | 1. Order Status = Open |
2. Payment Terms NOT "Skip Credit Control" | |||
3. If related group shipment status = Released and posting status = Pending then "Order Amount - Group Shipment Amount" | |||
4. Enhanced (JIRA289) - add the credit memo line amount if the Sales Credit Memo Line Dimension for INVOICENO is same as the Line Dimension for the applied customer ledger entries *WIP | |||
3 | Invoice (LCY) | Group Shipment | 1. Status = Released |
2. Posting Status = Pending | |||
4 | Total Balance (LCY) | Sum of (1-3) | NAV Standard |
5 | Credit Limit (LCY) | Customer/Customer Group | Customer Credit Limit / Customer Group Credit Limit |
6 | Available Credit (LCY) | Credit Limit - Total Balance | NAV Standard Enhanced (JIRA289) - exclude the negative sales order line (Table 18) *WIP |
7 | Overdue Amount (LCY) as of xx | Customer Ledger Entries | NAV Standard |
Credit Limit Approval
1. Flag for Request Approve added in sales header (this new field is not included in copy document)
Summary of business requirement
The logic for derive the flag for "Request Approve" as below:
(A) If Skip Credit Control = NO and Available Credit Limit or Group Available Credit Limit < = 0, then Request Approval = Yes
else if Skip Credit Control = NO and Available Credit Limit or Group Available Credit Limit > 0, then Request Approval = No
(B) If Skip Credit Control = YES and Available Credit Limit or Group Available Credit Limit < = 0, then Request Approval = No
2. Field for "Approved Sales Amount" added in sales header (this new field is not included in copy document)
*Approved amount should be in local currency.
Case Scenario when Order Release
1. If payment terms is skip credit control, order change to Released
2. If payment terms is not skip credit control, check the credit limit
*if within credit limit => order change to Released
*if excess credit limit => send approval for release. Once approved and released, system update the Approved Sales Amount.
3. If order re-open and sales header or line is modified, then
3.1 Check payment terms => if skip credit control then order change to Released
3.2 Check payment terms => if not skip credit control, compare the new sales amount and Approved Sales Amount
*if within buffer => order change to Released
* if excess buffer => send approval for release. Once approved and released, system update the Approved Sales Amount.
Credit Balance to be update when user change on sales order
# | Case | Remarks |
---|---|---|
1 | Change Sales Line Qty | Total Amount to be change |
2 | Change Sales Line Unit Price | Total Amount to be change |
3 | Change Currency | Credit Balance to be change |
4 | Change Payment Terms | Credit Control checking to be different (i.e. Skip Credit Control or non-skip credit control |
5 | Change Customer | Customer Credit Limit or Group Credit Limit or credit balance to be different |
Case Example
Day | Payment Terms | Skip Approval | Credit Limit | Order Amount | Need Approval? | Process | Approved Amount after Released |
---|---|---|---|---|---|---|---|
Scenario 1 | |||||||
1 | TT | No | 1,000 | 100.00 | NO - Within Limit | Release | - |
2 | TT | No | 1,000 | 1,100.00 | YES - Over Limit | Sent Approval => Release | 1,100.00 |
3 | TT | No | 1,000 | 1,110.00 | NO - Within Buffer | Release | 1,100.00 |
4 | TT | No | 1,000 | 2,000.00 | YES - Over Buffer | Sent Approval => Release | 2,000.00 |
5 | LC | Yes | 1,000 | 2,000.00 | NO - Skip Control | Release | 2,000.00 |
6 | TT | No | 1,000 | 2,000.00 | NO - Within Buffer | Release | 2,000.00 |
7 | TT | No | 1,000 | 3,000.00 | YES - Over Buffer | Sent Approval => Release | 3,000.00 |
Scenario 2 | |||||||
1 | LC | Yes | 1,000 | 2,000.00 | Skip Control | Release | - |
2 | TT | No | 1,000 | 2,000.00 | Over Limit | Sent Approval => Release | 2,000.00 |
3 | LC | Yes | 1,000 | 2,100.00 | Skip Control | Release | 2,000.00 |