web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) How do you remove a PO...

Microsoft Dynamics SL (Archived)

How do you remove a PO Returns Allocation amount from an Inventory Transaction?

(0) Share

Report

Report

Posted on by Community Member

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 have the same question (0)

All responses Img

All responses (8)

Answers Img

Answers (2)

Community Member on at

Like (0)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

I will review with my client!

Thanks!

Was this reply helpful? Yes No
Verified answer

Mark E 6,451 on at

Like (1)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

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.

Was this reply helpful? Yes No
Mark E 6,451 on at

Like (1)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

Did you release the batch(es) that are sitting in the Release IN Batches screen? Releasing them will update the QtyOnHand and PO Returns Allocation values.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

That is exactly what happened! How do I remove the PO Returns Allocation qty from each Inventory ID?

Thanks,

Chuck

Was this reply helpful? Yes No
Verified answer

Mark E 6,451 on at

Like (1)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

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

Was this reply helpful? Yes No
Mark E 6,451 on at

Like (1)

Report

RE: How do you remove a PO Returns Allocation amount from an Inventory Transaction?

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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans