We have an IC alternate price list that is supposed to be 5% less than the base price list. Unfortunately when I create or update the alternate list and use 5% decrease from base price list, I get an amount that is a few cents off from what I calculate in Excel. Our customer is expecting to be charged the amount on the excel list, not the amount Adagio is calculating. When I open the edit alternate price list items window I see an option for rounding, and it is currently set to "no rounding". I thought there were normal accounting standards for rounding to two decimal places for currency, and am not sure why alt price lists would not be set up accordingly.

Can someone please advise me on how to get an alternate price list with 5% decrease into Adagio? I'd rather use the Adagio update price list function if possible. If necessary I can import the alternate price list but it seems like an unnecessary step. I would prefer to do this however than to manually change the rounding method on 700+ individual items.

Any assistance would be appreciated!