Home Forums OpenSync Populate items table causes inventoryassembly table to double up records

This topic contains 1 reply, has 2 voices, and was last updated by  Yudel Rosales 1 year, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #68048



    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)

    Hope this can be fixed.

    All the best


    Yudel Rosales

    can you email me at

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘OpenSync’ is closed to new topics and replies.