cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding Up in PLD in SAP B1

vishal-ds
Discoverer
0 Kudos
196

Hello Sap Experts

I am using SAP Business One with SQL db, V 9.3 P13. 

In our business we ship closed cartons and we use the PLD for the order. 

So for example when a carton has the incomplete quantity, the carton value comes in decimals which is normal.  I currently use ROUND()... But I want to round up like in MS Excel.

For example:

We use the round function, so right now it displays

0.23 = 0

0.49 = 0

0.5 = 1

1.2 = 1

1.6 = 2

I would like to modify the formula and use the round up function in excel so the values would appear like this:

0.23 = 1

0.49 = 1

0.5 = 1

1.2 = 2

1.6 = 2

Accepted Solutions (0)

Answers (0)