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

• PO1800 Purchase Order and Receiving Open Purchase Orders Reports

  Open Purchase Orders Reports Application Overview The Open Purchase Orders Reports application enables you to identify items that were ordered and not received into inventory. You can select to print the report in vendor or item number order. It can ...

• Feature - Sales Promotion Desk

  Release Date - 8/30/16 Sales Promotion Desk IntroductionIn Elliott Business Software, Item Master table, we have the following fields that allow users to put an item on sale: Start Sale Date End Sale Date Sale Price If customers purchase this item ...

• Sales Orders Import Utility Does Not Import the Freight Amount

  A - I use the Sales Order Import utility. In my import ASCII file, I verify that the freight amount is placed in the correct position. However, after the sales order is imported, the imported sales order shows zero freight amount. Why is that? Q - ...

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

• CPSLSDSK Customer Order Processing Sales Desk

  Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...