Originally written by John Hardwick, last updated Nov 13, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report is designed to produce a financial customer statement for a date offering different degrees of information, ageing dates, and control of account balance inclusion.
Crystal report name Customer Statement 8
The overall customer balance displays with red background where the customer owes money.
Green is used to indicate overpayments (credit balances) and white (no background) for zero balances.
Account activity occurring after the specified cut-off date is ignored to ensure traceability. The audit shows the print date and the as at date.
The ‘(Finance)’ following the balance indicates there are outstanding finance values linked to the customer’s account.
Held Orders are highlighted with a yellow background as shown above.
Selection Criteria
Run time choices, user selectable.
-
Format
-
Detail / Summary / Customer Summary
-
-
Group By Location
-
Yes / No
-
-
Restricted Location(s)
-
Cut-Off Date
-
Include
-
Any Balance / Outstanding Debt / Credit Balance / Non-Zero Balances
-
-
Customer ID(s)
-
Ageing
-
30, 60, 90 / 30, 60, 120
-
-
New Page Per Customer
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location
2 Customer ID
3 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sales Order Number
2 Customer ID
3 Location (Where Grouped)
Printed Fields
Fields printed on the report.
All formats
-
Location (where selected)
-
Customer Number
-
Customer’s Full Name
-
Customer Telephone Number
-
Customer’s Daytime Number
-
Customer’s Mobile / Cell Number
-
Customer’s Main Address, including Postcode / Zip code / Eirecode
-
Current Approved Finance Balance
-
Current Unapproved Finance Balance
-
Overall Current Customer Balance
Detailed Only
-
Payment ID / Delivery Stock ID
-
Payment Type / Delivery Invoice Number
-
Delivery Value
-
Age in Days
Summary & Detailed
-
Sales Order Date
-
Selling Location
-
Salesperson
-
Sales Order Number
-
Order Balance
-
Overall Order Balance
-
Payments Received
-
Approved Finance
-
Paid Finance
-
Ageing in 30-60->90 or 30-60->120 Days format
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