Inventory Balances Transfer

(0) Share

Report

Posted on by Community Member

I am trying to transfer balances from one inventory item to another inventory item. The reason is that there are many items which are opened by the same name but different item ID's.

Can some one tell me how to transfer Item Qty along with its balance in to other item.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (2)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Imran,

In inventory management you can use a profit/loss journal for this purpose. Note that depending on the inventory cost model you have to specify the cost price for the new incoming items.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Well thanks for replying Andre Arnuad. But I cannot find the P/L journal in inventory management under Journal area.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran Khan,

The label that you see says probably "inventory adjustment".

Can you find this one?

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Indeed the label is "Inventory adjustment" in AX2012.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Ludwig,

I want to reduce inventory from one item and add it to another item both physically and financially. Because I am trying to transfer balances from one inventory item to another inventory item. The reason is that there are many items which are opened by the same name but different item ID's.

But I am unable to do that from inventory adjustment, because in order to make transfer I have to reduce the item along with its financial value. But when I put the negative quantity it disables the cost price amount.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Imran Khan,

You mean that you cannot edit the cost price for those journal lines with negative quantities, right?

If so, then this is something you cannot do as the Dynamics AX inventory models determine the issue prices/costs depending on the inventory model group setup.

You can, nevertheless, make use of the inventory adjustment journal - or alternatively of a counting journal - to transfer the quantities. The cost prices setup for your item should then take care of the $-amounts used for posting the receipts (+ quantities) and the inventory model Setup for the issue transactions, that is the - quantities.

This leaves the chance that a small $-amount remains and is not transferred. In this case you can run an inventory recalculation and double check whether or not any ledger balance remains that would then require manual adjustment.

Probably try testing the procedure in a demo/test environment first for some single items to get familiar with the procedure.

Hope this helps.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot both Andre and Ludwig,

Can you please give me an example using screen shots, I did test on Demo. But I need to ensure that I am doing the right thing

Regards,

Imran.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

Here is a screenshot of an inventory adjustment Journal where a "wrong" item T0001 is taken out and the correct item T0002 is taken in. Please note that you cannot edit the cost Price or cost amount for the item that is taken out - that is the one with the negative quantity.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I did not receive any screen shots.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

...not sure what happened with the screenshot ... here it is once again.

Ludwig

Was this reply helpful? Yes No