5,726 Reply by apmuthu

(2 replies, posted in Installation)

Yes this is a known issue with some shared hosting accounts especially with subdomain accounts using the redirect method.

FA v2.3.11 works in such circumstances.

The includes/session.inc file got changed to accommodate faillog and may need header session changed from private to private nocache.

Make sure that in such VPSes, the /etc/hosts file has the subdomain entry as well.

One incompatible hosting service identified is shell.gridhost.co.uk on their CentOS 5.2 VPS (read from the /etc/issue file).

If anyone finds the settings to make it work despite disabling the .htaccess file do let the users know.

Go to forum: Installation

5,727 Reply by apmuthu

(10 replies, posted in Announcements)

Attached in this post is the diff file set from FA v2.3.13 to v2.3.14 along with a single patch file as well.

The new release is equivalent to Mercurial Changeset 3153.

Kindly note that the mere extraction of this zip file is insufficient in general to perform a real update. The new config.default.php variables need to be scrutinised and appropriately inducted into the existing config.php file. Any database changes between the standard schema of the sql/en_US-new.sql and the existing database for each company must be propagated thru with any new fields being accounted for with sensible defaults. The Upgrade page in the Wiki can be updated with user experience for each version migration.

Go to forum: Announcements

5,728 Reply by apmuthu

(23 replies, posted in Wish List)

All fixes in this post have been incorporated except ed10's link request where the fix is provided here in Janusz post #18.

Go to forum: Wish List

5,729 Reply by apmuthu

(3 replies, posted in Reporting)

Is this desirable to be added in the current version?

Go to forum: Reporting

5,730 Reply by apmuthu

(1 replies, posted in Installation)

Thanks Joe, Mercurial Changeset 3143 fixed it.

Go to forum: Installation

5,731 Reply by apmuthu

(23 replies, posted in Wish List)

sales/customer_invoice.php was slated to be updated with the fix here in v2.3.14 - it appears not to have been done as yet.

Go to forum: Wish List

5,732 Reply by apmuthu

(4 replies, posted in Reporting)

Thanks Joe. Mercurial Changeset v3142 did it.

recalculate() is now a normal function in includes/current_user.inc instead of being in 2 different class files. It can be further modified to (intelligently) selectively expand only the text fields needed - possibly through an array containing boolean values in each report for allowing expansion.

Go to forum: Reporting

5,733 Reply by apmuthu

(2 replies, posted in Installation)

Thanks Joe.
For the record, Mercurial Changeset 3150 did it.

Go to forum: Installation

5,734 Topic by apmuthu

(2 replies, posted in Installation)

During an inadvertant commit in Mercurial Changeset 2297 of the file update.html the encoding got changed to iso-8859-2. Please revert to iso-8859-1 in the said file as well as in both (application and install) empty.po files.

Go to forum: Installation

5,735 Reply by apmuthu

(3 replies, posted in Reporting)

In that case, then the default page to be displayed should be Add New Quotation Form when there are no Quotations in the database - that way we need not bother about the database warning ever occurring here.

Thanks for the clarification.

Go to forum: Reporting

5,736 Topic by apmuthu

(3 replies, posted in Reporting)

In sales/includes/db/sales_order_db.inc in the function get_sales_order_header we have a few hardcoded strings:

Line 310: You have duplicate document in database

Line 317: You have missing or invalid sales document in databaseYou have missing or invalid sales document in database

In the demo company, Reports => Customers => Print Sales Quotations results in the following error:

You have missing or invalid sales document in database (type:32, number:0).

The database does not have any demo data for sales quotations - it does not degrade gracefully.

Almost all variables in reporting/inxludes/doctext.inc need to be gracefully degraded like line 40:

$this->formData['document_date'] = this->formData['ord_date'] ;

which should become

$this->formData['document_date'] = isset($this->formData['ord_date']) ? $this->formData['ord_date'] : '';

Go to forum: Reporting

5,737 Reply by apmuthu

