Originally written by John Hardwick, last updated Sept 01, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
The report produces an audit of how payments have been received.
Crystal report name Daily Payment Summary 20
This report offers a detailed and summary format.
Detailed Format
Selection Criteria
Run time choices, user selectable.
-
Payment Date Range
Leaving the date set to the default of ‘31/12/9999’ instructs the report to run for today’s date.
The future date removes the need to manually key in today’s date every time the report is run, therefore it's a form of a shortcut to speed up run time selection.
-
Report Type
-
Detail / Detailed with payment Dates & Time) / Summary
-
-
Include
-
Refunds & Payments / Refunds Only / Payments Only
-
-
Finance Payments
-
Include / Exclude
-
-
Restricted Location(s) - Payment Locations
-
Tender Type(s)
-
Tender Group(s)
-
Location Filter
-
Payment Location / Original Sales Location
-
-
Show VAT / Tax
-
Yes / No
-
Where a payment links to a sales order with multiple VAT rates, the report shows the VAT composition of the order. See Example below
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location (Payment or Order)
2 Payment Date
3 Tender Group
4 Tender Type
5 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Tender Group
2 Payment Date
3 Location Summary
4 Report Summary
Printed Fields
Fields printed on the report.
-
Location
-
Payment Date
-
Tender Group
-
Tender Type
-
Sales Order Number
-
Customer’s Full Name
-
Receipt ID
-
Payment Reference
-
Operator
-
Payment Value
-
Number of payments and Value by Tender Group
-
VAT Rate, VAT Value (where selected)
Detailed Format with Dates & Times
Selection Criteria
Run time choices, user selectable.
-
Same as Detailed format
Print Sequence
As indicated by blue numbered squares in the report example.
Same as Detailed format
Report Totals
As indicated by yellow numbered squares in the report example.
Same as Detailed format
Printed Fields
Fields printed on the report.
Same as Detailed format - additional elements are
-
Payment Date & Time
-
Amendment Date & Time (prior to Cash Reconciliation)
-
Reconciliation Date & Time
-
Posted to Accounts Date & Time
-
Payment Location
-
Order Location
Summary Format
Selection Criteria
As per detailed format.
Print Sequence
As indicated by blue numbered squares in the report example.
1 VAT Rates
2 Location
Report Totals
As indicated by yellow numbered squares in the report example.
1 VAT Rates
2 Location
3 Report Total
Printed Fields
Fields printed on the report.
-
VAT Rate and Description
-
Goods Value
-
VAT total
-
VAT Percentage
-
Location
-
Payment Date
-
Tender Group
-
Number of Payments
-
Payment Total
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