Roundown w/tax payment

[Former Member]

Dear Gurus,

I've problem in roundown withholdin tax, where the configuration has been done.

here is the capture

In w/tax amt is 10 % from w/tax base the value should be 2777,77. but system calculate 2777,78 (see pic below)

anyone has face problem like this and solved ? pls need your advice.

Best regards,

IS

[Former Member]

Hi Iwan Siahaan,

You need to configure IMG-->Fin acctg-->Global settings-->Withholding tax-->Extended WT-->Basic settings-->Calculation-->WT type-->Define rounding rule for WT type also.

Here you need to specify the units to which round down has to happen.

Hope it helps.

[Former Member]

Dear Raman,

In unit what value shoul i fill in ? because i already fill 100.

Best regards,

IS

[Former Member]

Hi IS,

Change it to 10 or 1 as per the decimal you want to round.

Before that have you maintained 100 for your local currency? then maintain the rounding rule for your foreign currency (USD) also if your business requirement needs so.

It will solve your problem.

Regards,

G.Sethuraman.

[Former Member]

Dear Raman,

I already change to 10 or 1 and 100 for local currency but it didn't work. and my user wants for local currency if the invoice 666.666 then w/tax 66.666 not 66.600 if the local currency set unit = 100.

any suggestion ?

Thank you,

IS

[Former Member]

Hi IS,

The 27,777.77 is foreign currency(USD) so 10% of it will be 2777.78(Commercial rounding) if you havent maintained rounding for foreign currency.

So if you want it to be round down to USD 2777.77, maintain rounding rule for your WT type for your foreign currency(USD) with unit 1.

It will help solve your problem.

[Former Member]

Dear Raman,

I already setting

then I try create entry journal, where the information is correct WHT 2777.77 usd

when I do payment f-53 thw WHT shown different

please need yoyr advice.

Rgds,

IS

[msshihab1987]

Hi Frind

The reason is very simple, you have maintained the condition for IDR but the invoice is posted in USD that is the reason system is not calculating for those invoice posted in USD.

Please check the attachment , it is clearly specify with both condition.

[Former Member]

Hi IS,

Have you configured for WT type for payment posting or Invoice posting.

If you have done it for invoice posting then do it for payment posting.

Also do the rounding rules for payment posting WT type.

Hope it will solve your problem.

[Former Member]

Dear Shihab,

I alredy maintain for USD 1 or 10 or 100, but still not change anything even IDR maintain or not.

Best regards,

IS

[Former Member]

Dear Raman,

I already maintain for payment and invoice. is there any configuration outside WHT which can reflex to rounding rule ?

Thanks,

IS

[Former Member]

Dear IS,

No other configs.

But try to reverse the earlier document and create a new one. Because the liability to vendor document might have created before the rounding rule config. So it seems it is not working but may work for documents created hereafter.

[Former Member]

Dear Raman,

i already copy to testing server. even try to cancel all document and create new one the result still not rounddown.

Thank you,

IS

[Former Member]

Hi IS,

Attach your config screenshot for WT type invoice posting as well as payment posting.

Also attach rounding rule screenshot.

Let me try to help.

[Former Member]

Dear Rahman,

invoice posting

Payment Invoice

rounding rule

Best regards,

IS

[Former Member]

Hi IS,

WT for payment posting is calculated as per the logic below.

It will first calculate amt in local currency and then multiply with WT rate which will be rounded as per rounding rule. Now the rounded amount is divided by the exchange rate to find WT amount in document currency.

Example

Amt in Doc curr = 27777.77 USD

Ex.rate 43.25

Amt in local curr = 1201389

WT in local curr =24027.77 as per rounding rule it becomes 24020.

WT in doc curr = 555.38 (24020/43.25).

Hope it clarifies.

[msshihab1987]

Hi Friend

This is the way i have maintained and it is working fine for INR

[Former Member]

Hi Shihab,

Yes if I follow your config curr : USD and IDR unit = 1000 in USD w/tax mount is correct 2777.77 but in local currency has impact to, so the amount w/tax in local curr become incorrect. e.g. inv in IDR 666.666.666 if I set 100 for local become 666.600 not 666.666.

Best regards,

IS

[msshihab1987]

Hi Friend

Please check the attachment

[Former Member]

Hi Shihab,

My user wants all rounding down not up.

can you explain why should base amount in gross amount not net amount ?

Best regards,

IS

[msshihab1987]

Hi Friend

Please check the attachment