Originally written by John Hardwick, last updated Jun 30, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This audit shows invoices raised per month for a selected location range indicating margin obtained against each order.
Crystal report name Sales Invoice Cost Margin 3
Selection Criteria
Run time choices, user selectable.
-
Transaction Date Range
-
Group by
-
Yes / No
-
-
Restricted Selling Location(s)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Month / Year
2 Location
3 Salesperson
4 Product Group (if selected)
5 Invoice Date (Confirmation Date)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sales Order
2 Product Group (if selected)
3 Salesperson
4 Location
5 Month / Year
6 Report
Printed Fields
Fields printed on the report.
-
Month / Year
-
Selling Location
-
Salesperson
-
Product Group (if selected)
-
Delivery (Invoice) Date
-
Invoice ID
-
Customer ID
-
Customer’s Last Name
-
Product Description
-
Quantity
-
Item Price
-
Net Selling Price
-
VAT
-
Cost
-
Margin Value
-
Margin %
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