How to tax break up in A/R invoice PLD (showing twice tax)
I created a tax group in name of S1 ( Vat , Service Tax, Cess , HCess)
I design my pld for tax breakup in sales A/R invoice.....
VAT @ 5%
Service Tax @ 12%
Cess @ 2%
HCess @ 1%
I create a code S1 for tax type combination. where combined all tax in one S1 code (VAT@5, Service Tax , Cess, HSCess).
then I created a Tax code Setup.
after that I found my tax code combination in A/R invoice and then I run the OSTT in Query Preview where -7 is ID of Nota Fiscal Tax category even i was trying with Numerator value 1 also.
then I design my A/R Invoice PLD
I added in A/R invoice PLD one Repetitive area,
add one Free Text fild F_125 where -7 (ID of Nota Fiscal Tax Category).
add one Database Field F_127 where Table INV4 and Column Authority Code.
add one Formula Field F_128 where F_125==F_127.
add one Database Field F_132 where Table INV4 and Column Tax rate.
add one Database Field F_129 where Table INV4 and Column Tax amount
In repetitive area footer add one Formula field F_131 where Colsum (F129)
everything is ok for one product billing but when I put 2 product in A/R invoice the tax is calculating twice.
But this settings working fine with one product. when I add 2 different product then tax is calculating twice.
It will helpful for me if you have any documentation..
my mail ID is email@example.com
Check it out this link and download tax break up document for 8.81 version