Search options (Page 111 of 246)

It appears that third party extensions are not allowed an extension number in FA. The code is used in function local_extension() in admin/inst_module.php. The function handle_delete() in the same file refers to the version not being a hyphen for a standard uninstall.

Before and After Screenshots attached.

Here is a tedious way of troubleshooting it.
Turn on all debug including select in sql trail in the config file.
Insert the troubleshooting code at each place in the FA scripts sequentially to inspect where the error comes in.
Sample troubleshooting code:

$log_output = "\n\n Start dump of all variables \n\n" . print_r(get_defined_vars(),true) . "\n\n";
file_put_contents('D:/XAMPP/htdocs/fa24/tmp/log_file.txt', $log_output, FILE_APPEND);

To replace line 206 in reporting/rep101.php:

            if ($no_zeros && floatcmp($trans['TotalAmount'], $trans['Allocated']) == 0) continue;

with

if ($no_zeros) {
    if ($show_balance) {
        if ($trans['TotalAmount']== 0) continue;
    } else {
        if (floatcmp($trans['TotalAmount'], $trans['Allocated']) == 0)) continue;
    }
}

@joe: want to commit it?
Committed

Any upgrade will require the first login to be admin on the default company. Thereafter, a login as admin for each company will be in order. The value of the version_id in the sys_prefs table must be 2.4.1 as of now - that is the current database schema version.

1. Take a backup of the database for all companies individually before any upgrade.
2. All v2.3.x installations must first upgrade to the v2.3.26 version even if there is no db change necessary.
3. Take a backup of each company individually again now.
4. Then make sure all is well by checking out the various company instances.
5. Take note of non FA tables and tables belonging to various FA Extensions and the changes in the tables some extensions may have made.
6. Make a clean FA 2.4 installation and use it in the following steps.
7. Create each company manually with the standard en_US.sql in the FA 2.4.x install.
8. Import the FA 2.3.26 backup from step 3 above for every non default company (assuming your default company is just a dummy one)
9. Login as admin into each upgraded company and verify that the software upgrade shows as having been done.
10. Copy over the company folder image and custom reports assets into the new installation.
11. Now install your extensions and verify they work and tweak their tables and changes as needed.
12. Any custom code / tables / schema mods you may have done in 2.3.x must then be ported professionally.

Make sure that the company folder and all it's subfolders are writeable by the web server owner.

To enlarge the F2 screen for customers replace Line 506 in includes/ui/ui_controls.inc from

        113,    _("Customers"), 900, 500),

with

        113,    _("Customers"), 900, 600),

@joe: can commit this.
Committed

Why are we sprinkling variable and array assignments in files that otherwise contain functions only?

After applying @itronics update:

Fiscal years 2016 and 2017 are open.
Company is set to Fiscal Year 2016.
3 Quotes - Nos. 1,2,3 are created in 2017 fiscal year.
1 Quote - No. 4 is created in 2016 fiscal year now during Aug 2017.

The View Quote shows the reference as 004/2016 whereas it should be 001/2016 which it is in the refs table.
The Print Quote shows 001/2016 as the Quote No (reference) in the header and in the middle, it shows Quotation No. 4.

These need to be fixed as well.

If a Sales Quotation is entered in the current fiscal year then all is okay.
Why should you quote as of any older fiscal year?

Check your install and you will find that the Company's current fiscal year is 2016 instead of 2017 (hope you have created 2017).

@joe: I can confirm this to be an issue in FA 2.4.2+. If you enter a Sales Quotation (possibly Sales Order too) in any previous fiscal year then it will not show up in a transaction search (Sales Quotation Inquiry). Also in a listing of Sales quotations, we can disable the GL entries icon. Any further new / edit Sales Quotation entry will show up the last reference value instead of the relevant next ref value for the new one / same reference value of the one to be edited.

Best is not to allow creation of any Sales Quotation in any previous fiscal year with an allow override permission for edge cases like accounting from archived vouchers. In any case this issue needs resolution.

Check your db tables and remember you are using a non-numeric table prefix.

In the db:
1. You have 2 entries for the same item in the same sales quotation but no sales order.
2. You have 1 sales quotation (and the corresponding entry in the refs table).
3. You have no sales invoices.

These can be verified in the Setup -> View/Print Transactions page.

Here is how to trouble shoot it.
1. Take a backup of a freshly installed en_US-demo.sql based default company.
2. Take another backup of your company db.
3. Replace all company db table's prefixes with "0_" to match the first one.
4. Use any diff tool (WinMerge) to check the differences between the two backups.

You did not have the 2017 year in your fiscal years table and I have created it.
You made the sales quotation in Aug 2017 and expected it to be valid till end of Jan 2017!
Your operational fiscal year was 2016 and hence the reference was needed to be reset each time as your quote was for 2017. I have now made it to be the newly created fiscal year 2017.

Now all is well.

As of Feb 2016, the cambell-prince repo had some PHP 7 fixes.

Change all class constructors to be PHP 7 compliant. See this post.

Ref:
https://wiki.php.net/rfc/remove_php4_constructors
https://cweiske.de/tagebuch/php4-constructors-php7.htm
eBook preview of constructor

There have been less than 75 posts each month recently. Sep/Oct/Nov 2016 saw a lot of Spam.

Banned Users        2611
Un Verified Users     244
Non Posing Users     611
Normal Users        2617

If you have registered and did not receive your email address verification mail, check your spam box or junk mail box for it. The "Un Verified" users line above refers to such instances.