PO stuck in batch

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.

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