Sales Journal by Pay Type

How to print: Use the Printing the Sales Journal by Pay Type (PSJP) menu option.

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.


• Invoice date range

• Currency

• 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

• Pay type code

• Invoice number

• Customer number

• Order number

Note: The following totals are from the Invoice Payment Method record(s).

• Merchandise

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

• Handling

• Additional charge

• Total invoice

• Amount collected

• Total credits (the total dollar amount of credits (refunds) for this pay type for items returned today. Credits appear as negative dollar amounts.)

• Total invoices

• Totals for pay type

• Totals for pay plan type

• Totals for (date)

• Grand total


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

  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.

CS06_01r OROMS 17.0 2018 OTN