Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
The report shows, by week within financial year within user selected location(s) all payments received and / or refunds processed within the user specified date range.
Crystal report name Weekly Payments Summary 1
All variants of the report produce a total summating all transactions for all locations to tender groups.
This report includes reconciled payments only
The report requires the Sales Calendar to be built to operate. See Sales Calendar
Selection Criteria
Run time choices, user selectable.
-
Financial Year
-
Week Number
To include all weeks within the selected financial year, enter 0.
-
Report Type
-
Detailed / Detailed with Dates & Times / Summary
-
-
Include
-
Refunds Only / Payments Only / Both
-
-
Include Finance Agreements
-
Include / Exclude
-
-
Filter By Location
-
Yes / No
-
-
Show VAT analysis
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Payment Location
2 Week Number
3 Payment Date
4 Tender Group
5 Tender Type
6 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Tender Group / Type
2 Payment Date
3 Week Number
4 Location
5 Report
Printed Fields
Fields printed on the report.
Detailed version
-
Payment Location
-
Week Number
-
Payment Date
-
Tender Group
-
Tender Type
-
Sales Order Number
-
Customer’s Full Name
-
Payment Receipt ID
-
Operator
-
Payment Value
-
Creation Date / Time (Detailed with Dates & Time version)
-
Amended Date / Time (Detailed with Dates & Time version)
-
Posted Date / Time (Detailed with Dates & Time version)
-
Order Location (Detailed with Dates & Time version)
-
Payment Location (Detailed with Dates & Time version)
Summary
-
Payment Location
-
Week Number
-
Payment Total
-
Payment Date
-
Tender Group
-
Number of Payments
-
Value of Payments
Totals
-
Tender Group
-
Number of Payments
-
Value of Payments
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