Sales Order and Purchase Order Discrepancy Report

Sales Order and Purchase Order Discrepancy Report

The Sales Order and Purchase Order Discrepancy Report displays differences between the sales orders and purchase orders for a drop shipment so that you can identify where manual changes must be made. These differences arise when you modify the purchase order or requisition associated with a drop-ship sales order after successfully running Purchase Release.

Submission

In the Order Management Reports window, select Sales Order and Purchase Order Discrepancy Report in the Name field.

Parameters

When you request a Sales Order and Purchase Order Discrepancy Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria.

Sort By

Determine the output report sort option. Select from:

• Customer Name: Order Management sorts this report by the customer name associated with an order.
  
• Order Date: Order Management sorts this report by the order creation date associated with an order.
  
• Order Type: Order Management sorts this report by order type entered for the Sales Order Header.
  
• Purchase Order Number: Order Management sorts this report by the Purchase Order Number entered for the Sales Order Header.
  
• Sales Order Number: Order Management sorts this report by the Sales Order Number.
  

The default value is Customer Name. This is field is optional.

Open Orders Only

Determine whether to print all orders or only open orders.

• No: Include both open and closed orders to print
  
• Yes: Include only open orders to print.
  

The default value is Yes. This field is optional.

Order Number (From/To)

Enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
These fields are optional.

Customer Name (From/To)

Select a specific customer name or range of customer names on orders you want printed in this report.
These fields are optional.

Customer Number (From/To)

Select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
These fields are optional.

Order Dates (From/To)

Select a specific order date or range of order dates you want printed in this report.
These fields are optional.

Order Type

Select a specific order type that you want printed in this report.
This field is optional.

Order Category

Determine the types of orders you wish to print. Select from:

• All Orders: Include all orders selected based upon input parameters entered.
  
• Credit Orders Only: Include only orders that at least one return line.
  
• Sales Orders Only: Include only orders that at least one sales order line.
  

This field is optional.

Item

Select the item to print for the report output.
This field is optional.

Item Display

Determine how you wish to display item information for the report output. Select from:

• Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window).
  
• Description: Order Management will print only the Internal Item description.
  
• Flexfield: Order Management will print only the Internal Item name.
  
• Item and Description: Order Management will print both the ordered item name and the associated ordered item description.
  
• Ordered Description: Order Management will print only the ordered item description.
  
• Ordered Item: Order Management will print only the ordered item.
  

The default value is Description. This field is optional.

Purchase Order Numbers (From/To)

Select a specific purchase order number or range of purchase order numbers you want printed in this report.
These fields are optional.

Requisition Number (From/To)

Select a specific requisition number or range of requisition numbers you want to print on this report.
These fields are optional.

Report Output

The Sales Order and Purchase Order Discrepancy Report prints sales order and purchase order discrepancy details and displays the following 3 report sections sequentially for discrepancy selected.

• Order Header Information
  
• Order Line Information
  
• Purchase Order/Requisition Information
  

Order Management displays all report input parameters and respective input values selected on the first page of the report output.