Notifications
Announcements
No record found.
Hi,
Could anyone tell me how AX calculates the ageing of the stock? I mean if it uses LIFO, etc.?
Cheers.
*This post is locked for comments
Hi Adfc,
Do you mean how AX calculates inventory values according to Fifo, Lifo, etc or do you need to know how AX gets the values that are put in the aging buckets of the inventory valuation report?
Ludwig
Hi Ludwig,
Well, actually I was wondering about both now that you mention it... :)
For the inventory aging report I would recommend that you take a look at the following video that was developed by one of the MS engineers
blogs.msdn.microsoft.com/.../new-costing-features-in-dynamics-ax-2012-r3
Some information about the inventory value report can be found here
download.microsoft.com/.../DynamicsAX2009SP1InventoryReportingandReconciliation.pdf
And some general information on the valuation principles available here
fedotenko.info
Note that the last two sources are for AX2009 but in major parts still valid.
Hope this helps,
Hi Ludwig, and apologies for the VERY late reply.
I had a look at the information you mentioned, but could not find exactly how does AX "know" how to put which qty in which date buckets.
Scenario:
- We bought 10 qty of Item A for warehouse A, 200 days ago.
- We sold 3 of those 10 over the last 200 days
- 50 days ago, we transfered 4 from warehouse A to warehouse B
- So now Warehouse A has 3 and warehouse B has 4
Based on the default AX "Inventory Ageing" report:
When we pull the report at a Site level, it shows a qty of 7 on the bucket 100 to 250 days.
When we pull the report at a Warehouse level, it shows a qty of 3 in warehouse A and 4 on the warehouse B, BOTH AGAIN on the bucket 100 to 250 days.
So, how does AX "know" that those qtys in warehouse B (transfered in, NOT bought in) are from a purchase 200 days ago and not from the transfer that occured 50 days ago? What ID is AX using to keep track of when a certain qty was bought in into our company?
Any help is much appreciated.
Hi Adfc - this is an interesting question. Did you ever resolve it?
For each item, transaction stored some information's in InventTrans and InventTransOrigin.
As given below screen shot there are Reference and Receipt column.
For Purchase: Reference-->Purchase order and Receipt-->Purchased
For Transfer: Reference-->Transfer order shipment and Receipt-->Purchased
Hello faiz7049,
Thank you, but perhaps the question is how does AX record the link between different transaction lines? I.e. in the following example:
Purchase order "PO123" is received into the inbound location of a warehouse.
Putaway journal is created and posted to move 30 of item A from inbound to picking location "Pick1".
Transfer order "TO123" is created, picked and despatched to move 10 of item A from "Pick1" into the transit warehouse and then to another warehouse - i.e. a store.
How/or does AX understand that the item A on TO123 is originally from PO123, and not any other PO? This "tracing" looks like it can be seen via the TO lines form - Stock --> Trace.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
