How to get complete inventory detail in excel form AX

i want to get all on hand inventory detail in excel, please help me new user fo AX

What is your AX version?
You can export data from inventSum table.


If you are using AX 2012, Microsoft Dynamics AX 2012 ships with lnventory Journal AIF Web Service (InventProfitLossJournalService) which can be used in integration scenarios. However Inventory Journal AIF Web Service can’t be used in Excel at the moment for import of inventory transactions. In order to import inventory transactions using Excel the appropriate tables will be used.


I think the original post is not about creating inventory transactions or journal.
Might be looking for the way to export on hand entries from AX to Excel, but the intention/requirement was not well explained.