No, we have no universal report engine in FA. Reports are hardcoded, so some minimal php knowledge and a lot of spare time is needed to customize it. Sorry.
Janusz
2,126 03/25/2009 08:33:46 am
Re: customize paper size (4 replies, posted in Reporting)
2,127 03/25/2009 08:30:33 am
Re: SQL Database Error on Direct Invoice Entry (24 replies, posted in Report Bugs here)
You can send my the db files by email, but once again the date of broken records entry in relation to version upgrade date is important
You have found that the source of error is empty sales_orders.stock_from_loc in some records. Can you find whether those records were added to database BEFORE upgrade, or AFTER? You certainly have db dump made before version upgrade, so it should be easy to find.
When the empty stock_from_loc were in original database, we should deal with bad data during upgrade. Otherwise we have some bug in new code resulting with incorrect sales_order records.
Janusz
2,128 03/24/2009 09:30:00 pm
Re: Direct Sales Invoice, warning (5 replies, posted in Report Bugs here)
Currently only mangling in source code. We will think about some solution in 2.2.
Janusz
2,129 03/24/2009 09:27:22 pm
Re: SQL Database Error on Direct Invoice Entry (24 replies, posted in Report Bugs here)
Were the fatal records with empty from_stk_loc added after upgrade, or before? Anyway it is not good, but we should know this to decide how to deal with this problem.
Janusz
2,130 03/24/2009 02:04:28 pm
Re: Direct Sales Invoice, warning (5 replies, posted in Report Bugs here)
Yes, the ECB data is retrieved when today exchange rate is not set for the currency in local database.
Janusz
2,131 03/24/2009 02:00:34 pm
Re: Vtiger Integration (38 replies, posted in Modules Add-on's)
We have no implemented remote API like RPC/SOAP/Hessian as for now.
If you would like to make some connector to e.g. OSCommerce you will find some local API documentation in download section. Keep in mind that FA is all the time under construction so documentation can be a somewhat outdated.
Anyway you are welcome .
Janusz
2,132 03/24/2009 09:34:23 am
Re: Direct Sales Invoice, warning (5 replies, posted in Report Bugs here)
I f it is temporary error you can set exchange rate manually to stop the warning. If you have no inet connection or really the currency is not noted by ECB you can play with source of get_ecb_rate() in gl_db_rates.inc
Janusz
2,133 03/24/2009 09:28:25 am
Re: Purchases > Purchase Order Entry, supplier not filtered (1 replies, posted in Report Bugs here)
No, they are not. It is subject to change in pending 2.2.
Janusz
2,134 03/24/2009 09:27:23 am
Re: DATABASE ERROR (1 replies, posted in Report Bugs here)
Please check your db consistency after version upgrade. This case was considered here:
https://frontaccounting.com/punbb/viewtopic.php?id=485
Unfortunately original thread author went away without comments.
Janusz
2,135 03/24/2009 09:09:55 am
Re: cheque/cash voucher (2 replies, posted in Modules Add-on's)
You will find cheque module on download section.
Janusz
2,136 03/24/2009 09:04:32 am
Re: Customer / Supplier Balances (7 replies, posted in Reporting)
The end date is here used to limit printout to old, not allocated transactions. This is not for retrieval of customer balances status on given date. For me this is right, as usefulness of historical balances is disputable, while selecting only very old unallocated transactions is not.
Janusz
2,137 03/24/2009 08:52:51 am
Re: Issue with Language (3 replies, posted in Installation)
You must have spanish locales installed on the server with the same encoding as declared on install language page. Without properly configured locales gettext will display english messages.
Janusz
2,138 03/23/2009 03:14:31 pm
Re: Items and Inventory > Items Adjustments Note > Adjustment Items (7 replies, posted in Report Bugs here)
No. All bugfixes to current version are merged to unstable branch after stable minor release. This is because development changes can conflict with bugfixes.
Of course you can try to merge the branches locally for your private use. In this actual case only inserts.js file was changed.
Janusz
2,139 03/23/2009 12:31:17 pm
Re: Items and Inventory > Items Adjustments Note > Adjustment Items (7 replies, posted in Report Bugs here)
I cannot reproduce first issue. All works right for me. Also nothing was changed since 2.1 beside adding CtrlEnter hotkey.
Regarding problem with AltTab this is related to 2.1 hotkeys system. Fixed, main CVS updated. Thank you.
Janusz
2,140 03/22/2009 05:27:09 pm
Re: Date Picker (4 replies, posted in Wish List)
Ok guys,
The idea just has been implemented. The changes are in unstable CVS.
New option in preferences 'Remember last document date' decides whether to use last date during new document entry, or current day is used as so far. When transaction date on new document is not the current one, it is displayed in red as a warning. Enjoy.
Janusz
2,141 03/22/2009 01:12:44 pm
Re: Items and Inventory > Items (7 replies, posted in Report Bugs here)
Fixes for both issues in main CVS.
Thanks again.
2,142 03/20/2009 08:26:26 pm
Re: Items and Inventory > Items (7 replies, posted in Report Bugs here)
Bingo. This is a bug.
Thanks Alvin.
Janusz
2,143 03/19/2009 10:03:49 pm
Re: SQL Database Error on Direct Invoice Entry (24 replies, posted in Report Bugs here)
Could you explain me how have you fixed the problem? I still cannot find the source of the trouble nor reproduce it.
Janusz
2,144 03/19/2009 06:01:46 pm
Re: SQL Database Error on Direct Invoice Entry (24 replies, posted in Report Bugs here)
Well, which one error you have? Database error from post #1 or the problem described in post #7? Both seems to be result of some fails during db upgrade. The first problem cannot be solved without access to local database (see advice in post #6).
Janusz
2,145 03/19/2009 08:53:32 am
Re: How should Quick Entry in GL work ? 2.1RC (3 replies, posted in Banking and General Ledger)
Fix in CVS main trunk. For inpatient: change line 19 of gl/includes/ui/gl_journal_ui.inc to:
global $table_style2, $Ajax;
Janusz
2,146 03/19/2009 06:56:41 am
Re: How should Quick Entry in GL work ? 2.1RC (3 replies, posted in Banking and General Ledger)
Yes, the base amount should update with quick entry selector change. This is a bug.
I had expected the situation to function like this...
Are you clairvoiant?!
Janusz
2,147 03/13/2009 02:30:33 pm
Re: Can't install or Update 2.1 RC (10 replies, posted in Installation)
I have found the reason, I think. This error is raised also when php is running in CGI mode (not APache module). So you can delete .htaccess file and eventually add respective lines to php.ini file:
magic_quotes_gpc = 0
register_globals = 0
Thanks for pointing out this problem.
Janusz
2,148 03/12/2009 09:08:13 am
Re: Can't Delete a company (11 replies, posted in Report Bugs here)
Probably you are using old database on new source tree, where per company subtree is deleted on made unwritable for www server. The subdirectories should have sequential integer numbers beginning from 0 (this has nothing to do with database prefix!). So if you have 5 entries in db_connections (config_db.php) you should have 5 subdirectories from company/0 to company/4. After restoring check if all files have 777 access rights set then delete unneeded company in Create/Update Company page.
Janusz
2,149 03/12/2009 08:41:40 am
Re: Can't install or Update 2.1 RC (10 replies, posted in Installation)
I am happy that all works now for you, although I would be much more happy if I know the exact source of the problems.
The .htaccess file has now two directives which set php parameters to secure values: magic_quotes_gpc=off and register_globals=off. This can also (and should) be set in php.ini file. Without them any application is potentially vulnerable to RFI/LFI attacks. If you run your server in trusted closed environment it does not matter. Otherwise it is a must.
Could you list me your exact configuration where the problem arose (operating system version, www server type/version etc)? I feel this is some issue in your local setup, but anyway this should never end with blocking FA use at all.
Janusz
2,150 03/12/2009 08:31:33 am
Re: Database changes between Beta, RC, and Final? (3 replies, posted in Installation)
Beta releases could involve minor db structure changes if it would be necessary.
No database changes (beside bug fixes) after RC release. During following 2.1.x bugfix releases no new feature will be adopted which would need database structure changes.
Janusz