How to print: This report prints if you accept the default (unselected) setting of the Print by division field through the menu option. Sales transactions are listed in ascending order (lowest-to-highest) by date and in ascending order by invoice number order within each date.
For more information: See the sample report in PDF format.
Things to note about the spreadsheet version of the report:
• There may be a rounding discrepancy on the tax total for the last date included on the report, as well as the grand total of tax. This discrepancy should be no more than a few cents.
• Depending on the width of the data, there may be blank columns between some of the columns.
Sort order: The report sorts by:
3. invoice date. Within each date, the report lists invoices in ascending numeric order (lowest to highest).
Page headings: Each page of the report includes the following headings:
• Invoice Dates: The range of dates you selected when generating the report.
• Currency: The currency code and description are included only if the system control value is selected. The currency indicated is blank if you run the report for shipments that occurred before you started using multi-currency by offer.
• Invoice Date: Totals are included for each invoice date.
There is a page break for each new currency, division, or invoice date.
For each invoice: The report lists:
• Invoice: The number identifying the invoice.
• Customer: The sold-to customer number.
• Order: The number identifying the order. The ship-to number is not listed.
Note: The following fields are from the Invoice Ship To records. If there is more than one Invoice Ship To, these fields represent the sums across all ship-tos. The amounts listed for credit invoices are followed by a minus sign.
• Additional Freight
About VAT: On orders subject to VAT, tax on merchandise does not accumulate in the Tax bucket; instead, a “hidden tax” is included in the order detail line and the customer pays a tax-inclusive price for each item. For such orders, the Merchandise total indicated is net of VAT. In other words, if the customer paid $10.00 for the merchandise, but a $1.50 hidden tax was included in the order detail line, the merchandise total would be $8.50.
The unit VAT charge is stored in the Second choice SKU item field in the Order Detail table, and the total VAT amount for an invoice is the total of the extended VAT amounts for each order detail line billed for that invoice.
• Additional Charge
Note: The following fields indicate how the invoice was paid, and are from the Invoice Payment Method records. If there are multiple Invoice Payment Method records for the same pay category (for example, two credit cards), the field indicates the sum for that pay category.
• Total Cash
• Total Credit Card
• Gross Profit: Calculated as Merchandise amount - cost from invoice ship-to / merchandise amount * 100. Rounded up or down to the nearest hundredth or cent, so that the report lists a gross profit with two decimal positions.
- If the system control value is selected, the cost is converted to the local currency before calculating the gross profit, using the conversion rate from the Invoice Currency record. For example, if the cost in the order currency is 10.00 and the currency conversion rate is 1.50, then the system uses a cost of 15.00 (10.00 * 1.5) to calculate gross profit. However, if the system control value is selected but the report includes shipments billed before you selected the system control value, the Gross profit listed for the invoices is 100.00%.
- An invoice might have a Gross profit of 0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise total were equal.
Totals: The report includes a total of each of the above-listed dollar values for:
- each date in the selected date range
- the entire selected date range
• Gross profit totals: The Totals field for Gross profit represents the average gross profit percentage for all shipments on the specified invoice date, calculated by totaling the gross profit percentage for all shipments and dividing the result by the number of shipments, where:
- the shipment amounts include positive invoices only, not credits
- the number of shipments includes positive invoices only, not credits, and does not include invoices with a Gross profit of $0.00. An invoice might have a Gross profit of $0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise dollar total were equal.