Yes, I have done this as long as there are no existing records on the price list for the supplier.  I’m not familiar with that error.  I have had no luck however updating those records for subsequent years.  We have decided to delete the existing records as we don’t need the history, then reload them again.  Here is the setup for the one that has worked with no existing records.

Yes, I have done this as long as there are no existing records on the price list for the supplier.  I’m not familiar with that error.  I have had no luck however updating those records for subsequent years.  We have decided to delete the existing records as we don’t need the history, then reload them again.  Here is the setup for the one that has worked with no existing records.

 

Thanks for the response, I have a migration job setup which can insert a new record to a price list with existing records. It’s very similar to the file mapping you have - what’s your formatting tab setup?

Extremely basic, nothing that should change your setup or matter really.

Extremely basic, nothing that should change your setup or matter really.

 

 

I setup an excel migration, this allows different parts/suppliers/sites to be entered on the one sheet with new prices. It also allows new price lists to be entered for parts that already have price lists (If not active). Next task is trying to automatically close an active price list when a new price is inserted via the migration tool.