Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report produces a statement as to the level of debt grouped by location by customer for user specified location(s) / date and time combination in respect of delivered goods for the company.
The report now uses the accounting date to ensure the report contents remain static when retrospective transactions occur.
The report shows any service calls logged against the debt, detailing open and closing date.
Crystal report name Debtors 13
Where linked services are shown open service, details are shown with a red font, closed services a black font.
Selection Criteria
Run time choices, user selectable.
-
Process to Date & Time - (Date of Sale)
-
Manually Keyed Location Name
Wildcards (an asterisk) may be used, for Example LA* would include all locations beginning LA.
-
Report Dating
-
Accounting / Transaction
-
-
Group by
-
Location & Customer / Customer & Sales Order
-
-
Include
-
All Sales Orders / Only Sales Orders With Service / Orders Without Service Only
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Location (If Selected)
2 Customer ID
3 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location (If Selected)
2 Report Totals
Printed Fields
Fields printed on the report.
-
Location
-
Customer ID
-
Full Customer Name
-
Sales Order Number
-
Account Due (Amount Owed)
-
Service ID (if linked)
-
Service Creation Date
-
Service Closure Date
Grouped By Customer (No Service Orders)
Selection Criteria
Run time choices, user selectable.
Same as Grouped by Location format
Print Sequence
As indicated by blue numbered squares in the report example.
2 Customer ID
3 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
2 Report Totals
Printed Fields
Fields printed on the report.
-
Customer ID
-
Full Customer Name
-
Sales Order Number
-
Account Due (Amount Owed)
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