How do you remove a PO Returns Allocation amount from an Inventory Transaction?
I see an amount in the Inventory Status Inquiry screen for a specific ID and I cannot remove it.
I ran the IN Integrity Check, but that did not resolve the issue.
Thanks,
Chuck
*This post is locked for comments
I will review with my client!
Thanks!
I think that message provides you with your answer. You have to review the amount of cost being removed from the suspended batch transaction(s), compare that to the remaining cost in Inventory for the same item/site record, then make a "cost only" IN Adjustment for the difference so that the batch can release and the remaining qty/cost are both zero at the end.
That was the original issue. These batches will not release. We get the following messages: The PO Return Batch XXXXXX for item XXXXXXXX is reducing the quantity to 0 while leaving a cost for the item not equal to 0. This is possibly due to a remaining adjusted or Landed Cost on the item. Please adjust the item's cost for the amount of XX.XX through Adjustments (10.030.00) and re-release the batch. On 2 batches we had to adjust the cost down to match the original receipt cost. When we tried make this adjustment, we got the following message: A negative adjustment may not be made for item XXXXXXXX because the Batch XXXXXX is leaving the item quantity less than 0.
That is exactly what happened! How do I remove the PO Returns Allocation qty from each Inventory ID?
Thanks,
Chuck
It is possible that the PO Return batch was released and flagged as "Completed" out of the PO Module, but is sitting as unreleased within the IN module. Did you check to make sure there are no Batches sitting in the Release IN Batches screen?
Mark
Thanks for your feedback.
All of the PO Receipt batches that are giving me this issue have a status of C for Completed.
Thanks,
Chuck
This is an indication that there is an unreleased PO Returns Batch somewhere. Run the following SQL query:
select * from batch where module = 'PO' and status in ('B','H','S')
Any released PO batch that is processed in connection with the Inventory module would be set to Completed when successfully released. The above looks for any batches that are Balanced, On Hold, or Suspended, all of which can impact the PO Returns Allocation value.
Running the IN Integrity Check before addressing the batch issue will not resolve the Qty issue.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (