Sales Order Master List Report overview

Sales > Reports > OE Reports > OE Order Master List

Function acronym: OERM

Use this report to print all information about an order.

This report is one of the most effective tools available for identifying problems with an order because of the extensive information that is printed. The report provides a large amount of analysis information. If a problem exists with an order, print this report to determine the cause of the problem.

The master list report includes the information that you specify each time you enter an order. It also includes internal information that is stored with the order transaction record. This report is often referred to as a file dump. Print this report for all types of orders and in any stage, as long as the order has not been deleted.

These values are included on the report only if you have the correct security to view them:

  • Costs and margins are not shown on the report if you do not have security set up in SA Operator Setup to view costs.
  • Commissions for the inside and outside sales representatives are not shown if you do not have security set up in SA Operator Setup to view commissions.

The output for the Sales Order Master List Report can be lengthy. Specify ranges and options to limit the report to only the information you require. On the average, each order prints at least 5 pages of information.

If enabled, fields are displayed as part of the report for Catch Weight functionality:

  • Actual Total Weight: The Actual Total Weight column shows the catch weight specified during Sales Shipping Feedback Entry.
  • Catch Weight Product: Yes is displayed if the Catch Weight Product option was selected in Product Setup-General-Catch Weight. Special processing is performed to handle catch weight products. Catch weight functionality manages the unit of measure, the conversion, and the recalculation required to stock and sell a catch weight product.

If enabled, fields are displayed as part of the report for National Program functionality:

  • In the Other Header Information section:
    • National Program (NP) Line Count: This field shows the number of lines that were priced for National Program (OEEH.nplinecount).
    • National Program (NP) Ship Amt: This field shows the total amount (0.00) for the shipment (OEEH.nptotshipamt).
  • In the Other Line Item Information section:
    • National Program: This field shows whether the National Program flag is selected in PD Pricing Setup-National Program (OEEL.npfl).
    • PDSN Record #: This field shows the record number generated by the system during setup in PD Pricing Setup-National Program (OEEL.pdsnrecno).
    • National Program Code: This field shows the code specified during setup in PD Pricing Setup-National Program (PDSN.npcd).

If enabled, the Verify Invoice field is displayed as part of the report for the sales order invoice verification functionality. This report field shows the value specified in the Require Invoice Verification field in the sales order.