Printing the Sales Journal by Currency Report (PSJC)

Purpose: Use this menu option to print the Sales Journal by Currency Report based on a selected invoice date range and optionally currency code. This report provides a detailed audit trail of all sales transactions for a specified invoice date range, including all shipments, returns, credits, and no charge sales transactions, grouped by currency, invoice date, pay plan type, and pay type. The system registers a sales transaction when a shipment occurs.

This report is used to review sales by currency if you use alternate currency pricing (the replace system control value is selected). See Using Alternate Currency Pricing for an overview and required setup.

This report provides:

• a detailed listing of sales activity for a specified invoice date range and currency.

• totals for each currency, pay type, pay plan type, and invoice date in the local currency and the alternate (foreign) currency.

• a grand total across all paytypes and currencies in the local currency.

Understanding this report: This report provides information about the individual charges on each invoice, grouped by currency, invoice date, payment plan, and pay type.

The individual order charges in the Merchandise, Freight, Additional freight, Tax, Handling, and Additional charge columns on the left side of the report are totaled in the Total invoice field on the right side of the report.

This report provides totals for the number of credits (refunds) and invoices (shipments) for each currency, invoice date, payment plan type, pay type combination. A page break occurs between each currency, invoice date, payment plan type, pay type combination. A grand total displays at the end of the report.

Print Sales Journal by Currency Screen

Use this screen to select the invoice date range and currency code(s) to print on the Sales Journal by Currency report. If you do not select a currency code, the system prints the report for all currencies based on the invoice date range you define.

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

Field	Description
Invoice date range	The date range for which you wish to run this report. The invoice date range represents the dates on which shipments occurred. Both fields default to the current date. Numeric, 6 positions (in user date format); required.
Currency code	The currency associated with the invoices you wish to print on the report. Only invoices and invoice credits associated with the currency you select, print on the report. Leave this field blank if you wish to print the report for all currencies, based on the invoice date range you define. The currency associated with the invoice is defined in the Order Header Extended table. The conversion rate is also stored in this table. If the currency code and conversion rate in the Order Header Extended table are blank, the invoice is for the local currency. Currency codes are defined in and validated against the Currency table. Alphanumeric, 3 positions; optional.

How to print: Enter or verify the date range for which you wish to print the Sales Journal by Currency Report. The current date defaults. Select Submit to generate the report. A message indicates that the job has been submitted.