I have journal entries with some VAT implications, Which is not appearing in my VAT report.
I hope it is error in the formula which is return in the report to calculate the sales and purchase tax?
Thanks in advance for the help.
Below attached is the formula for sales total and sales VAT calculation on the report.
Total on sales:
AUDIT_SPLIT.TYPE in ("SI","SC") and AUDIT_SPLIT.TAX_CODE="T1" and COMPANY.ADDRESS_4 like ("AJ%") ?
AUDIT_SPLIT.NET_AMOUNT
:
0
VAT Amount:
AUDIT_SPLIT.TYPE in ("SI","SC") and AUDIT_SPLIT.TAX_CODE="T1" and COMPANY.ADDRESS_4 like ("AJ%") and AUDIT_SPLIT.EXTRA_REF not like "BD%"?
AUDIT_SPLIT.TAX_AMOUNT : 0
