Flush on-hand quantities

(5) Share

Report

Posted on by MYGz

2,059

Hi,

I performed the following steps to flush the on-hand quantities which are visible on the on-hand list form.

1. Completed pending documents like partially received POs, shipped TOs etc.

2. Delete all draft documents.

3. Posted counting journal making all item on-hand 0.

4. Ran inventory revaluation and closing.

After these steps, there is still Ordered in Total, On Order and Available for Reservation Quantities are showing on a product which has 0 total quantities if transaction details are checked. How to rectify this?

Here's the transaction details for the first Item, The total is 0:

Appreciate any tips on how it can be resolved.

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Peter Kulikov (N.pr... 579 Super User 2025 Season 2 on at

Like (1)

Report

Flush on-hand quantities

Hi!
You have 4 transactions "Purchased" and 4 transactions "Sold" - so, it exactly adds up to zero in "Available for reservations".
But you also have a transfer with Ordered and On order quantities. Let's check do you have option "Reserve ordered items" activated:
Go to Inventory management - Seup - Inventory and warehousemanagement parameters and check this:

If it sets to YES, then your transaction in status "Ordered" gives you 1 available item for reservation.

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

Flush on-hand quantities

Hi @Peter Kulikov (N.progression)

Thanks for your response.

Yes, "Reserve Ordered Items" is enabled in the Inventory Parameters. On switching it off and running the on-hand list, the Available for Reservation column goes to 0 ie blank value "".

But how can I flush the ,Ordered and On order quantities? There's no pending document in the system. The only problematic thing is negative inventory was turned on as it's a retail implemenation.

Appreciate your input.

Thanks & regards,

Was this reply helpful? Yes No
Peter Kulikov (N.pr... 579 Super User 2025 Season 2 on at

Like (1)

Report

Flush on-hand quantities

Do you know what is the source for these transactions?

And then "General" Tab

Is there a number of document?

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

Flush on-hand quantities

@Peter Kulikov (N.progression)

Nothing here, it's a Movement/Transfer journal I think. But it doesn't shows anything here. I have also run "Inventory Journals Cleanup".

Was this reply helpful? Yes No
Suggested answer

Peter Kulikov (N.pr... 579 Super User 2025 Season 2 on at

Like (0)

Report

Flush on-hand quantities

Yes, it looks like transactions from Transfer Journal.
Can you try to find Transfer journal here: Inventory management - Journal entries - Transfer using the journal number from the line:

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

Flush on-hand quantities

Hi @Peter Kulikov (N.progression)

That journal is not there in the inventory journals. On Running the Inventory Journal Cleanup it clears the inventory journals which are just worksheet journals.

Was this reply helpful? Yes No
Verified answer

MYGz 2,059 on at

Like (0)

Report

Flush on-hand quantities

I was able to resolve this by running Journal Data Cleanup. It resolved the orphaned records.

Was this reply helpful? Yes No