Sales Order Master List Report overview

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.

The output for the 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.

These values are included on the report only if you have the correct security on your SA Operator Setup record to view them:

• Costs and margins

  Cost settings on your SA Operator Setup record determine if you can view costs and margins on the report. Depending on the settings, you can view all costs or no costs. If you can view all costs, the Original System Line Costs section is included for line items on the report. It shows the average, replacement, standard, and last costs from Product Warehouse Product Setup.

  If line item is a nonstock or catalog product, the cost is included in the View Cost Type Line Cost section.

• Commissions

  To view commission amounts for inside and outside sales representatives, Yes must be selected for the Allow User to View Commission Amounts setting.

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.