FrontAccounting forum — Tax Report not showing data

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Thu, 11 Jan 2018 09:05:27 +0000

Thanks apmuthu

That is what I thought had happened, was happening....!

It just might be easier to start over with the correct COA ...!

Re: Tax Report not showing data

null@example.com (apmuthu) — Wed, 10 Jan 2018 23:29:55 +0000

It is possible that your earlier attempt using the erroneous CoA would have some remnants that would need to have been purged before attempting a fresh install.

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Wed, 10 Jan 2018 09:09:22 +0000

Thanks

So I have uploaded this [corrected my BBE actually highlighted it!] to the server Mysql DB and wiped the records existing !

Whilst in this state I checked the Tax report but again to no avail.

So I reinstated from BackUp but I am no further forward. How do I get this correct COA into FrontAcc and get the Tax Report to show

I am a bit lost here - any help would be great

Thanks

Re: Tax Report not showing data

null@example.com (apmuthu) — Sun, 07 Jan 2018 07:18:02 +0000

Thanks @Foxyhimself and @bazza.
Fix committed.

Re: Tax Report not showing data

null@example.com (bazza14) — Sun, 07 Jan 2018 01:46:24 +0000

The offending line in /var/www/html/FA/sql/ en_GB-general.sql is

('1005', '', 'Goods Received Clearing account', '2', 0);

Change it to

('1005', '', 'Goods Received Clearing account', '2', '0'),

Then run $ mysql -h server-name -u root -p data-base-name < en_GB-general.sql

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Sat, 06 Jan 2018 09:46:48 +0000

Thanks apmuthu

I have attempted to upload this one to the DB but I get a page of errors - 505 of them followed by:

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1010', '', 'Freehold Property', '1', '0'),
('1011', '', 'Goodwill', '1', '0'),
' at line 1

Re: Tax Report not showing data

null@example.com (apmuthu) — Sat, 06 Jan 2018 03:16:28 +0000

The British CoA (among others) is broken as far as order of fields in some tables are concerned. The Official pkg repo has not been updated. Check with the schema of the en_US-new.sql.
Have a look for corrected one here.

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Fri, 05 Jan 2018 12:30:09 +0000

No .... still not displaying anything

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Fri, 05 Jan 2018 12:12:37 +0000

Its OK went and read Wiki so am updating

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Fri, 05 Jan 2018 11:30:22 +0000

Thanks apmuthu

I am on British COA - latest

I am on the 2.4.3 of 09/11/2017 - I have downloaded the issue of 11/12/2017 but I am unsure of how to update

Re: Tax Report not showing data

null@example.com (apmuthu) — Thu, 04 Jan 2018 18:07:50 +0000

Which Chart of Accounts are you using? Update FA to the latest codebase and try.

Re: Tax Report not showing data

null@example.com (Foxyhimself) — Thu, 04 Jan 2018 16:24:21 +0000

I have a screen grab of empty entries

Tax Report not showing data

null@example.com (Foxyhimself) — Thu, 04 Jan 2018 16:23:18 +0000

I have 2.4.3 on MacOSX and safari

I run the Tax report for the month of December and I get no data showing so I have to manually retrieve data

Any ideas?