We have a lot of Purchase orders that are at cancelled and the individual line status is cancelled. However the some of the cancelled lines have a full or partial qty at "Ordered" Receipt Status on the InventTrans table.
We utilise workflow and resubmitting the order through workflow & ensuring the order is at Confirmed Approval Status does not resolve the issue.
Does anyone know a solution apart from deleting the records from the InventTrans Table or even better what might be causing this.
Thanks heaps in advance
Mel
*This post is locked for comments
Hey Andre,
Still trying to dig into how we have ended up with so many transactions with this issue, i suspect its workflow related...
I figured a data correction job would be the alternative, but was hoping there was a another option.
If we determine the cause, I will be sure to update the thread.
Hi Mel,
Usually, it is not possible to set the status of a PO line to cancelled when there are quantities remaining for invoice. Do you know how these orders were cancelled? You might need a data correction job for these lines now.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156