Notifications
Announcements
No record found.
Dear All ,
i am new on Ax 2012 Can any body tell me
i need to get the relation of sold quantity with the purchased quantity with Sales and Purchase price against Item ID
Thanks,
Babar
*This post is locked for comments
Hi Babar,
Cost price related there is not necessarily a link between sales and purchase orders. If you run the Item/Sales statistics report, you would have an overview. Do you have any specific detail which do link sales with purchases, e.g. a serial or batch number? What is the exact requirement you are trying to fulfill?
As Andre mentioned, I don't think that there is a standard report that includes exaclty the data you mentioned. You can have a look at the standard reports, such as the inventory value report or sales margin reports to see whether they hold all of the data you are looking for. If they don't then you can possibly make use of the AX2012 cubes to extract those data depending on the exact requirement that you got.
Best regards,
Ludwig
Unless you buy and sell everything and complete invoicing in the same period , or use marking for every order, then purchases go into inventory and sales come out of inventory and there is not a direct relationship - one purchase order might cover several sales periods, or multiple purchases over many periods might feed into one or more sales orders several periods later. The COGS which is seems to be what you want, will depend on what costing method you use, and whether you have closed inventory for the period for which you are reporting.
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
