Inventory on-hand wrong value

(0) Share

Report

Posted on by Community Member

Hi,

We have a process where we add some amount of inventory of an item that is then picked onto a production order. The process is posting a counting journal, then posting a picking journal. We have seen some cases where the on-hand "physical available" was wrong after that process happened.

Here is a screenshot of one of the cases:

After the production picking, there should be 0 left. but there was 9.61 left that I was able to re-count to zero. This means inventory transactions actually go below zero for this item.

Also, I would add that between the two journals, I added this because sometimes the picking wasn't working because it was saying not enough inventory:

inventSumReCalcItem = new inventSumReCalcItem(itemId,true,CheckFix::Fix);
inventSumReCalcItem.updateNow();

Any idea how this could happen? The picking journal should have set the physical available to zero. Any idea where to look this fix this?

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Is negative physical inventory ticked on the inventory model group? This shouldn't be the case (in most scenario's that is).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Right now the physical is uncehcked but the financial negative is ticked.

But the actual InventSum for this item is not below zero at the moment. Only the totals of the transactions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Here is what the on-hand right now shows for this item:

It shows that there is now 0 physical available.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

RE: Inventory on-hand wrong value

On the Item's Storage Dimension Group, is 'Physical inventory' ticked for all dimensions which are active?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Yes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Is this "Process" an external process or a regular in AX? Just asking...we had some similar issues and it occured that the WHSInventReserve was out of sync. All Invent-Onhand was broken. We tried to re-calc the InventSum...no success. The InventSum-WHsInventReserve-Structure is very sensitive :o)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

It is done in X++ but called from a business connector.

We construct a counting journal and post it. Then search for the production picking list and post it.

How do we make sure it stays on synch?

The journal postings are supposed to take care of that, no?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

Yes normally the Framework takes care of it. In our case the Reservation hierachy was broken and caused chaos. There was another case but i don't remember exactly what it was. I posted it her somewhere. I'll take a look.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

If I have an item that is "bugged" by this behaviour, where can I look to see where there is a mismatch? Or is there anyway of doing a query to "check" that all is in synch?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory on-hand wrong value

I suspect there is no quick solution. If there is one tell me :-). But i remember we had problems after creating and posting journals. It happend on our Dev-System and after hours of debugging and 'corrections' we finally killed all transactions and created/posted the jounals again. Unfortunatelly i don't remember what the solution/problem was.

Edit:

I don't think it's your reservation hierarchy because in this case all OnHand would be broken. Search the WHSInventReserve for your Item/InventDim if you haven't already. Maybe you'll find a 'mismatch'.

Was this reply helpful? Yes No