how to set the rounding configuration ??

[Former Member]

I am trying to round up currency in sap b1 round up to 2 Digits.

just like the roundup function in MS EXCEL.

for example :

1.223 ==== > 1.23

1.225 ==== > 1.23

1.229 ==== > 1.23

1.220 ==== > 1.22

-

---

how can I do it in sap b1 ?

Best Regard

Albert

[Former Member]

Within SAP B1, you can go to Administration --> System Initialization --> General Settings --> Display tab. There, you can se the decimal places for various fields, and it will automatically do the rounding up.

HTH,

Dhruv

[Former Member]

> Within SAP B1, you can go to Administration -->

> System Initialization --> General Settings -->

> Display tab. There, you can se the decimal places

> for various fields, and it will automatically do the

> rounding up.

>

> HTH,

> Dhruv

this setting is only for display . not for round-up

[Former Member]

Ok, I thought you were refering to the display of the numbers. Could you be a little more specific in what you're trying to accomplish? For example, are you trying to change the stored values, or just how they are formatted?

[Former Member]

First , thank you for your answer. you are so kindly.

yes,my case need a round-up function just like work as MS EXCEL.

look here..

in case , we input a value 1.231 , than we hope the software can change the value 1.231 to 1.24 and stored the value.

we say this action as "<b>Round-Up</b>". this is a little difference to "ROUNDING"

this is very important for multi-currency in some special situation.

for explame , a very low cost item sales :

<b>step 1:</b>

A item in mater data , we input the price in local currency as $NT 40.80 (taiwan dollar)

<b>Step 2:</b>

we setup the exchange rate to USD as $33.14

<b>step 3:</b>

when we create an A/R invoice and sale 1 pcs of this item in US dollar.

<b>step 4 :</b>

SAP B1 well change the price as USD $1.23 (<b>$40.80 / 33.14 = $1.231 )</b>.

BUT !!!

my customer expect SAP B1<b> round up $1.231 to $1.24</b> just work as <b>MS EXCEL</b> "roundup" function.

because , if he use the SAP B1 my customer sales the item for 10000 pcs in USD, he will lost USD $100.

my customer told me , this round-up fuction in excel is a very basic action.

why sap b1 don't work for this fuction ?

if you have any other questions, may maybe you can study the help file in excel.

or you can see this web page:

http://www.techonthenet.com/excel/formulas/roundup.php

<a href="http://www.techonthenet.com/excel/formulas/roundup.php">EXCEL ROUNDUP</a>

How to steup rounding function as round up in sap b1 ?

[Former Member]

Well..

SAP B1 is not Excel.

And there are many other 'very basic' rounding methods.

( http://www.diycalculator.com/popup-m-round.shtml ).

Which one of those methods your next customer would love to have?

AFAIK, you have three options

1. Educate your customer on B1 features and manage their expectations.

2. Use existing basic functionalities to overcome the basic threat perceived by your customer (loss of money due to "wrong" rounding).

- maybe they can increase a pricelist coefficient by 0.01?

3. Create a solution to the customer for example by using Formatted Searches or UIAPI.

- not a good solution since the rounding will take place all around B1

Good luck & 88

Juha