Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report lists the cost of deliveries confirmed / finalized within the specified date range, grouped by location for each calendar month, and uses the accounting date to ensure the report does not produce varying results should a transaction be retrospectively transacted.
This report allows drill down showing the statistics manufacturing the group totals.
Crystal Report name Cost of Sales Nominal 6
Drill Down Feature
Whilst viewing in the browser, by clicking when the cursor is on the ‘Cost of Sales’ row, creates a secondary display page showing the details making up the value shown.
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Restricted Location(s) - Selling Location
-
Sales Nominal Code(s)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Month / Year
2 Selling Location
3 Cost of Sales Account / Nominal Code
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sum of Sales by Location
2 Sum of Sales by Month / Year
3 Sum of Sales Report Totals
Printed Fields
Fields printed on the report.
-
Selling Month and Year
-
Selling Location
-
Cost of Sales Ledger Account Code
-
Cost of Sales for this Period
-
Current Cost of Sales
Drill Down Fields
Fields printed on the report.
-
Invoice Month
-
Invoice ID
-
Product Description
-
Quantity Confirmed
-
Unit Cost
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