Printing the Sales Journal (PDSJ)

Purpose: Use this option to specify the date range, and optionally, the division for which you want to print a Sales Journal. This report provides a detailed audit trail of all sales transactions for the specified date range (and division, if specified), including all shipments, returns, credits and no charge sales transactions. The system registers a sales transaction when a shipment occurs.

This report provides a detailed listing of sales activity for the specified invoice date range.

Understanding this report: This report is divided into two halves; the left half provides sales information relating to each invoice and the right half provides information about how each sale was posted. The invoice totals on the report are from the Invoice Ship To record.

Out-of-Balance Invoices

If an invoice is out of balance: An invoice is flagged as out of balance on the Sales Journal and Sales Journal by Division if the total Merchandise, Freight, Additional freight, Tax, Handling, and Additional charge for all Invoice Pay Method records do not equal the corresponding totals for the Invoice Ship To record. If the Invoice Pay Method total is higher than the Invoice Ship To total, the out-of-balance amount is negative; otherwise, if the Invoice Pay Method total is lower than the Invoice Ship To total, the out-of-balance amount is positive.

How can an invoice be out of balance? Invoices should ordinarily never be out of balance, but sometimes it is possible for this situation to occur if, for example, there is a rounding difference in the tax calculation on an order with multiple payment types.

Error report: Use the Printing Sales Journal Errors (PSJE) menu option to print a report listing just the out-of-balance invoices for a time period.

Fixing an out-of-balance invoice: Contact your Order Management System representative for assistance in fixing an out-of-balance invoice.

Reporting by Division

When you run the report, you can choose to run it by division. If so, the report lists all sales transactions for the division and starts a new page for each division. The division code is determined by the source code used on the order header.

If you do not print the report by division, the report lists sales transactions in invoice number/date sequence.

How to display this screen: Enter PDSJ in the Fast path field at the top of any menu or select Print Daily Sales Journal from a menu.

Field

Description

Invoice date from

The beginning date to include on the report. The invoice date represents the date when the shipment or return credit occurred. This field defaults to the current date.

Numeric, 6 positions (in user date format); required.

Invoice date to

The ending date to include on the report. The invoice date represents the date when the shipment occurred. This field defaults to the current date.

Numeric, 6 positions (in user date format); required.

Print by division

Indicates whether you want to sort, subtotal, and page break the report by sales division. If not, the report lists all sales transactions sorted by invoice date/number.

Valid values are:

Selected = Sort the Sales Journal by sales division; see Sales Journal by Division.

Unselected (default) = Sort the Sales Journal by invoice date and invoice number; see Standard Sales Journal.

Instructions:

1. Enter or verify the date range you want to include on the Sales Journal. The system defaults the current date in the Invoice date from and Invoice date to fields.

2. Select the Division field if you want to print sales transactions grouped by sales division (the Sales Journal by Division); otherwise, the report lists sales transactions by invoice number/date (the Standard Sales Journal).

3. Select OK to accept your entries.

4. Select Accept to print or reprint the Sales Journal for the specified invoice date.

CS06_01 OMSCS 19.0 December 2019 OHC