Opening Balances Template

Finance and Operations/AX User Forum
1

Hello There,

I wanna create the system generated template, through which i can upload my Opening Balances.

Can anyone know how to create the template for OB with the respective accounts.

Thanks

Ally

2

What are you talking about? A template for DIXF import?

Also, please never forget to attach a tag with your version of AX.

3

Hi Martin,

Yes, you are right. m talking about template for DIXF import.

See, the scenario is, we have new company and all major setups are done, now our Finance team wants to up upload the Opening Balance rather than putting manually. So for that, they told me to provide system generated Template or excel, through which they can put all the data and upload one time.

Hope you understand.

Ally

4

Hi Martin,

I think, Functional team can have a better idea about what they need. In general, there is no dedicated templates are available in DIEF modules.

Based on the requirement, we have to create them by adding required fields.

Send me your email id. I will forward you the sample template that is used for importing general ledger opening balances.

Regards,
Narendhra

5

Please look at Importing a General Journal using Data Import/Export Framework AX 2012 on Microsoft AX Support blog.

6

Hello Narendhra,

Thanks for your reply, kindly send me the sample template on aliashah83@hotmail.com.

Thanks

Ally

7

sent a mail.