Solved

Unable to create an invoice which includes tax code with tax type set as ‘calculated tax’ and deductible % is different from 100%

  • 30 September 2019
  • 2 replies
  • 787 views

Userlevel 6
Badge +10
We are unable to create an invoice which includes tax code with tax type set as ‘calculated tax’ and deductible % is different from 100%.

Once the invoice is created, it was observed that posting information aren’t balanced. The invoice is in ‘preliminary’ status and it isn’t possible to add somewhere any amount to balance the invoice. When trying to perform the functionality, RMB > Post Invoice, the invoice status would update to PrelPosted. However, we couldn’t finally post the invoice as there is no way to balance the invoice.
icon

Best answer by Dismanthi Dissanayaka 30 September 2019, 16:43

View original

2 replies

Userlevel 5
Badge +6
The issue isn’t considered as a bug. This error message appears due to the validation happening when ‘Tax Correspondence Invoice Lines-Postings’ check box is selected (Company > Invoice Tab > Tax Information Tab). Therefore, if this checkbox is selected, you will have to remove tax code from posting lines when non-deductible tax amount is manually posted. In other means, it is required to use two posting lines when using a tax code with tax type as ‘Calculated VAT’ and deductible % of less than 100%. Accordingly, the invoice could be posted using following below steps,

1.Create a ‘Manual Supplier Invoice’ following general steps.

2.Add two posting lines as follows under ‘Posting Information’ (Below attached screenshots are from “Support / APP9 / Global Extension / GET RnD TEST CMB (UPD14)” environment)

a.Row 01 – add a line for the ‘net amount’ of 1,000 with tax code. Through this step, the cost amount will get posted with tax code.
b.Row 02 - add a line for non-deductible ‘tax amount’ of 4 without tax code for the same invoice. Through this step non-deductible tax amount will get posted without a tax code.

Upon performing these steps, you would be able to process the invoice to status ‘PostedAuth’.
Badge +2
Have you tried on the tax code set up to fix this changing the rate instead of the deductible %?
for ex: rate 10% that must be calculated over 80%, / net amount 1000, - result 80
Workaround: set the rate to 0.8% and leave the deductible % on 100%

Reply