Dear Team,

We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well. However, while posting in GL it has been split into two base accounts named 1601 and 1690. Below is an example demonstrated for your consideration.

In screen shot we have an invoice for BD 9229.14 and then there are two deductions for retention and advance payment for BD 922.91 and 461.46 respectively. The VAT amounting BD 392.24 is 5% of net amount that is BD 7884.77 (9229.14-922.91-461.46).

In GL the VAT deducted should be posted to 1601 and 5% of retention amount should be posted in 1690. However, the system has split BD 392.24 VAT deducted on net amount to BD 354.62 and BD 37.62, which is clear from the GLs attached with email.

Can you please explain the logic behind this allocation.

Further the amount of VAT in base account 1690 should be BD 45.15 (5% of BD 922.91 retention).

The full amount of VAT on net amount of invoice should be posted to 1601, which is not the case.

Attached account (1690 and 1691 )details for your reference.

We shall appreciate your early response in this matter.

Best regards.

Salim

Tamcon