Feature - Prevent Cancelling PO Line Items Where Qty Received Not Equal to Qty Invoiced

Feature - Prevent Cancelling PO Line Items Where Qty Received Not Equal to Qty Invoiced

Release Date: 4/16/2024
Version: 8.5 & Up

Background


In the past, a buyer might have decided to cancel an order without knowing that their order had already been received at their shipping address (e.g., a warehouse). As one can imagine, the result of this can be rather bothersome. This feature adds a safeguard for buyers so they don't accidentally cancel an order if it has been received already.

Feature


To be precise, this new feature prevents cancelling a purchase order header or line item if the quantity received is not equal to the quantity invoiced. This statement is rather abstract, but it has its use cases. In more practical terms, it prevents users from cancelling a purchase order header or purchase order line item if the receiving has been posted already. If such a scenario occurred, the following message will appear.



As stated earlier, this is a safeguard. It prevents the user from doing something they shouldn't, such as cancelling an order that has already arrived at their warehouse. See the next section for how to set up this feature.

This feature works whether an order is cancelled at the order header level or at the line item level. 

Cancel at the Purchase Order Header Level


To cancel at the purchase order header level, go to Purchase Order & Receiving > Processing > Purchase Order Processing > caNcel and type the P.O. number you would like to cancel. You will be prompted to cancel an order. If the item has been received already, you will be prompted with the following message:

Cancel at the Purchase Order Line Item Level


To cancel at the purchase order line item level, Purchase Order & Receiving > Processing > Purchase Order Processing > Change, enter the PO number you would like to edit, and then enter "Y" when prompted to edit line items.


Access field 7 and cancel the order by setting "7. Cancel?" to "Y."


But if you've already received the order, you will be prompted with the following message.

Setup


Only one Global Setup flag has to be changed in order for this feature to be active. Go to System Utilities > Utility > Global Setup > Dist > P/o global control. Press Enter twice to access the third screen. You will find the new flag under "45. Allow to Cancel PO Line If Qty Recv != Qty Invoiced?" (Note: '!=' means 'not equal to').

By default, the flag is "Y." To turn this feature on, set the flag to "N."

Technical Details


This feature was created in response to a feedback poll, and this feature is useful when the user needs to safeguard themselves from cancelling an order that has already been received. But technically, it's not only limited to this case, since under the hood what really is being checked is if the order line item quantity received is equal to the order line item quantity invoiced. So if, under a strange circumstance, the number of items invoiced is greater than the number of items received, the same error message will pop up.


Programs Modified: CP0111, NSCTLINI, NSCTLMN3


AWK


    • Related Articles

    • Canceled PO Line Items Still Exporting on EDI

      Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

    • Create PO Receiving Event to Trap Negative Qty on Hand Problem

      Q - Sometimes our receiving department is behind with their tasks in updating received quantities in the Elliott inventory. As a result, it creates a negative quantity on hand in Elliott. The items sold during the period use the old average cost. ...

    • Feature - Newly Received Item Inquiry with Date & Category Range Plus Show Total

      Released Date: 03/08/2025 Version: 8.5 & Higher In COP -> Inquiry -> Newly Received Item Inquiry, it prompts for three parameters: Rec Date: You can either enter a single date or press Enter for ALL Category: You can either enter a single category or ...

    • BM1501 Bill of Material Feature/Option Configuration Maintenance

      BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...

    • CPISSULS Customer Order Processing Issue Serial/Lot Component Items

      Issue Serial/Lot Component Items Application Overview After posting invoices to Accounts Receivable which includes a line item which is non-stocked and controlled and has a product structure which contains Serial/Lot components, a record for each one ...