Order Lookup by Customer and Ship-To

Order Lookup by Customer and Ship-To

We use the Order/Invoice History Inquiry by Customer function often. For our chain store customers, is there a way to look up details by Customer/Ship-To rather than just Customer? 

A. Yes. The following are two methods to achieve this.

Method 1 - Use the GUI Open Orders or Invoice History Inquiries

In COP Order Inquiry by Customer/Order or Invoice History Inquiry by Customer/Invoice,  enter the corresponding customer number. Your cursor will be at the order/invoice number.  You can click the Special Functions icon and select Open Orders Inquiry or Invoice History Inquiry. This will bring up a GUI window of the orders or invoices for that customer. You can then click the column headings to select a method to sort the information by -- including by ship-to.   See the sample screen below:


Method 2 - Use Search by Ship-To in Order/Invoice History Inquiry

In COP Order Inquiry by Customer/Order or Invoice History Inquiry by Customer/Invoice,  enter the corresponding customer number. At the Order/Invoice Number field, you can press F8 to look up by ship-to. This will display all the open orders for that ship-to. See the sample screen below:


If you don't see the F8 option to look up by ship-to, you need to check the following Global Setup flag -> Cop-Func -> Order Header Screen: 

5. Duplication Criteria For PO # in Sales Order ? 

Most likely, the current value is set to "N." We suggest changing it to "S" (for Ship-To).  Then the system will display a window asking an additional question: "Checking for Duplication Over if PO# is All Alphabetic ?" Answer this with "N."  See the sample screen below:


The direct impact of doing this is that when you enter a sales order, if the same PO# already exists for the same customer and ship-to, the system will give you a warning message. This is a great feature if you do business with chain stores because it prevents duplicate sales orders from entering into the system.

Why would this be related to the F8 search by ship-to? Well, when you set the above global setup flag 5 to anything other than "N," the system will  start to create a cross-reference record in table CPPOREF. In addition, the CPPOREF table will provide the searching capability by ship-to, which enables us to provide the F8 key.

After you change the above flag in Global Setup, you need to go to COP -> Util-Setup -> Generate PO Reference. This will create the CPPOREF table based on the current sales order. Then you can try to do the F8 search by ship-to again. See the sample screen below:






    • Related Articles

    • ARSHPMNT Accounts Receivable Ship Via Code File Maintenance

      Ship Via Code File Maintenance Application Overview When you are setting up your Customer file, you will be asked to enter for each customer a Ship Via Code. This code will designate the usual method that you use for shipping purchased goods to this ...
    • AP1901 Accounts Payable Ship Via Code File Maintenance

      Ship Via Code File Maintenance Application Overview The Ship Via Code File represents the method of shipment normally used by the vendor. It is used in the Purchase Order and Receiving package when purchase orders are being entered. Whenever the Ship ...
    • ARCUSMNT Accounts Receivable Customer File Maintenance

      Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...
    • Allow Auto Popup Customer or Item Notes in Order Entry with Read Only Option

      Release Date: 11/25/2020 Version: 8.5 & Up In Global Setup -> System -> Note Function, there are these two flags: 23. Auto Pop Up Customer Note During Order Entry? 24. Auto Pop Up Item Note During Line Item Entry? In addition to "Y" or "N," we now ...
    • Add Ship Via Code Selection to Shipped Data Export (ASN)

      Release Date: 04/17/2021 Version: 8.5 & up In COP -> Utility -> Sales Order Export -> Shipped Data Export, a new parameter "Ship Via Code" is added. Users can use the F4 key to select by "Ship Via Group" instead. See sample screen below: The ship via ...