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 ...

• 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 ...

• CPRESORD Customer Order Processing Release Held Orders

  Release Held Orders Application Overview This feature is a function of the Credit Check & Release program. To run this function, the Credit Check & Release must be setup as per the Global Setup documentation. Run Instructions From the COP Menu > ...

• 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 ...

• CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

  Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...