
Working with MS AX 2021 and looking for some guidance around the detailed calculation and factors used to generate the Dollars total for each item for the 4 methods, Value, Revenue, Margin and Carrying Cost.
I assigned for example using the Value method A = 80%, B=15%, C=5% but the output results for some items that are fairly high movers show negative dollar values using the past 3 months range so not understanding again, the detailed formula on generating these numbers/results.
One final thing is I want to calculate this for both our raw materials (incoming from our suppliers / stored in warehouse before used in production) and the finished goods (converted by mfg and stored on shelves in warehouse until shipped to customer).
Much appreciated!
Thanks,
Brian
Check if this blog post, details your needs. It's for D365 but the core engine it's almost the same