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.
EDIT: Upon investigation, it was found that this error occurs on an update but not an insert.