Questions Expire sales prices via Import Scenario

This was something that we explored during our implementation and couldn't find a good solution to manage our sales prices through bulk actions inside of Acumatica. Worksheets were okay for smaller bulk additions and changes, but we ran into terrible performance and frequent timeouts on large data sets.

We manage all of these bulk changes directly in SQL now. This has been particularly useful when Sales implements special promos or releases a worksheet that sets a short-term price to be active too long.

You might be able to use this technique from the I100 course in Acumatica University, but I haven't tried it for multiple columns. You'd have to match on multiple columns since there are several columns needed to guarantee that you match the correct row.

Hi

Just to build on this a little - need to create an import scenario that will do both 
a)   Expire the existing sales price, and 
b)   Insert a new sales price into the system

Preferably I would like it to do both in one scenario as opposed to having 2 scenarios to do both steps (Due to additional information the customer wants to see on the Supplier Prices screen, they don't want to use the Price Worksheets feature, so am trying to find a simple way around this).

So, my question is... is this possible?

I really don't know if I can do this type of thing in an import scenario or not, have been playing with various Active and Commit options ticked and unticked, but keep getting a duplicate price error. I have managed to get the current price to expire - just not adding in the new price.

My next option is to go with two import scenarios - but it's really not ideal.

Thanks heaps for any assistance you can give.

Regards

Bev