Here is a tutorial on how to configure Dynamics AX 2012 to import a general journal from a CSV file. The steps below are using Contoso demo data.
Senior Support Engineer - Dynamics AX
Thanks for the post.
I have found two issues with the standard opening balance import entity:
1. When using it for importing customer balances and you also need to import settlement discounts, the discounts do not post through to the customer transactions, although it is specified in the journal. We had to run a separate job after the import to initialise the discount creation.
2. When import fixed assets depreciation transactions using this entity, the asset transaction type also do not get updated.
Hi Eddie -
I'm not seeing anything previously reported on the customer discounts issue. I would recommend either submitting a support ticket to have an Engineer investigate it or submit a product suggestion on our Connect site:
It looks like we've released a hotfix for AX 2012 R2 for the issues with importing the fixed assets depreciation journal and the transaction type. The hotfix is KB 2911714 which can be downloaded from PartnerSource. You'll need to log in first, but here is the link:
I hope this helps!
Fine step by step description. I succeeded to import the first time I followed your guideline. :-)
Thanks for very nice and step by step details.
After completing the import upto step 30 , when I open the Journal it shows the total amount but it does not show any lines. I have imported data 3-4 times but every time there is no data in Journal.
Please give step by step action plan to resolve the issue
Thanks & Regards
I forget to mention that log shows the following message
Data written to target 'Opening balance' ('1' records created, '0' records updated)
Did you found the solution for making it visible.
I think cash discount was already a problem with Ax2009 if the field invoice was not filled in.
I did it and the result is successfully but when config to Excel, return to me "Extension erro".
What is the better extension i have to put and the configuration ?