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.
Happy DAXing!
EDIT: Upon investigation, it was found that this error occurs on an update but not an insert.
janeteblake 
Brilliant find! This should help a lot of people!
LikeLike
Thank you so much
LikeLike
https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyvwqxnrnxtvknskyvyukurmqxomllrukv
LikeLike
Thank you, Johny, for letting me know that they published it!
LikeLike
Thank you very much.
LikeLike
Pingback: Possible bug in DIEF – Opening balances – fixed assets | janeteblake