What is the procedure to accurately import to Sage 50 new pricing on inventory items through an Excel spreadsheet? Specifically I am having difficulty in locating the file to import from, does it need to be saved as a certain type of file?
This is how I change Item Prices. In Maintain Item Prices choose 1 item (as a test). Choose Ok on the 1st screen takes you to this screen (above). I want to adjust the New Price level increase by 10%. In the select which levels to adjust to I only check the ones I want and they appear as columns below. Select the method of Adjustment and in this case I chose current, percent increase, as 10%. Then hit the "Recalc" button at the top of the screen. This will show you the new price in the columns you selected. When you Save the screen it will update all of the item pricing for the items on the screen. Make a backup before you do this because there is no "undo" after you Save the screen.
