Skip to Content
Apr 10, 2009 at 08:36 PM

Rounding Syntax in Query


I need to round up quantities for purchasing to the next full value based upon the UOM conversion from sales unit to the purchasing unit. I would like to create a user defined value in the PO window that will take the purchasing quantity and round up. I think if I add .50 to the quantity and then round, I should be good. My problem is that I don't know the syntax on the round function in Business One.

With the syntax I assume I can take the filed POR1.Quantity and then simply add the .50. and round.

Am I on the right path?