Withholding tax on Advance is not updating in FMIFIIT Table

[appu_appu]

Hi All

Withholding tax on Advance is not updating in FMIFiIT Table, below is the example for our scenario:

1. Advance Entry:

Vendor Dr 100

Bank Cr 90

WHT Tax Pay Cr10

2. Withholding Tax payment to Govt. (This Payable amount is not updating in FMIFIIT Table)

WHT Tax payble Dr 10

Bank Cr 10.

3. Invoice

Exp Dr 300

Vendor Cr 270

WHT Pay Cr 30

4. Transfer from Spl gl to Normal

Vendor Spl GL Cr 100

Vendor DR 100

5. Invoice Payment

Vendor DR 270

Vendor CR 100

WHT DR 10

Bank CR 180.

when we see the WHT Tax Payable account balance 20 (30 from invoice minus 10 from Advance reverse).

in our case WHT Tax on advance is already paid to the govt. when we pay the balance of 20, FMIFIIT Table is updating with value type 57 only with 20, it is not considering advance WHT Tax payment of 10 which is paid earlier.

WHT Tax Commitment item is Financial transaction as 60 (Post rcvbls and pybls from goods + services) and Commitment item categ. as 3 (Expenses)

please help us in this regard.

Thanks

Prashanth Ragi

[iklovski]

Hi,

WHT commitment item should be of nature 30/(3 or 2); with what you have in the system, it's normal that FMIFIIT is not getting updated.

Regards,

Eli

[appu_appu]

Hi

Thanks for the reply, but when we pay the balance amount it is updating in the FMIFIIT Table with value type 57 (when we pay)

Thanks,

Prashanth

[iklovski]

I don't get your remark...

[appu_appu]

Hi Eli,

When we are paying withholding tax which is there in the invoice, at that time system updating the FMIFIIT Table with the value type as 57. but while paying the WHT tax line which was there in the down payment document, it is not updating the FMIFIIT table.

please let me know for any more clarification.

Thanks

Prashanth Ragi