Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
Primarily for the US market, this report lists taxes due in respect of confirmed / Finalized deliveries (and collections)
Crystal report name Sales Tax Report 4
This report produces a detailed section plus the Total only section shown below
The State is the fifth line of the delivery address.
This report produces a detailed section plus the Total only section shown below
This report assumes all SKU items are either a delivery or a return unless …
The SKU is the subject of an open service, where the item is marked as ‘service’
The SKU has an attribute named ‘DeliveryTax’ assigned to it, whereby it is marked as ‘Delivery’
The SKU has an attribute named ‘InstallationTax’ assigned, in which case the item will be marked as ‘Installation’.
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Restricted Location(s)
-
Format
-
Show Invoice Details / Show Invoice Totals Only / Show Report Total Only
-
-
Tax Rates
-
Include Allowance Lines
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location
2 Invoice Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location
2 Report
Printed Fields
Fields printed on the report.
Detailed Report
-
Trading Location
-
Invoice ID
-
Invoice Date
-
Sales Order Number
-
Written on Date
-
Full Customer’s Name
-
Selling Price Ex Tax
-
Cost Price
-
City (Fifth line of Address)
-
Tax Rate
-
Tax Description
-
State
-
Type (Delivery / Sale)
-
Tax Value
-
Total Inc Tax
Invoice Total
-
Trading Location
-
Invoice ID
-
Invoice Date
-
Sales Order Number
-
Full Customer’s Name
-
Selling Price Ex Tax
-
Cost
-
City
-
State
-
Tax Value
-
Line Total Inc Tax
Totals - repeated for Sales Inc Tax / Sales Ex Tax / Tax / Tax by Rate
-
Trading Location
-
State
-
City
-
Delivery items
-
Delivery Value
-
Returns Value
-
-
Installation Items
-
Delivery Value
-
Returns Value
-
-
Goods
-
Delivery Value
-
Returns Value
-
-
Total Delivery / Returns
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