OpenSync

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
    Posts
  • #68048

    store
    Participant

    Hello,

    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

    #68063

    Yudel Rosales
    Keymaster

    can you email me at opensync@synergration.com?

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

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