Trouble populating the item table with copy/paste

jamesjay

Good Day everyone

I do appologize if what i am about to ask is quite noobish but we are having a few hiccups with the copy/paste to the Item table, let me try to explain:

when we run the paste of rows into the table with the correct columns selected we start receiving validation errors, first with the item disc then the allow invoice disc. once manually editing this next failure is on the product group code and then BOM.

we were advised before to edit the BOM table which we did but then when came time to add the items to the table it errors out because the item no already exists from the BOM.

I am not really sure if there is a setting that allows amending rows as apposed to creating duplicates but we seem to be going no where here.

Any help or a point in the right direction would be most appreciated

jamesjay

I am assuming no one has had issues similar to this?
Am I loading the table incorrectly should i populate separate tables?