Sales Detail Report

The reason that we aren’t able to put tax on the Sales Detail Report has to do with rounding.

For example:If you have a single invoice and it has a product sold for Quantity 2 at $0.55, the tax on the product is $0. 0882, rounded to 2 decimals = $0.09 taxHowever, if you have 2 separate invoices with Quantity 1 at $0.055, the tax on each would be $0.0441, rounded to 2 decimals = $0.04 tax, so those 2 invoices added together would only have $0.08 taxNow if you were to add all of those invoices together, (Sales Detail or Spreadsheet), you end up with Quantity 4, and the tax will be calculated as $0.1765, rounded to 2 decimals = $0.18As you can see, with only a single product spread across a few invoices, there is already a $0.01 tax calculation difference.This customer’s account would show that they owe $2.37 (tax of $0.17), but the spreadsheet (or sales detail) would calculate out to $2.20 sales and $0.18 tax.This will not necessarily happen for every product or quantity, but the potential is there.

Fields:Sort Option 1, 2, 3, 4: You can choose from the following categories:

• Branch
• Customer Type
• Account Number
• Date
• Charge Code
• Product Class
• Sales Rep/Driver
• Route
• Major Acct. Code
• Period (Will break down sales per period)
• Price
• Stop
• Invoice Number
• Quantity
• Sales
• Gallons
• Group Area
• Schedule area
• Sub Area
• Product Group
• G/L Number
• None

Change Branch: If you are logged into multiple branches, this option may be shown and allows you to re-select the branches to include in the report instead of having to completely exit the report.Account No: Enter the range of account numbers to include in the report.All: Default to include all customers.Do not group by Master Accounts: Choose this option to include sub account information on the report if using master billing.Don’t include Inactive Accounts: Choose this option to exclude account information for inactive customers.Hide Profit Information: Check this box to suppress all of the “profit” related figures from the report (i.e., Cost of Goods and Gross Margin). Show Current Price Instead of Average Price: Check this box to show the current pricing instead of the average price.Include Customers with No Purchases: Check this box to include customers without purchases on your reportCust Type: Select the range of customer types to include in the report.Credit Class: Enter the range of customer Credit Class Codes to include in the report.All: Default to include all Customer Types in the report.Major Acct Code: Select the major account number range to include in the report.NOTE: It is not required to have a major account code on each account. Sales Rep: Select the range of Sales Reps to include in the report.All: Default to include all Sales Reps in the report.Sales Rep 1-3: Select the desired Sales Rep field to include in the report.Driver 1-3: Select the desired Driver field to include in the report.Sales Dates: Enter the range of dates to include in this report.Chrg Code: Enter the range of charge codes to include in this report.All: Default to include all Charge Codes in the report.Only Inventory Items: Choose this option to exclude items marked as a Non Inventory Item in the Info tab of the Product Charge Code from the Sales Detail Report.Only Non Inventory Items: Choose this option to see only items marked as Non Inventory Item in the Info tab of the Product Charge Code.Product Class: The range of Product Class Codes to include in the report.All: Default to include all product Class Codes in the report.Route: Select the range of routes to include in the report.All: Default to include all routes in the report.All: Default to include all Major Account Codes in the report.Group Area: Select the customers Group Area Code to include in the report.All: Default to include all Group Area Codes in the report.Price List: Select the Price Lists to include in the report.All: Default to include all Price Lists in the report.Customer Start Date: Select the Customer Start Date range to include on the report.All: Default to include all Customer Start Dates in the report.Customer End Date: Select the Customer End Date range to include on the report.All: Default to include all Customer End Dates in the report.Acct. Status: Select the customer Account Status Code range to include on the report.All: Default to include all Account Status Codes in the report.Scheduling Area:All:Sub Area:

 

All: