Hello,
When inquiring on a PO we receive the following message:
Receipt of good XXXXXXX in batch is currently referencing this PO and can't do anything with it..
Any ideas??
Query PO_ReceiptHeader to see if it is there but missing the batch header.
If nothing is there, remove the row referencing this PO / receipt from PO_ReceiptReturnMatRqByPO
So the 187860 is the batch in question so you want me to delete this??
If there is no actual receipt in the data entry tables, yes. That table helps prevent multiple open transactions against a PO, and sometimes a row is mistakenly left behind (causing the message you are asking about).
There is no batch receipt in either Receipt of Goods Entry or Invoice Entry tables reference that number 187860.
Don't rely on the Sage interface, check the raw table (ODBC query or DFDM). For type "G" and "I" records, that would be PO_ReceiptHeader. For "R" records, that would be PO_ReturnHeader. For "M" records, that would be PO_MaterialReqHeader.
Don't rely on the Sage interface, check the raw table (ODBC query or DFDM). For type "G" and "I" records, that would be PO_ReceiptHeader. For "R" records, that would be PO_ReturnHeader. For "M" records, that would be PO_MaterialReqHeader.
Yep nothing in any of those tables..
Then it should be safe to remove that row from PO_ReceiptReturnMatRqByPO
Hello Kevin,
That worked the error message is no longer... Thanks again for help
Thanks saved me much aggravation! Perfect solution!
*Community Hub is the new name for Sage City