Microsoft Dynamics Axapta 2012 - Data Import - Inventory Opening Balances

Here now we will look into how to Post/Update Inventory Opening Balances in AX2012 using Inventory Movement Journal..

Add below Tables into Excel:

• InventJournalTable
• InventJournalTrans

If you encounter any error while adding tables, follow below procedure to successfully add the tables.

Go to AOT -> Data Dictionary -> Tables -> ReasonTableRef -> Indexes

right click and select New Index, Index1 will be created. Right click and select New Field. repeat same to create one more Field. First field will be selected automatically by Reason while second will be selected by ReasonComment. Go to Properties for ReasonComment field and under datafiled properties, select RecId then save.

Now go to properties of Index1 and set properties as below:

AllowDuplicates : No

Alternate Key : Yes

Now go to properties of ReasonTableRef table and change properties as shown below:

ReplacementKey : Index1 (Index you created).

Now save and close the session. Restart Synchronize and Restart AOS.

Now open Excel session and add InventJournalTable and InventJournalTrans Tables.

Add data as shown below:

Please do add Offset Account Field :)

Note: Before you Publish data, Please set Inventory Journal Number Sequence to Manual as shown below:

now publish data to InventJournalTable first then InventJournalTrans.

Validate and Post the Journal that is created.

Comments/Suggestions are welcome ... hope this helps.