Hopefully someone can help.
Since BC changed the way it stores vendor pricing I no longer have the ability to change vendor prices in bulk (the edit in excel option is not available).
I tried using a configuration package to update the Price List Line table but this doesn't look right either as the records requires a unique key from the Price List Header table and this process is not suitable for our front end users who will be managing prices.
The only examples I have found show prices being input one at a time (tedious) or using a percentage price increase to update items on mass, however we do not update based on a %, we are given new pricelist and we need to update thousands of prices at once.
The edit in excel was a great feature in the previous pricing version which would handle this but since it is not available in the "New Sales Pricing Experience" can anyone advise how this is done now?
