1 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi wbaileynzl,

I have been emailing Janusz with any details I can find and I think it's been tracked down to an sql setup file glitch.

I have used en_GB-general.sql to setup my companies, so I don't know if the fix below applies yet.

Janusz recommends this fix:

I think we have finally found the problem. Probably you haven't tax_types
table created in your database.

We had a bug in en_US-new.sql which caused error during installation when
example data option was not selected.  Unfortunately because of another issue in Create/Update companies page company with broken database was created and the error message is only displayed by the moment.

You can repair your database structure by removing invalid sales_order, sales_order_details, refs records and recreating tax_types table with:

CREATE TABLE `0_tax_types` (
   `id` int(11) NOT NULL auto_increment,
   `rate` double NOT NULL default '0',
   `sales_gl_code` varchar(11) NOT NULL default '',
   `purchasing_gl_code` varchar(11) NOT NULL default '',
   `name` varchar(60) NOT NULL default '',
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

I think you log in to mysql with root password, choose the database for FA then run the above command, I need more advice before I attempt it.

Go to forum: Accounts Receivable

2 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

I emailed janusz as after I did a fresh install with 2.2.3 (new db, db user) the direct invoice function still gave the same errors and produced 3 ghost sales orders.

If I do sales order->delivery->invoice there's no problem at all, so something is up with the direct sales invoice function in the code.

It seems to be seeing the location as blank for some reason, but I'm sure you will figure it out-if i was any good at php i would try and figure it out myself smile.

Cheers,

David

Go to forum: Accounts Receivable

3 Reply by londondaveuk

(6 replies, posted in Accounts Receivable)

Hi,

A company that you sell to may have different offices or branches, so you can setup those in branches, otherwise you would have to setup a different company for each office-normally you just need the one

Go to forum: Accounts Receivable

4 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

Thanks for all this help by the way.

I checked php.ini, on ubuntu it's session.save_path and it's not set by default just commented out.

I decided to set the session.save_path to "/tmp" as an experiment but the problem still persists; after restarting webserver, clearing browser cache and attempting another direct sales invoice same problem and error message.

Cheers,

David

Go to forum: Accounts Receivable

5 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

Thanks for that.

What does the 'check save_path for session variables' mean? What do I have to do to check that?

Cheers,

David

Go to forum: Accounts Receivable

6 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

You read my mind, I set go_debug to 1 and this was the log output when I tried to enter a direct sales invoice:

[11-Jan-2010 12:52:19] PHP Fatal error:  Call to a member function run() on a non-object in /var/www/html/frontaccount/includes/session.inc on line 22
[11-Jan-2010 12:52:22] PHP Fatal error:  Call to a member function run() on a non-object in /var/www/html/frontaccount/includes/session.inc on line 22
[11-Jan-2010 12:52:25] PHP Fatal error:  Call to a member function run() on a non-object in /var/www/html/frontaccount/includes/session.inc on line 22

The progress arrows start blue, turn red then the warning triangle icon appears.

Thanks for your help,

David

Go to forum: Accounts Receivable

7 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

I have emailed the system diagnostics output (from setup) as a pdf to you.

It all looks ok really apart from I am using lighttpd and not apache.

Cheers,

David

Go to forum: Accounts Receivable

8 Reply by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi Joe,

Can't see anything in the log to do with direct sales invoices or sales orders which I tried to post yesterday, the only error that occurs regularly is:

[10-Jan-2010 21:26:51] 1:admin:class.pdf.inc:63: Declaration of Cpdf::ellipse() should be compatible with that of TCPDF::Ellipse()

When I tried to post the direct sales invoice there were 2 revolving progress arrows which stopped an then the red warning triangle icon. When I checked the sales order transactions I found the raft of sales orders that I cannot delete?

David

Go to forum: Accounts Receivable

9 Topic by londondaveuk

(16 replies, posted in Accounts Receivable)

Hi,

I tried to enter a 'direct sales invoice' having setup cutomers & branches etc, when I clicked on 'place invoice' an exclamation mark triangle appears at the top of the screen. I have tried to enter direct sales invoices a few times but the sytem will not post them, I just keep getting the warning triangle? This happens as admin or a user.

After doing a sales order enquiry, I found 27 sales orders even though I have not entered any. When I click on an order # or attempt to edit one I get:

Database error: FATAL sales order returning nothing-0 plus a whole lot of other errors?

Where am I going wrong here and how do I delete the empty sales orders?

I am using Linux ubuntu server and FA 2.2.2.

Thanks for any help.

David

Go to forum: Accounts Receivable

10 Topic by londondaveuk

(4 replies, posted in Accounts Payable)

Hi,

Is there a way to produce a remittance that you would send/email, so a supplier can see what invoices/credits make up a payment to them.

Thanks for any help,

David

Go to forum: Accounts Payable

11 Reply by londondaveuk

(3 replies, posted in Reporting)

Hi Joe,

Thanks for the info.

What I am after is an aged creditors report that will show only the invoices due at a certain end date. For Invoices/Credits FA uses the due date and for payments it uses the Invoice date (trans date?). The same with aged debtors, you only really want to know the ones due for payment or for chasing.

So if the end date is 15/01/2010 (dd/mm/yy) then it would display only the invoices etc that are due on or before that date-I'm sure I could work out a report with repgen.

Go to forum: Reporting

12 Topic by londondaveuk

(3 replies, posted in Reporting)

Hi,

When I use the 'aged supplier' report it seems to just display all outstanding invoices, the 'end date' does not seem to effect the outcome.

If I have a payment term of 30 days set for each supplier, how do I get the report to only display invoices that are 30 days+ older than the 'end date' on the report screen?

Thanks for any help,

David

Go to forum: Reporting

13 Reply by londondaveuk

(6 replies, posted in Modules Add-on's)

Hi,

Changing the go_debug setting in config.php worked, so repgen is up and running.

Thanks.

Just a thought, when I did the upgrade from 2.2.1 to 2.2.2 if as root on the server I do:

tar xvfz frontaccounts.xxx -C /var/www/html

then that will replace the whole frontaccounts directory including any themes or modules. Is there a drawback to using

cp -a frontaccounts.xxx/* /var/www/html/frontaccount/

which saves you having to backup the modules and themes directories as it only overwrites the files that are in the upgrade tarball?

Cheers,

David

Go to forum: Modules Add-on's

14 Reply by londondaveuk

(6 replies, posted in Modules Add-on's)

Hi,

I was using v2.2.1 and just upgraded to 2.2.2.

Now when I try to run the 'accounts list' report from repgen I get a whole page of:

%PDF-1.3
3 0 obj
<</Type /Page
/Parent 1 0 R
/MediaBox [0 0 595.28 841.89]
/Resources 2 0 R
/Annots [<</Type /Annot /Subtype /Link /Rect [50.00 806.00 155.79 790.00] /Contents (1) /NM (0001-0000) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)>> /H /I>><</Type /Annot /Subtype /Link /Rect [50.00 787.00 102.91 779.00] /Contents (1) /NM (0001-0001) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)>> /H /I>><</Type /Annot /Subtype /Link /Rect [120.00 787.00 182.27 779.00] /Contents (1) /NM (0001-0002) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)>> /H /I>><</Type /Annot /Subtype /Link /Rect [50.00 775.00 92.23 767.00] /Contents (1) /NM (0001-0003) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)>> /H /I>><</Type /Annot /Subtype /Link /Rect [50.00 763.00 74.46 755.00] /Contents (1) /NM (0001-0004) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)>> /H /I>><</Type /Annot /Subtype /Link /Rect [400.00 799.88 455.51 790.88] /Contents (1) /NM (0001-0005) /M (D:20100104234236) /Border [0 0 0] /C [] /A <</S /URI /URI (1)

I am using the latest version of repgen for 2.2, any ideas?

Thanks,

David

Go to forum: Modules Add-on's

15 Topic by londondaveuk

(6 replies, posted in Modules Add-on's)

Hi,

When I try to run the 'accounts list' report I get the following error:

Unsupported operand types in ..../frontaccount/reporting/includes/tcpdf.php on line 6193

Does anyone know how to fix this?

Thanks for any help

David

Go to forum: Modules Add-on's

16 Topic by londondaveuk

(2 replies, posted in Installation)

I have noticed that in my frontaccounts dir the following dirs are set to world read/write:

company, lang, modules & tmp

Anyone know what the correct secure permissions are for frontaccounts directory and contents?

Thanks for any help.

Go to forum: Installation

17 Topic by londondaveuk

(1 replies, posted in Installation)

Hi,

I am trying to update from 2.2RC to the new 2.2 (stable). The update instructions just don't work, they don't seem to make much sense.

If I have a directory /var/www/html/frontaccount which is version 2.2RC, after I have downloaded the 2.2 stable tarball, what are the exact steps to update?

I have is two directories:

/var/www/html/frontaccounts- this is my working version 2.2 RC
/var/www/html/frontaccounts-2.2 -this is the new stable 2.2

What do I do now to get a sucessful update?

My only addons are the elegant theme and I am using en_GB.sql for companies created after install-not the original Testing.Co.

[SOLVED]

I took this from nolapro:

download 2.2 update, untar it -but not in the directory where your working frontaccounts install is or it will overwrite the whole thing.

Eg: I have working frontaccounts in /var/www/html/frontaccounts (/var/www/html is my webroot) and the update is in /home/me/frontaccounts

As root or using sudo, I did cp -a /home/me/frontaccounts/* /var/www/html/frontaccounts/

That means you don't have to backup any themes etc as they will not be overwritten. Only anything new in the update will be written to your working frontaccounts dir.

All you have to do now is chmod -R www-data.www-data /var/www/html/frontaccounts/ or whatever your webserver user is set to. Then make the changes to config.php (if any) and follow the rest of the install guide.

Go to forum: Installation

18 Topic by londondaveuk

(2 replies, posted in Reporting)

Hi,

Is there a way to display reports directly to the browser screen instead of a pdf viewer? Just like the trial balance report.

Go to forum: Reporting