How to round Invoice amount(LCY)

hant

Hi all,

Is there any way to setup rounding for Invoice amount(LCY) if the invoice issued in USD? The minimum value of our LCY is 1 so the rounding factor should be 1. For example: Invoice amount: US$100.23 and the exchange rate is US$1.00/LCY15,980.00 then the amount in (LCY) calculated by the system is 1,601,675.4. We want this to be rounded to 1,601,675.

Thanks in advance for your recommedation.

hant

bestianhow

Hi Hant,
You need to open table 98 "General Ledger Setup", and change value of field "Amount Rounding Precision" to 1 (default is 0.01).
If the company got G/L entry transactions already, i think you are not able to change this field.

Anyway, this initial setup requirement.

hant

I've already setup this field to "1.00" but it also rounded the USD amount. Is there any field that I need to touch in?

Kowa

There are several fields in the currency table to handle rounding methods in foreign currencies.

Invoice Rounding Precision
Invoice Rounding Type
Amount Rounding Precision
Unit-Amount Rounding Precision
Amount Decimal Places
Unit-Amount Decimal Places

hant

I've setup the rounding in Currency table as below. Pls. help to show me what is incorrect. Thanks.

USD
Amount Rounding Precision: 0.01
Amount Decimal Places: 2:2
Invoice Rounding Precision: 0.01
Unit-Amount Rounding Precision: 0.001
Unit-Amount Decimal Places: 2:5

LCY
Amount Rounding Precision: 1.00
Amount Decimal Places: 0:0
Invoice Rounding Precision: 1
Unit-Amount Rounding Precision: 0.01
Unit-Amount Decimal Places: 0:2