Page History

...

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.

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
Open Export Order Balance (LCY) (*JIRA293)	Sales Order Line	1. Sales Order Status = Open and Re-opened = No. 2. Order Status = Open 3. Payment Terms NOT "Skip Credit Control" 4. Less Group Shipment Amount if related group shipment status = Released and Posting Status = 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

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

"Customer Name"

"Lookup group shipment"

Export Invoice

"Look up Sales Invoice"

"N/A"

Customer Ledger Entries_Remaining Amount if
Open is True,
Payment Terms not Skip Control
Deposit Entry = False

Decrease AR Balance

Customer Ledger Entries_Due Date

"Customer Name"

"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)"

'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 postign status = pending

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"

<Decrease credit balance> Open Export Order Balance + Deposit

<Decrease credit balance> Released Export Order Balance + Deposit Amount

N/A

"Customer Name"

Shipped

Group Shipment_Payment Terms

"N/A"

If the sales order satus is Closed Use the SALESORDER dimension value to match the deposit Remaining Amount

"N/A"

"N/A"

Group Shipment_Due Date

Total

Calculate

Page tree

Versions Compared

Old Version 3

New Version Current

Key