Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report produces a mini statement showing the order balance for a customer.
Crystal report name Customer Credit Order Balance 4
The summary version does not include individual order and payment transactions.
Selection Criteria
Run time choices, user selectable.
-
Customer Surname
Wild cards of * may be used
-
Group by Branch
-
Yes / No
-
-
Group by Salesperson
-
Yes / No
-
-
Format
-
Detailed / Summary
-
-
Restricted Sales Location(s)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Location (If Selected)
2 Salesperson (If Selected)
3 Customer ID
4 Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Customer ID
Printed Fields
Fields printed on the report.
-
Purchase Invoices
-
Sales Location (If Selected)
-
Salesperson (If Selected)
-
Customer’s Full Name
-
Customer Number
-
Order Total
-
Payments
-
Approved Finance
-
Unapproved Finance
-
Unfulfilled (Left to deliver)
-
Delivered Value
-
Customer To Pay Balance
-
Ageing (less than 30 days / 30 to 60 / 60 to 120 and over 120 days)
-
Last payment Date
-
Allocated Payment Total
-
Approved Payment Total
-
Approved Finance Total
-
Payment Total
-
Unallocated Payment Balance
-
Unapproved Finance
-
Balance to Pay
Detailed Format Extras
-
Sales Order - Pad Reference
-
Order Date
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article