FrontAccounting forum — Tax Report not showing data

Re: Tax Report not showing data

2018-01-11T09:05:27Z

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

2018-01-10T23:29:55Z

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

2018-01-10T09:09:22Z

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

2018-01-07T07:18:02Z

Thanks @Foxyhimself and @bazza.
Fix committed.

Re: Tax Report not showing data

2018-01-07T01:46:24Z

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

2018-01-06T09:46:48Z

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

2018-01-06T03:16:28Z

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

2018-01-05T12:30:09Z

No .... still not displaying anything

Re: Tax Report not showing data

2018-01-05T12:12:37Z

Its OK went and read Wiki so am updating

Re: Tax Report not showing data

2018-01-05T11:30:22Z

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

2018-01-04T18:07:50Z

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

Re: Tax Report not showing data

2018-01-04T16:24:21Z

I have a screen grab of empty entries

Tax Report not showing data

2018-01-04T16:23:18Z

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?