Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I purchased one item with two separate batch number and Serial number with different cost price. Inventory model group is FIFO used. I also changed Inventory dimension group as per requirement.
Item A, Batch # B001, Sr. number S001, Qty 1, Cost price $100
Item A, Batch # B002, Sr. number S002, Qty 1, Cost price $500
Cost price allocated based on above transactions.
Created Transfer order ( From Warehouse 11 to WH 21)
Transfer order line, Just entered qty 2 and reserve automatically
Picking list registration
It;s created two spearate line based on batch and serial number.
I shipped and received the transfer order.
Now cost price is update # 300 each.
Item A, Batch # B001, Sr. number S001, Qty 1, Cost price $300
Item A, Batch # B002, Sr. number S002, Qty 1, Cost price $300
I did inventory recalculation but no luck.
I also tested same scenerio into AX2009 and AX2012 vanilla and it's same.
Any suggestion will help me lot.
In the dimension group which dimensions are you tracking "Financial Inventory" by? I am guessing just Site and Warehouse. If you want to track costs by further dimensions you need to flag it against batch and serial as well.
I did financial inventory checkbox yes for batch and Serial number as well. In my dimension group
Active field=>Site, WH, Batch number, location, Serial number all flag yes. Primary stocking field=> all flag yes, physical inventory field=> all flag yes, financial inventory field => all flag yes. Mandotary field=> only site and WH flag yes.
Have you invoiced the original transaction to have a financial cost?
Setting it up using your settings and purchasing and transfering it works fine as you can see below
Yes, First I did the invoice the PO to make sure it's update financial cost.
I just wanted to ask question, did you created two separate line on transfer order ? if so, dont create two different line.
Just create one transfer order with Qty 2(without Batch number and Serial number) and try out. See below
If I create two separate line with Batch number and serial number, it's work for me but scenerio is I would like to create single line with multiple qty.
Yes I can confirm if you ship it as one line it gets the cost incorrect and the recalculation does not adjust it. I can only suggest you log this with Microsoft because there is no configuration that would stop it doing this.
I've experienced the same problem and reported it to Microsoft Support. They say that it is by design, and cannot be fixed in the release (AX2009). The only work around they had was to create a transfer order line per batch# (or serial# if you are using serial), which usually is not acceptable to the end-user...
Thank you Friends.
I also tested this scenerio in multiple ways and thought it's bug in application.
I also open ticket at MS but I am expecting same answer as you got.
Thanks again for your time and support.
Thanks for your reply!
I already open ticket to Microsoft, I also know what will be their answer
There answer will be "It's way to designed"
I am also experiencing in AX2012. Microsoft have said this is is by design. Not sure if FIFO means something different in AX than in does in other systems or accounting
Business Applications communities