Data import export framework error around InventTableModule

Posted on June 12, 2013 by janeteblake

I’ve been having a blast with the new data import export framework (DIXF) tool. I’ve been making notes called Tips and Tricks in the hopes of sharing them on this blog.

But in the meantime, I encountered a bug today that I wanted to alert everyone to. All InventTableModule information, be it for Purchase, Sales, or Inventory, goes to the Purch record.

The same table occurs three times on the query, so it always gets the first. We wrote a workaround by using the “occurrence” parameter in the QueryRun.get() call. Please see specifics below.

InventTableModuleBugFix

Happy DAXing!

EDIT: Upon investigation, it was found that this error occurs on an update but not an insert.

Unknown's avatar

About janeteblake

My triple passions are Dynamics AX technical, learning, and AI
This entry was posted in AX2012, Bug, Data migration, Dynamics AX. Bookmark the permalink.

6 Responses to Data import export framework error around InventTableModule

  1. Cowboygeek's avatar Cowboygeek says:
    June 16, 2013 at 11:49 am

    Brilliant find! This should help a lot of people!

    Like

    Reply
  2. Khoa Diep's avatar Khoa Diep says:
    July 2, 2013 at 5:10 am

    Thank you so much

    Like

    Reply
  4. janeteblake's avatar janeteblake says:
    September 5, 2013 at 8:41 am

    Thank you, Johny, for letting me know that they published it!

    Like

    Reply
  5. Frank's avatar Frank says:
    October 17, 2013 at 12:29 am

    Thank you very much.

    Like

    Reply

  6. Pingback: Possible bug in DIEF – Opening balances – fixed assets | janeteblake

Leave a comment