Sales Journal by Order Type

How to print: Complete the Sales Journal by Order Type screen, available through Printing the Sales Journal by Order Type (PSJO) menu option.

For more information: See the sample report in PDF format.

Note: This report is also available as a .csv (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in CSV (Spreadsheet) Format for more information.

Contents:

• Invoice date range

• Currency

Note: This report sorts by currency if the Multi Currency by Offer (E03) system control value is selected.

• Invoice date (the date on which an invoice was created as a result of a shipment. This report shows all shipments for the specified report date range)

• Pay plan type. Valid values = Regular (no pay plan), Deferred, or Installment.

• Order type

• Division (from source code on order header)

• Pay type code

• Invoice number

• Customer number

• Order number

Note: The following totals are from the Invoice Ship To record.

• Merchandise dollar amount

• Freight

• Additional freight

• Tax (the amount of sales tax calculated on merchandise shipped. If this figure includes any VAT, the word VAT appears to the right.¹)

• Handling

• Additional charge

• Total invoice

• Amount collected

• Net total invoices

• Net total for pay type

• Net total for plan type

• Net totals for division

• Net totals for order type

• Net grand totals

---

1. This information appears only if the Tax Included in Price (E70)system control value is selected. On orders subject to VAT, tax 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.