How to Skip Range of Orders in COP Order Inquiry
Release Date: 09/20/2018
Q - Currently, the COP Sales Order Inquiry screen is designed to show the last order number first. My COP sales order is approaching 999999. I intend to reset it to 1000 through COP setup before it rolls back to zero or something. When that happens, in our Order Inquiry screen -- which is now sorted by the reverse sequence of the order number -- it will no longer show our newest orders at the top. We have to scroll _all the way down_ to get to our newest orders starting from 1000…. See sample screen:
Any recommendation for this scenario?
A - There is a solution that can help you. For our example, we have two different order ranges. One is in the range of 900000, and the other is less than 100000. This scenario is common if Elliott users decide to keep the regular Elliott orders, EDI orders or web orders in different ranges. As you can see in the following example, the Elliott order number is reaching 904344:
If you want to see the order number that's less than 100000, how do you get to those orders without scrolling through all the 900000 series of orders? To do that, you would first press the F1 key at customer#. Then, at the order number field, enter 100000 first before pressing the F1 key. See screen below:
As the result of entering 100000 first before pressing the F1 key, it brings up the first order before 100000, which in this case is 70390. See sample screen below:
This principle works for any order number range: you can simply enter the starting point of the order number and then press the F1 key. The sample principle applies to the F2 key (List All Orders).
Because of this feature, you can have multiple ranges of orders and you still can get to those orders quickly without scrolling through from the end.
EMK
Related Articles
How to Skip Range of Orders in COP Order Inquiry
Release Date: 09/20/2018 Q - Currently, the COP Sales Order Inquiry screen is designed to show the last order number first. My COP sales order is approaching 999999. I intend to reset it to 1000 through COP setup before it rolls back to zero or ...Feature - Update Newly Received for Plus Work Order Copied from COP
Released Date: 02/20/2025 Version: 8.5 & Up In Elliott BOMP Plus Work Order, when a production is completed and posted, it will not update the Newly Received (CPITMREC) database if the plus work order was originally copied from the COP sales order. ...All of a Sudden COP Open Order Report Takes Forever to Complete
Q - I have been running COP / Reports / Order Status Reports / Open Order Report / All Items / By Customer Sequence. A couple of weeks ago, this report's run time all of a sudden jumped exponentially (like from 10 seconds before it was done to, now, ...AP0400M Accounts Payable Vendor Account Inquiry
Inquiry Vendor Account Inquiry Application Overview Whenever you need information on a particular vendor's account or a particular invoice, Vendor Account Inquiry is the application to use. This application displays the vendor's name, terms, invoice ...ARACTINQ Accounts Receivable Customer Account Inquiry
Customer Account Inquiry Application Overview This feature Customer Account gives you a quick and easy procedure to display a customer's account by both Open Item and previously purged records in the Open Item History File. Inquiry views include ...