Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders

Release Date - 2/20/19

This feature gives the user the ability to calculate the Order Total Sales Amount. This ability has been added to the Order Integrity Check utility program. It is available from Global Setup-> Utilities-> COP Utilities-> Utility-> Order Integrity Check. Two new options have been added to this application:

1. Update Order Total Sales Amount for Open & Non-Picked Orders? - The default value is N. If Y is entered, the order total sales amount will be calculated for all open non-picked "O," "B" and "Q" type orders.
                                                                   
2. Update Order Total Sales Amount Based on Qty Ord or To-Ship? - The default value is S. This field is only available if the user answered Y to field 1. If O is entered, the order total sale amount will be calculated using the quantity ordered.  If O is entered, the order total sale amount will be calculated using the quantity to ship.

Note:

• "I" and "C" type orders are not updated.
• For “Q” or “B” type orders, we calculate the order total sales amount based on the quantity ordered.  
• We only update “O” type orders if it is “Complete” and Pick Ticket has not been printed.  
• Any line item that’s already posted is skipped.
  

The report that is generated prints the before and after value for the order total sale amount. Two new accumulators are available showing the total number of orders changed and if any size error was encountered during the calculation.

Currently, when Elliott prints pick tickets, it will automatically calculate the total line items printed on the pick ticket and update the order total sales amount. This is important if you need to get the total COD amount or calculate insurance with the shipping manifest system.

But before the pick ticket is printed, the Elliott sales order's total order sales amount field in the order header (CPORDHDR table) is not guaranteed to match the line item amount. This is especially true if you don't access the billing screen when you revise the line items of an order. Therefore, when users try to retrieve total order sales amounts from third party tools like Crystal Reports, or Excel Query, they cannot rely on the order total sales amount value.  As a result, they have to calculate the order total sales amount based on the line items on the order, and the logic is complicated.  This option is intended to resolve this kind of problem.

Programs Modified: CPORDCHS, CPORDCHK

CLS

• Related Articles

• Avalara Setup Procedures - Integrity Check

  Release Date: 4/28/23 Date Revised: 6/10/24 Version: 8.6 and Above You should run Avalara integrity check on daily, weekly or monthly basis. The frequency depends on if you can commit resources for someone to look at the output of this report and ...

• Feature - Order Ship Status Auditing Report

  Release Date - 7/14/16 The Order Ship Status Auditing Report is available under COP -> Processing -> Pick/Pack tickets & Ship Label -> Shipping -> Order Ship Status Auditing Report. The feature gives the user the ability to reconcile EDI orders ...

• How to Find All Open Sales Orders

  Release Date: 04/24/2025 Version: 8.x & Up Q - I am inquiring if there is a way in Elliot to find out all the open Sales Orders. We are trying to see if there are any orders that have not been closed yet and also have visible of all of the items that ...

• Feature - New Summary Area for Open Orders by Customer / Fill Back Orders by Customer Report

  Release date: 5/26/2017 You may now optionally print new totals in the grand total area of the Open Orders by Customer / Fill Back Orders by Customer report. Three Global Setup flags have been added to Global Setup -> Cop-Func -> Print ...

• Feature - BOMP Integrity Check Utility

  Release Date: 07/22/2011 You can access this utility from Global Setup -> Utilities -> BOMP Utilities-> Utilities-> BOMP Integrity Check. The purpose of this utility is check the integrity of two database tables: Bill of Material Product Structure ...