Data import export framework error around InventTableModule

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.

Advertisements

About janeteblake

Dynamics AX developer
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 says:

    Brilliant find! This should help a lot of people!

  2. Khoa Diep says:

    Thank you so much

  3. janeteblake says:

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

  4. Frank says:

    Thank you very much.

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s