Microsoft Dynamics AX (Archived)

Clearing the Inventory

(0) Share

Report

Posted on by brianmaric

Hi I need to set the inventory to 0.

It has no cost.

Can I just loop through the inventtrans table and set physical available to 0?

Thanks in advance.

*This post is locked for comments

All responses (15)

Answers (1)

Verified answer

brianmaric on at

Like (1)

Report

RE: Clearing the Inventory

I found the solution.

I can update the tracking dimension in a job and then it lets me change the inventory
brianmaric on at

Like (0)

Report

RE: Clearing the Inventory

it's not a record that was deleted. It is the presence of a value (the batch number) where it is not allowed as dictated by the tracking dimension 'sa'

a value exists where it is not allowed and this makes the record impossible to access.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Clearing the Inventory

Do you have any modifications implemented in the system that might cause this behavior? I'm especially wondering about the asset and ownership dimension. Sounds like a rental scenario where items are linked to fixed assets.

Are you aware of such kind of modifications that might be related/responsible for this?

Best regards

Ludwig
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Clearing the Inventory

Unfortunately, i can't repeat it. Sorry. If you can, try to debug the process. It seems that the specified value was deleted from related table.

And i truly recommend don't update InventTrans from backend.
brianmaric on at

Like (0)

Report

RE: Clearing the Inventory
brianmaric on at

Like (0)

Report

RE: Clearing the Inventory

Just tried it...got this..

Warning Item ITM0007813\Ownership=0000005273,Site=AMK,Warehouse=VEGAS,Batch number=A,Location=V01-01-01,Serial number=33520414,Asset number=IA000005938 Reference for ownership '0000005273' does not match the reference of the source
Error Item ITM0007813\Ownership=0000005273,Site=AMK,Warehouse=VEGAS,Batch number=A,Location=V01-01-01,Serial number=33520414,Asset number=IA000005938 Update has been canceled.
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Clearing the Inventory

Did you already tried to use Quantity adjustment function in On-hand inventory form?
brianmaric on at

Like (0)

Report

RE: Clearing the Inventory

Also, there is no cost on the items
brianmaric on at

Like (0)

Report

RE: Clearing the Inventory

Like I said, the tracking dimension is 'sa' and yet there is a batch number to the on hand inventory. The inventory journals simply refuse to see it because the record has a batch number and the journal will not let you set one because the tracking dimension won't allow it.

I have no idea how it got into this state.
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Clearing the Inventory

Updating AX table such as InventTrans from the backend it's a not good idea.

Can you explain what the data problem do you have?