(4 replies, posted in Reporting)

Attached is the patch file to update the reporting/repXXX.php files in synch with the unstable branch prior to the Orientation Feature induction. This will help clarify errors if any before orientation inclusion.

Go to forum: Reporting

5,738 Reply by apmuthu

(4 replies, posted in Reporting)

Analysing what and how to backport from Unstable 2.4 to Stable 2.3.13 Mer Build 3141:

Copy over reporting/includes/reporting.inc from Unstable to Stable
Others can be backported directly for orientation:
101 - 106, 114, 201-204, 301-306, 401, 501, 701, 704-710
rep 107, 110 & 113 (can backport block of logic), must exclude new FA 2.4 field while backporting
rep 108, 109, 111, 409 block of logic can be backported with / without orientation
rep 112 backport with removal of inline deprecated function (3027 mer build done in unstable) with / without orientation
rep 209 - beware that get_tax_for_items() function has changed due to new tax_algorithm field in 2 tables.
rep 210 - backport with removal of inline deprecated function get_allocations_for_remittance() (3027 mer build done in unstable) with / without orientation

rep 601 - only beware of new fa 2.4 function get_counterparty_name in includes/types.inc used instead of older function payment_person_name which is still available
rep 702 - only beware of new fa 2.4 function get_subaccount_name() in gl/includes/db/gl_db_accounts.inc used instead of older function payment_person_name


function payment_person_name from includes/types.inc used in reports 601, 702 and 704 (in 602 [copy of 601 with reconcile] and 704 in unstable as well)
function get_subaccount_name() [rep 702] and is_subledger_account() in FA 2.4 in gl/includes/db/gl_db_accounts.inc

Go to forum: Reporting

5,739 Reply by apmuthu

(9 replies, posted in Setup)

Please state the exact numbers involved in the division / multiplication like base amount and / or final amount, taxrate(21%), erroneous amount (29.29, 29.30) name, etc.
Also one navigation is given as General Ledger > Tax Inquiry and what is the other navigation for invoice?

Go to forum: Setup

5,740 Topic by apmuthu

(1 replies, posted in Installation)

Whilst the stable v2.3.x code seems to have been following the PHP 5.3 standards in some places, the Unstable v2.4 seems to be lagging - example the file:
Line 3121 reporting/includes/Workbook.php:

if (ereg("^\"[^\"]{0,255}\"$", $this->_current_token)) {

should follow the stable version and be:

if (preg_match("/^\"[^\"]{0,255}\"$/", $this->_current_token)) {

The above is the only instance of the leftover ereg function.

Go to forum: Installation

5,741 Topic by apmuthu

(0 replies, posted in Installation)

Please open a separate topic for Unstable / FA v2.4.

Attached here is a one difference found in the file reporting/includes/pdf_report.inc between the stable and unstable branches:

--- FA3140_Stable/reporting/includes/pdf_report.inc    Fri Nov 23 11:45:56 2012
+++ FA3140_UnStable/reporting/includes/pdf_report.inc    Tue Jan 15 18:28:07 2013
@@ -386,7 +386,7 @@
            'DebtorName', 'supp_account_no', 'wo_ref', 'debtor_ref','type', 'trans_no',
            'StockItemName', 'tax_id', 'order_', 'delivery_date', 'units_issued',
            'due_date', 'required_by', 'payment_terms', 'curr_code',
-            'ov_freight', 'ov_gst', 'ov_amount', 'requisition_no', 'contact'),
+            'ov_freight', 'ov_gst', 'ov_amount', 'prepaid', 'requisition_no', 'contact'),
        'branch' => array('br_address', 'br_name', 'salesman', 'disable_branch'),
        'sales_order' => array('deliver_to', 'delivery_address', 'customer_ref'),
        'bankaccount' => array('bank_name', 'bank_account_number', 'payment_service')

There is no such difference between the respective reporting/includes/excel_report.inc files.

