Invoice and Shipment on PO

(0) Share

Report

Posted on by Bill Campbell

We have a situation where we can see that there is a shipment attached to a PO and the status shows RECEIVED, however, there is also an INVOICE attached.

Problem is that the INVOICE does not have any item on it - there is a dollar value and this is causing issue.

1 - how do we remove the INVOICE as it is 'corrupted'

2 - re-enter the INVOICE and reapply to the PO

Thanks.

*This post is locked for comments

All responses (2)

Answers (0)

Bill Campbell 12 on at

Like (0)

Report

RE: Invoice and Shipment on PO

Mariano, thanks for the confirmation on SQL - I figured this was the only way to fix this. I will inform client and get the necessary Backups completed. Unfortunately the current TEST system does not have the 'problem' and the IT can not get a recent backup restored to the current TEST platform as they have an issue in 'technology'

Anyway, not to air dirty laundry.
Mariano Gomez 26,225 on at

Like (1)

Report

RE: Invoice and Shipment on PO

SQL is your best friend here. You will want to remove the invoice from the POP_ReceiptHist (POP30300) and the POP_ReceiptLineHist (POP30300). Once you do that, you should be able to re-enter the invoice. Now, I don't need to tell you, you need to backup your databases and preferably, test in a TEST environment, before executing in a production environment :-)