Unit Price change for numerous items at once

howieb4

Hi, I am still new at NAV, but trying to do something that I would believe should be a simple thing. I need to change the unit price on over 500 items and cannot find an easy way to do this.

I know there is the adjust price batch, but it just applies a multiplier against all prices and that will not suffice. These 500 prices are random, with no conditions or consistency.

There is also the Sales Worksheet, but that seems to force you into using Customer Price Groups, which then sort of makes that the unit price of record, subordinating the Unit Price on the Item Card.

Finally, I was thinking of using RapidStart to dump the Item Table to Excel, merge that with the price change sheet and then importing in back into NAV.

Thanks for any help

ara3n

RapidStart should work fine.

Andwian

I usually using Data Migration.