Rounding issue for OIC

Mar 14, 2026 2:18PM

Summary:

We define the mapping and insert into ra_interface_lines_all table.

Current situation fails in AR invoice import because import expect amount be 9742.16. The amount is quantity 28.5 x unit selling price (341.83) = amount (9742.155) . Then it should round to the nearest 2 decimal places to 9742.16. But below expression return value 9742.15, Can anyone help to get the correct expression

QTY_NUM_1 —> Quantity (28.5)

RATE —> Unit Selling Price (341.83)

round ((ns36:QTY_NUM_1 * ns36:RATE) * 100) div 100 —> Amount (9742.15)

Content (please ensure you mask any confidential information):

NA

Version (include the version you are using, if applicable):

OIC 3

Code Snippet (add any code snippets that support your topic, if applicable):

Rounding issue for OIC

Howdy, Stranger!