Sales Orders, Quotes and Credit Memos > Sales Transaction Reports > Order/Invoice Quantity Difference Report

Order/Invoice Quantity Difference Report

Related Topics

The Order/Invoice Quantity Difference report allows you to track the difference between the original order quantity and final invoiced quantity for sales order detail lines and work order components, for example to track order lost or increased sales by item across all orders. The report includes only fully invoiced sales orders that meet the selected criteria. The report excludes orders with a header status other than Invoiced, deleted detail lines or work order components, and detail lines or work order components where the original order quantity matches the total invoiced quantity.

This feature is unrelated to the lost sales quantity displayed on the Sales Order Entry screen, which tracks quantity auto removed from the order because quantity was unavailable and the customer does not accept backorders.

J:\Learning Systems\Agility Help\Sales_Transactions\Bitmaps\path_icon.gif Access Order/Invoice Quantity Difference: Sales Orders/Quote Queries/Reports Order/Invoice Quantity Difference

Notes:

Your security access determines which branches are available.

Refer to Relative Dates for detailed information about auto calculating the Order Date criterion at the time you run the query.

In addition to the selected sort option, the final sort order is by item, work order vs. detail line, and transaction ID.

Processing Rules

In summary mode, the report displays the quantity and extended price differences per item, plus totals by branch and report totals. Additional columns includes the branch, item, size, description, original quantity, and invoiced quantity. For sub-assembly parent items, the report lists the extended price only for the sub-assembly components. The sub-assembly parent price displays as zero.

In detail mode, the report displays the quantity and extended price differences per transaction, plus totals by branch and report totals. All of the summary mode columns display, plus transaction ID, customer ID, customer name, entered by, sales agent 1, order date, and whether the item is a work order component.

The WO Comp column displays C to indicate work order components and K to indicate kits or sub-assembly parents. This column is blank for sales order detail lines. If an item is included on the order as a detail line and as a work order component, the item displays twice on the report.

The original order quantity is stored in the SO_DETAIL.ORIG_STOCK_QTY_ORDERED and WO_COMPONENT_DETAIL.ORIG_STOCK_BOM_QTY fields, in the stocking unit of measure. These fields do not display on any screen and are only available within the database for querying. For dimension items, the system saves only the total detail line quantity or component quantity.

Values Saved to the Original Quantity Fields

The original stock quantity fields initially default to zero and are auto updated only one time for each detail line or work order component.

Sales order detail line Upon saving the sales order header, if the order quantity is greater than zero

Work order component Upon saving the parent item detail line to the sales order, if the component order quantity is greater than zero

Processing Rules

Once a value greater than zero is stored in the original stock quantity fields, the values are never adjusted for the item throughout the ordering process, even if you change the order quantity or cancel the order. 

If you overwrite the item number on a saved detail line or work order component, the system resets the original stock quantity field to zero for the new item and follows standard processing rules to save an initial quantity for the new item. The system does not store/track the item number or original ordered quantity of the original item number that was overwritten.

If you cancel or delete a detail line, no order information is retained.

J:\Learning Systems\Agility Help\Bitmaps\tip.gif

To track all original order quantities, DMSi recommends you reduce the order quantity to zero rather than cancel or delete a detail line.

For sales orders created by releasing a quote, the system copies the current order quantity as the original order quantity only if Default Status for SO from Quote is blank on the User Preference screen. If Default Status for SO from Quote is set to In Process, the system sets the original order quantity to zero until save, at which time the system stores the current order quantity as the original order quantity.

When you duplicate a sales order, the system copies the current order quantity (rather than the original order quantity) as the original order quantity on the new sales order.

For orders with multiple shipments, the total invoiced quantity equals the sum of the total shipment quantities. To accurately determine the total invoiced quantity for orders with multiple shipments, the order must be fully invoiced and you must include the total of all shipments.

See Also

Accepts B/O Flag on Sales Orders

Backorder Processing


Distribution Management Systems, Inc.
17002 Marcy Street
Omaha, NE 68118