Upload Opening Balances

Dear All, My financial year start from 1st June. I am using AX 2012 in which I have to upload opening balances on 1st June 2014. I require your help that how can I upload that balances and what would be the format which I have to use in order to upload on AX??? Could anyone please help me out?

You can import through Data Import & Export Framework in Ax 2012. Use Target Entity “Opening Balances”.

It will create General Journal. you can validate and post the journal.

Attached link is the Template used to import data.

5100.Opening Balances Import Template.xlsx (9.17 KB)

Dear samanth,

Thanks for your prompt and valuable response…

I need this utility.

Could you please help me out in one more issue that how can I make a JV …which i insert in this utility …

Means any sample format of voucher which we upload through this utility.

Regards