Tuesday, 9 September 2014

Idea: Data Import Export Framework for importing journals

This is an Idea and not something inside standard.

Most people have used Data Import/Export Framework for importing journals. It has been a big help and in this post I will discuss an idea that I think Microsoft should consider to develop. I leverage the DIXF framework for importing a general journal and making it flexible.

Below is a screenshot of how simple it looks. I got dialog front end that has been created to run DIXF entities both import from source to staging, then staging to target in one shot. 

2014-09-08_0843

These are some additional considerations here for this to work:

  1. Default journal name  - this can be done by configuring the mapping from source to staging
  2. Default journal number – this is something to be done in code
  3. Default line number – this is something to be done in code
  4. Default currency from the company – this is something to be done in code or configuration. I prefer to do it in code.
  5. Default the dimensions – this is something to be done in code
  6. Clean up periodic job to be run on a regular basis for DIXF staging clean up
  7. Error/info messages can be a little more friendly – i used the log table information and display that in an infolog

 

For more information to use DIXF for importing general journals you can refer to a recent blog post.

http://blogs.msdn.com/b/axsupport/archive/2014/07/17/importing-a-general-journal-using-data-import-export-framework-ax-2012.aspx

1 comment:

Deepak Kalra Insan said...

Do you have xpo for this idea?