any one guide me how I extract inventory movement report from AX 2012 FP
onhand issues receipt closing balance between two dates
If you're interesting in the value of inventory, you'll almost certainly want the Inventory value report the Inventory and warehousing menu. It requires setting up a reporting profile where you decide what information you want to see on columns and rows, subtotals, etc., but it is the primarily inventory value report in AX as of AX 2012, and it's one of the few that can report as of a previous date in time accurately (given that recalculations and closings could have occurred since the date of interest).
you can view this above information @ warehouse and management> inquiry> transaction > transactions
there you can get almost all information like purchased, sold, RFQ's, ordered via movement journal, on order = PO, all you need to is personalized the column.
another report can be generated via inventory valuation. there you will get the proper reporting of purchasing and issuance with weighted avg calculation. but for that you have to configure the report ID.
please mark correct, if my answer helped you.
Hi ZESHAN ,
In the above post you have mentioned that we need to personalize the cloumn.
Could you explain or share the screen shot of how to personalize the columns ?
Thanks in advance.
right click on columns and then select personalized then pop up screen will be shown then add fields.
please mark correct answer, thanx