Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report is designed to show invoices entered / processed within the Invoice Matching routine.
Crystal report name Registered Invoice Report 1
If the variance value or percentage is higher than the specified ‘highlight’ value, the background will show Red. Negative variances will show with a green background.
Yellow background is an manually keyed invoice reference total.
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Highlight Variances above X (percentage)
-
Highlight Variance over X (money)
-
Format
-
Detailed / Summary
-
-
Include
-
All Invoices / Overcharged Invoices / Invoices with Variances
-
-
Internal Reference
Select ‘All' to include all invoices, or enter a specific combination of characters to filter the data.
-
Operator
-
Show
-
All / In Process / Complete / Posted / In Dispute
-
-
Restricted Location(s)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Internal Reference
2 Date of Registry
3 Operator
4 Invoice Number
5 Purchase Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Internal Reference
2 Report
3 Report Summary
Printed Fields
Fields printed on the report.
-
Internal Reference
-
Date Registered
-
Operator
-
Invoice Variance Value
-
Invoice Variance Percentage
-
Invoice / Bill Number
-
Supplier / Vendor
-
Invoice / Bill Date
-
Invoice Amount
-
Comments
-
Invoice Status
-
Purchase Order Number (Detailed Only)
-
Supplier's Delivery Note / Reference (Detailed Only)
-
SKU (Detailed Only)
-
Stock Detail ID (Detailed Only)
-
Product Description (Detailed Only)
-
Quantity Invoiced (Detailed Only)
-
Expected Value (Detailed Only)
-
Invoiced Value (Detailed Only)
-
Variance (Detailed Only)
-
Add on Cost Description (Detailed Only)
-
Add on Cost (Detailed Only)
-
Cost Location (Detailed Only)
-
Nominal Apportionment / Code (Detailed Only)
Summary
-
Internal Reference
-
Invoice Date
-
Total Invoice Value Registered
-
Value ‘In Dispute’
-
Value ‘In Process’
-
Value ‘Posted’
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