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
Thanks a lot Ludwig,
I am now facing a problem regarding the value of item which must be fetched from its inventory/item model. I will look in to it and then test it.
Regards,
Imran.
Hello Imran,
The price that you see in the journal above for the issue transaction (300$) comes from the item master. This price gets, however, overwritten with the running average price at the time the journal is posted. You cannot identify this directly from the journal but from the item transactions generated.
Best regards,
Ludwig
Thanks Ludwig.
Does the system automatically fetch its cost price according to its item model group?
...not sure what happened with the screenshot ... here it is once again.
Ludwig
I did not receive any screen shots.
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
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.
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
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.
Indeed the label is "Inventory adjustment" in AX2012.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156