setting Up Multiple rounding Methods

HayanHayan Member Posts: 110
Dear All,

Anybody knows how can I set up rounding method and Apply it on All Items at the same time, the rounding methoud is that if the item price is a multiple of 100 then remove one from it means, if it is 100 i want to round it to 99, if it is 200 make it 199 and so on, and also round to 5 any other price, for example if the price is 143 make it 145 and if it 142 make it 140.

Regards
HAYAN

Comments

  • FDickschatFDickschat Member Posts: 380
    You can use the Sales Price Worksheet to implement price changes on the Item Card or in the Sales Price Table. In the Suggest Item Price Function you can set up a rounding method.

    Setting up a rounding method is not so hard to do. Just give it a try.
    Hayan wrote:
    if the item price is a multiple of 100 then remove one from it means, if it is 100 i want to round it to 99, if it is 200 make it 199 and so on, and also round to 5 any other price, for example if the price is 143 make it 145 and if it 142 make it 140
    You will have to run the batch twice with a filter on the current price. Just try. If the result is not what you want delete the worksheet and try again.
    Frank Dickschat
    FD Consulting
Sign In or Register to comment.