Question Status

Unanswered
adny2k asked a question on 3 Aug 2013 11:28 AM

Dear All

 

any one guide me how I extract inventory movement report from AX 2012 FP

 

like

onhand  issues receipt closing balance  between two dates

Reply
Brandon Wiese responded on 3 Aug 2013 1:46 PM

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).

Reply
zeeshan shaikh responded on 3 Aug 2013 6:07 PM

Hello,

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.

Reply
lally responded on 4 Aug 2013 12:32 AM

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.

Reply
zeeshan shaikh responded on 4 Aug 2013 4:39 AM

right click on columns and then select personalized then pop up screen will be shown then add fields.

please mark correct answer, thanx

Reply