Dear Team,

Re posting the issue again to get more attention , the problem is unsolved and demanding immediate attention.

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.  Unsure about the ratio or formula for distribution during posting to respective accounts . How to find the distribution ratio? where can i modify the setting to change this ? 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.

Calculation in AP module is precise , but when posting from AP to GL to the respective accounts giving unusual ratio of distribution . How to find out the criteria or formula which is used by GL to distribute to their respective accounts ? Is there any way to change this distribution? 

Best regards.

Salim

Tamcon