1 Topic by Foxyhimself (edited by Foxyhimself 01/04/2018 04:23:37 pm)

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Topic: Tax Report not showing data

Hi

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?

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

I have a screen grab of empty entries

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Tax Report not showing data

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

Post's attachments

TaxReport.pdf 3.4 kb, 3 downloads since 2018-01-04 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

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

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

Its OK went and read Wiki so am updating

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

No .... still not displaying anything

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Tax Report not showing data

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.

apmuthu's Website

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

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

  • From: UK, New Zealand
  • Registered: 10/27/2017
  • Posts: 2

Re: Tax Report not showing data

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Tax Report not showing data

Thanks @Foxyhimself and @bazza.
Fix committed.

apmuthu's Website

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Tax Report not showing data

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.

apmuthu's Website

  • From: UK
  • Registered: 01/04/2018
  • Posts: 8

Re: Tax Report not showing data

Thanks apmuthu

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

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