22,647
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
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.
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 :-)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (