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

Re: Tax Report and Inquiry Bug

I have problem this same issues. @kvvaradha could you help this?

Re: Tax Report and Inquiry Bug

Hello guys,
I was bit stuck with temple consecration. I just  checked it.  You need to have additional condition during the time of creating journal entry. That will be the only way to fix it. Journal entry works for both sales and purchase, so input and output tax both handled inside one transaction.  But you guys found an issue which we are not applying the conditions properly.

If you guys apply extra condition, which helps to fix this issue. Post it for the community welfare. And also check in the forum carefully. May be someone has solution in it already

Subscription service based on FA
HRM CRM POS batch Themes

Re: Tax Report and Inquiry Bug

This issue has now been fixed and committed to stable repo.

Joe

5 (edited by rafat 11/15/2021 08:21:19 pm)

Re: Tax Report and Inquiry Bug

@Joe

The Tax report now shows Tax on Bank Payments, Customer Credit Notes ...etc. I believe this should not be the case because now the Inquiry and the Report don't tally. Of course I prefer these to be included but then both the Inquiry and Report should be the same.

I think we should stick to the previous version of rep709 if we are not introducing Tax on Bank Payments ..etc...

Re: Tax Report and Inquiry Bug

Yes, I guess I will have to check the rep709 again.

Joe

Re: Tax Report and Inquiry Bug

Tax Report (rep709.php) has been checked, tested and committed to stable repo.

/Joe

Re: Tax Report and Inquiry Bug

One last thing @Joe and hopefully we will be out of the woods:
The tax within the QE in the Supplier Invoice (GL Items for this invoice) is accounted for in the report but in in the Inquiry.
So either we remove from Report or add to Inquiry. (I prefer add to Inquiry)...It depends of course on the requirement of different users.

Re: Tax Report and Inquiry Bug

Ok, I see.
Will have a look. It is rather complex all these issues, however we will fix it.

Joe

Re: Tax Report and Inquiry Bug

Fixed and committed to stable repo. Thanks for helping @rafat.

Joe

Re: Tax Report and Inquiry Bug

Yes sir @joe. Its working as expected. Thanks for your efforts.