Standard Sales Journal

How to print: This report prints if you accept the default (unselected) setting of the Print by division field through the Printing the Sales Journal (PDSJ) 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.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.

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:

1. currency, if the Multi Currency by Offer (E03) system control value is selected, with blank currency sorted first.

2. division, if you selected the Print by division flag when generating the report. See Sales Journal by Division.

3. invoice date. Within each date, the report lists invoices in ascending numeric order (lowest to highest).

Contents:

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 Multi Currency by Offer (E03) 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.

• Division: The division code and description are included only if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.

• 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.

• Merchandise

• Freight

• Additional Freight

• Tax: The amount of sales tax calculated on merchandise shipped. If the Tax Included in Price (E70) system control value is selected, this figure includes any value-added tax, and the word VAT is to the right.

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.

• Handling

• 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

Calculated fields:

• 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.

Note:

- If the Multi Currency by Offer (E03) 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 Multi Currency by Offer (E03) 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.

See Determining Gross Profit for a discussion.

• Out-of-balance: the out-of-balance amount is included in a separate line immediately below the out-of-balance invoice. See Out-of-Balance Invoices for a discussion.

Totals: The report includes a total of each of the above-listed dollar values for:

- each date in the selected date range

- the division, if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.

- the currency, if the Multi Currency by Offer (E03) system control value is selected

- the entire selected date range

An out-of-balance total line is included for each of the above totals if any invoices in the selected date range were out-of-balance; see Out-of-Balance Invoices for a discussion.

• 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.

See Determining Gross Profit for a discussion.

• VAT Total: the total amount of value-added tax, which is also included in the Tax total. This information appears only if the Tax Included in Price (E70) system control value is selected.