Currently prepaid seems to be used only in one report, viz., reporting/rep107.php.

In both stable and unstable branches, there are 2 reports rep502.php (Dimensions) and rep703.php (GL Account Group Summary) that are commented out in the file reporting/main_report.inc - any info on this?

Also, in the FA v2.4 Unstable branch, there is one report - rep602.php (Bank Statements with Reconcile) that does not seem to appear anywhere in reporting/main_report.inc ! This report has not been updated as yet for the Orientation feature.

The maximum number of parameters used in reports are in rep707.php where PARAM_0 to PARAM_10 (total 11) are used.

In table 0_debtor_trans , a new TINYINT field tax_included has been introduced in FA 2.4 Unstable that has changes in some of it's reports - 107, 110, 113. This must be taken into account if reports are to be backported to the stable version.

Go to forum: Installation

5,742 Reply by apmuthu

(7 replies, posted in Reporting)

Then a synch of essential changes from 2.3 into 2.4 is overdue.

Go to forum: Reporting

5,743 Reply by apmuthu

(7 replies, posted in Reporting)

Any chance of porting the reports to the stable branch or are they directly usable with the stable branch?

Go to forum: Reporting

5,744 Reply by apmuthu

(16 replies, posted in Wish List)

See this thread - It works in Foxit Reader as well.

In Foxit Reader:
Edit -> Preferences -> Trust Manager -> Enable Safe Reading Mode -> Uncheck

Go to forum: Wish List

5,745 Reply by apmuthu

(6 replies, posted in Report Bugs here)

It works with latest Foxit Reader v5.4.4 on WinXP SP3. See screenshots.

In Foxit Reader:
Edit -> Preferences -> Trust Manager -> Enable Safe Reading Mode -> Uncheck

All recent versions of PDF Readers disallow Web access by default. We need to enable it when we are sure.

Go to forum: Report Bugs here

5,746 Reply by apmuthu

(9 replies, posted in Setup)

What version of MySQL / PHP are you using - is it possible that it is a quirk of some computation rounding off errors in some versions? What are the numbers involved - Tax Rate, Amount given, Amount expected?

Go to forum: Setup

5,747 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Which PDF reader?

Adobe Acrobat / SumatraPDF Readers work.

Go to forum: Report Bugs here

5,748 Reply by apmuthu

(16 replies, posted in Wish List)

Works in Adobe Acrobat Reader X
Works in the Browser plugin in MS IE 8 and FF 18.0
Works from Sumatra PDF Reader v2.2.1 - 2.5 MB

Please let me know which PDF Reader it did not work.

If the PayPal Link is necessary to be shown in full, maybe we can add a config variable (all companies) for it or a setup preference (sys_prefs) variable for it (per company basis). The patch contains the native way to populate a link in TCPDF with no dependency of FPDF parsers. The latest TCPDF also has ShotCodes, Extended barcodes / QCodes as well.

Go to forum: Wish List

5,749 Reply by apmuthu

(14 replies, posted in Installation)

1. Backup v2.3.11 - SQL, config_db.php, config.php, installed_extensions.php lang/linstalled_languages.inc
2. Uninstall all extensions.
3. Backup SQL again along with the said files
4. rename the frontaccounting folder.
5. extract latest mercurial build onto new frontaccounting folder
6. install FA to another dummy db.
7. compare the saved files (config_db.php, config.php, installed_extensions.php lang/linstalled_languages.inc) with the currently installed ones and make changes to use the old db.
8. Login to the 0 company and go to Setup -> Software Upgrade and force an upgrade.

Post your php.ini file along with the output of:
uname -a
php -m

Better still, VNC your desktop which can be chrooted into your cloud server.

Report Generator extension is broken / unsafe for FA v2.3.13+

Go to forum: Installation

5,750 Reply by apmuthu

(32 replies, posted in Reporting)

Thanks Joe, Mer Build 3136 fixes the login company field width.

Go to forum: Reporting