I’m doing a populate of various items tables and finally narrowed down an issue where I had duplicate records in the inventory assembly table (iteminventoryassembly).
I do a populate on all “Item XXXX” tables and “Items Subtotal” and “Items” table
After I have done a populate of the inventory assembly table and it hits the populate for the “Items” table it starts doubling up records in the inventory assembly table. All records are in there duplicate
My fix so far as been adding an auto increment ID on the table and deleting the duplicates (it does not add them back during a refresh)