@rafat thanks for the suggestion; if I have a chance I'll have another crack at it.

As for the supplier invoice credit note, I have modified line #162 in rep709 from @BraathWaate (I added "ST_SUPPCREDIT,") which seems to have done the trick as my report is now looking good and matches my .xls wink, but I haven't done extensive testing.

If anybody would like to test it, the line now reads:

        } elseif ($trans['reg_type'] !== NULL || in_array($trans['trans_type'], array(ST_SUPPINVOICE, ST_SUPPCREDIT, ST_BANKPAYMENT))) {

Following @rafat's suggestion in this thread https://frontaccounting.com/punbb/viewtopic.php?id=6975 I worked through this thread to try an resolve the issue by implementing the pull request from @BraathWaate but could not get it to work (ended up with a blank screen when trying to logon so I reverted to the old files).

I ended up only keeping the tax report (rep709) that seems mostly fine for my reporting requirements, except for:
- The absence of the bank payments/deposits to the gl tax accounts (as discussed in this thread)
- And a bug I think, because whereas the report does show the supplier invoice credit note item, it is not taking the value into account when calculating the report totals.

Thanks for all your hard work, but I must say it seems like the update to 2.4 caused a lot of issues in the tax reporting that need to be fixed. Is there any more progress on this?

3

(12 replies, posted in Reporting)

rafat wrote:

I think this is a bug that needs to be fixed. Can someone please test with there installation of 2.4.4 and confirm .

I know its an old message, but I have the same problem on 2.4.6. (ie. vat posted on gl accounts via Supplier invoices or Supplier payment transactions not showing up in the tax report.

As suggested by rafat I too restored the old 2.3.26 report rep709 and it seems to have resolved it.

Also I have noticed the tax_inquiry transaction is also not showing the vat.

Has there been any progress on this bug to date?