Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report designed for the US market shows tax breakdowns by sales order showing the constituent rates where set.
Crystal report name Sales Tax History 2
US Tax rates are split into 3 sections – This report will split out these elements if the tax description is set to Description (rate 1/rate 2/rate 3) … E.g., Standard Rate (15/3/2)
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Restricted Location(s)
-
Format
-
Date Summary / Invoice Details
-
-
Tax Rates
Print Sequence
As indicated by blue numbered squares in the report example.
1 Tax Rate (ID)
2 Invoice Date
Report Totals
As indicated by yellow numbered squares in the report example.
1 Tax Rate (ID)
2 Report
3 Tax Summary
Printed Fields
Fields printed on the report.
-
Tax Rate Description
-
Invoice Date
-
Invoice ID (detailed only)
-
Sales Order Number (detailed only)
-
Customer ID (detailed only)
-
Truck ID / Delivery Run Number (detailed only)
-
Selling Price Ex Tax
-
Tax / VAT Value
-
Tax Band 1 Value
-
Tax Band 2 Value
-
Tax Band 3 Value
Summary Grid
-
Tax Rate
-
Sales Ex Tax
-
Rate 1 Value
-
Rate 2 Value
-
Rate 3 Values
-
Total Tax
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