Description:
- Issue:
Buyers have created the Purchase Orders with wrong items, and they have submitted for Approval process. Then the PO has been Approved and Fully Received. The fully received items are consumed by the warehouse.
Now, if they try to perform the Return or Cancel actions for those problematic PO Lines, the system is not allowing to do that.
- Root Cause:
- Those lines are fully received. So, the system will not allow to Cancel the fully received lines.
- There were no On Hand Quantity in that sub-inventory, and moreover, many records got stuck in “Transaction Status Summary” form. So, the system will not allow to do the Returns.
- One more thing, PO Order Quantity is less than the PO Due Quantity.
- Errors:
Error Message During Cancellation:
| Error: Shipment #1 You cannot finally close this & LINE_LOCATION_TYPE because unprocessed receiving transactions exist. |
| Error: Line #5 Shipment #1 You cannot cancel a fully received purchase order. (Quantity ordered is 2. Quantity received is 2.) |
Error Screenshot:
Error Message During Returns – Core Purchasing using Returns Form:
| APP-PO-14888: Primary quantity 1 exceeds available sub inventory quantity 0 |
| Cause: The transaction quantity 1 in the primary unit of measure exceeds the available quantity 0 in the sub inventory. |
| Action: Enter a smaller quantity. |
Error Screenshot:
Error Message During Returns – iProcurement Form:
| Your receipt could not be created successfully due to an unexpected error. Please contact your system administrator with the following information for further assistance. |
| “rvtptcontrol failed RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned an internal error. Action: Note RVTVT-065: Subroutine afdname() returned error Cause: Subroutine afdname() returned an internal error. Action: Note this error number and the actions you are trying to perform. Conta NEGATIVE BALANCES NOT ALLOWED Cannot read value for profile option INV_DEBUG_TRACE in routine &ROUTINE.” |
Error Screenshot:
- Transaction Status Summary:
Navigation: Receiving > Transaction Status Summary
Query the PO and the problematic lines
Many of the transactions got stuck in “Transaction Status Summary” form for this PO.
- PO Shipments – Purchase Order Summary:
Query the PO Shipments in Purchase Order Summary form
Ordered Quantity = 2 Quantity Due = 3 Quantity Received = 2
Ordered Quantity < Quantity Due
- Solution:
Step 1: Delete all the stuck records in “Transaction Status Summary” form and Save.
Step 2: Once you clear the records in “Transaction Status Summary” form, query the PO Shipments in Purchase Order Summary form for that PO and check the “Quantity” and “Quantity Due.”
Now, the Quantity and Quantity Due becomes equal.
Step 3: Increase the On Hand Quantity for those problematic Items (Cycle Counting Process). Make sure the OHQ should be equals to quantity returns.
Step 4: Once you have the On Hand Quantity for those items, perform “Returns.”
Now, the system is allowing to do the “Returns” without any issues.
Step 5: After Returns, Cancel the PO Lines
Now, the system is allowing to Cancel the problematic PO Line without any issues.
Cancel the other problematic PO lines also.
All three problematic PO lines have been successfully canceled.
Summary:
Once the system dispatches a purchase order, you can cancel the entire dispatched purchase order, or you can cancel all lines without canceling the entire purchase order. On a dispatched purchase order, if you click the Cancel PO (cancel purchase order) button, the status of the purchase order changes to Pending Cancel. Then once you dispatch the purchase order again, the order is canceled.
Queries?
Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.
