FrontAccounting forum — Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2020-04-29T17:45:54Z

@joe: does this deserve a reconsideration?

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2020-04-28T14:16:23Z

It's an old topic, but the solution worked very well. Now the direct bank entries are visible in the tax report again. I uploaded the rep709.php version from 2005 (!!!) and it worked fine.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-31T04:31:36Z

Please checkout the 'working' report from FA 2.3.22 (may need a few tweaks from the FA 2.4.2+ one) and see if all is as you desire. Then place it in your company/#/reporting folder to override the standard version and you should be good to go.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T21:45:46Z

Hello,

I am not sure which is the correct way of generating the report, but ideally tax report should show all Input amounts, Output Amounts and the tax amounts for these particular output/input amounts. And if possibles the rate of tax.

When I currently generate the tax report, it doesn't show me my Input amounts where the tax was 0%. But it does show me output amounts where the tax was 0% percent.

Would someone be able to help with the codes so that we can achieve above basic format ?

Thank you

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T20:19:36Z

See the diffs between the rep709.php across the versions to revert to whichever functionality you want.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T18:03:04Z

This is not the case with FA 2.3.22 where all tax details are pulled by the TAX Report.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:54:24Z

As it stands, FA's Tax report is restricted to Sales and Purchase Invoices and possibly goods returns (on appropriate credit notes) if entered as standard transactions and not as quick entries or journal / bank entries.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:49:20Z

All postings from these documents are expected to show up on TAX Report.
Transcation Type
Journal Entry 0
Bank Payment 1
Bank Deposit 2
Sales Invoice 10
Customer Credit Note 11
Supplier Invoice 20
Supplier Credit Note 21

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:47:37Z

Please see my latest post. Even Invoices are not populating reg_type files if GL entries are used. And with reg_type field as NULL the Tax Report shows no results.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:32:12Z

Quick Entries are a means of entering non document type journal entries. Payment of taxes does not constitute tax incurred or accrued on Supplier/Customer invoices. All standard document types have their own data entry form and type that reports respect.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:32:04Z

On Supplier Invoice
Items Received Yet to be Invoiced - Tax Report shows the taxes incurred
GL Items for this Invoice - Tax Report doesn't show the taxes incurred

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:21:39Z

I just posted another supplier invoice using a quick entry and the reg_type filed on tax detail table was not populated. This could be due to quick entries.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T17:16:15Z

I am using quick entries in bank payments with taxes. And these postings don't show up on tax reports.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T16:51:29Z

Taxes collected from customers and
Taxes incurred in invoices from suppliers only should form the part of the Tax Report (reporting/rep709.php) .

Hence there is no issue here.

Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice

2017-10-30T16:13:53Z

Correction to my post. Direct Invoice is ok. Only Bank Payment taxes are affected.