Topic: Tax Report and Inquiry Bug
Tax Report Showing Negative Value
I am facing Two problem with Tax in FA
Problem Number 1.
when i use same Gl for both sales and purchase tax in tax setup like Sales Tax
and enter the sales or purchase transaction through direct invoice
it shows correct in both tax inquiry as well as tax report
but when i post the voucher through journal entry
Journal Date Account Code Account Name Dimension Debit Credit Memo
2021.11.07 2150 Sales Tax 1,300.00
2021.11.07 2100 00001 Accounts Payable: a 11,300.00
2021.11.07 5615 Advertising & Promotions 10,000.00
Total 11,300.00 11,300.00
Like this tax inquiry shows this
Where journal Transaction effects on both Charged on sales (Output Tax) and Paid on purchases (Input Tax):
Type Description Amount Outputs/Inputs
Tax 13% Charged on sales (Output Tax): 1,300.00 10,000.00
Tax 13% Paid on purchases (Input Tax): -1,300.00 -10,000.00
Tax 13% Net payable or collectible: 0.00
Total payable or refund: 0.00
But tax report shows correct as per sales Gl
Now my question is how to fix this error so that tax inquiry will show the correct amount as per Tax GL
Problem Number 2
when i use different Gl for both sales and purchase tax in tax setup like Sales Tax and Purchase Tax
and enter the sales or purchase transaction through direct invoice
f
it shows correct in both tax inquiry as well as tax report
but when i post the voucher through journal entry
Journal Date Account Code Account Name Dimension Debit Credit Memo
2021.11.07 1200 00001 Accounts Receivables: a1 113,000.00
2021.11.07 2150 Sales Tax 13,000.00
2021.11.07 4010 Sales 100,000.00
Total 113,000.00 113,000.00
It shows Correct in Tax Inquiry
Tax 13% Charged on sales (Output Tax): 13,650.00 105,000.00
Tax 13% Paid on purchases (Input Tax): -1,300.00 -10,000.00
Tax 13% Net payable or collectible: 12,350.00
Total payable or refund: 12,350.00
But in Tax Report
Tax Rate Outputs Output Tax Inputs Input Tax Net Tax
Exempt 0.00 0.00 0.00 0.00 0.00
Tax 13.00% -95,000.00 -12,350.00 -10,000.00 -1,300.00 -13,650.00
Total payable or refund -13,650.00
Journal Entry 001/2021 2021.11.07 a1 a1 -100,000.00 13.00 -13,000.00 Tax
Sales Invoice 001/2021 2021.11.07 a1 a1 5,000.00 13.00 650.00 Tax
Supplier Invoice 1 2021.11.07 a -10,000.00 13.00 -1,300.00 Tax
The amount we enter Through Journal Entry of Sales Has been displayed in Negativ Value which is -100000