Search options (Page 96 of 97)

With pleasure .

BTW the backup/install needs some more help/cleanup I think, but I'm out of time lately and Joe is more insider in this matter then me, so you can talk to him when he will be back next week.

Receipts are calculated in balances after allocation. So if all amount on sales invoice or receipt is allocated respective Outstanding column on Customer Balances Report states zero. This not apply for older buggy records on demo site, where amounts for receipt /customer credits where entered with bad sign.

Anyway the report needs corrections as deliveries should not be counted into balances - corrected.

Thanks a lot for testing effort.

Hello alex,

Yes, there is some simplifications in db_import function which are cost of smaller source code size. The import function must work properly with FA backup files, and it do.

Anyway when MySQL dump file is made out of FA installation (for example via phpmyadmin) correct settings ensure compatibility with db_import(). First of all  this is MYSQL323 compatibility option and DROP TABLE + IF NOT EXISTS usage.
With other options you can experiment to achieve best results.

Janusz

I cannot reply this issue. Which FA release do you use ?

I'm not sure I understand your need correctly.
Could you explain how do you think it should work (step by step) ?

Hmm, I'm not sure. CVS is superior tool for cooperative developers work. The command line utilities could be difficult for users which use only windows, but what about the TortoiseCVS? This is GUI application and (I think) it should follow Windows user interface philosophy.

Anyway if you want to have latest source code I can pack it and post to you. Send me your email address via forum private message.

Can you unpack tar.gz archive without troubles?

Janusz

In Front Accounting v.1.16 all document printing is available only via Report Module.

This should change in forthcoming version 2.0. At least we'll add links to printing after document entry which is partially implemented in unstable CVS branch.

All this is Joe work which now is on short holidays. Please exhort him about this within a week .

Janusz

Hello wildkactus

The system where you running Front Accounting is not important as the software works  correct on Win as well as on any Linux flavour.

If you have db tables filled via phpmyadmin you should also enter database connection parameters to config_db.php manually. Finally you should have access to account 'admin with login 'password'.

Regards
Janusz

Hi all,

First of all we do not use SVN. All the code (stable and unstable) is stored in CVS server on sourceforge.net. So if you want to check the source out,  you must use any CVS client. Under Windows this is for example TortoiseCVS: http://www.tortoisecvs.org/.

I'm afraid I cannot help with Windows CVS clients as I do all my activity entirely under Linux and beside this I rather prefer console tools, then GUI. Nevertheless in any GUI client there should be any entry form to select current sever, protocol account settings and name of current working branch. You must find it yourself.

All the code is available from anonymous CVS, so you can connect without any password. As on any anonymous CVS server you can connect without any password (login 'anonymous') but you have only read access. So if you want to submit any code which can be usable to FA community you must send it to Joe or to me.

I strongly advice reading sorceforge.net info on CVS access. They have also step by step instructions for some GUI CVS clients.

Janusz

OK. I'm happy I've helped you.
BTW I want point out that our team is involved in next FA release development, so the old stable version can have slower support now. If you have some spare time and want to test new functionalities of FA v.2 you can do it on our demo site http://fa2.iron.from.pl or simply upload new version from CVS (unstable branch). This is in alpha stage, however - beside smaller bugs we do not know about - all should work. All response is highly appreciated.

Janusz

Hi wkeull

You are right I'm afraid. This is a bug in FA v.1.16. If you want to patch your local  source tree below is attached fix which you should apply to sales/inquiry/customer_inquiry.php. Or you can wait for next FA 1.xx release. Thanks a lot for your testing effort.

Janusz

97c97,101
<             AND ".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue
---
>             AND (".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "')
>             AND ((".TB_PREF."debtor_trans.ov_amount + "
>               .TB_PREF."debtor_trans.ov_gst + "
>               .TB_PREF."debtor_trans.ov_freight )>".TB_PREF."debtor_trans.alloc
>         )) AS OverDue

Hello again,

I've just  found it.
This is problem of some old MySQL extensions for php which do not like ';' in 'create' queries. This bug affects MySQL client API version 3.23.58 at least. The problem will be fixed in CVS soon.

You can fix it yourself too in your local copy of FA, here is the patch:

diff -r1.5 maintenance_db.inc

163c163
<             if (strtolower(substr($line, 0, 1)) == ")")
---
>             if (strtolower(substr($line, 0, 1)) == ")") {
164a165,166
>                 $line = substr($line,0,strlen($line)-1);
>           }

Regards
Janusz