1,526

(26 replies, posted in Reporting)

All such PHP 7.x gotchas can be made into a separate php7.php file to be included if a PHP7.x version is in use.

1,527

(26 replies, posted in Reporting)

@joe: Can we change all such each() constructs using @cleal's function?

1,528

(26 replies, posted in Reporting)

Quite a few other pages need the changes even if not all listed in my previous post. Would a generic PHP 7.2 function / class file be created with such overrides so as not to have to makes such changes everywhere?

1,529

(26 replies, posted in Reporting)

A search for the string "= count(" reveals several places in several files:

1,530

(1 replies, posted in Setup)

When inventory need not be tracked and allocations are not envisaged, a direct expense can be booked.
Read the Wiki.

1,531

(27 replies, posted in Setup)

https://github.com/PHPOffice
https://github.com/PHPOffice/PhpSpreadsheet

Please do the same for fpdi/fpdi.php

1,533

(7 replies, posted in Reporting)

There are 4 matches in reporting/includes/tcpdf.php (committed) and 1 in reporting/includes/fpdi/fpdi. (line 396).

The foreach() construct has been in existence for quite a while, the each() was convenient as an all-in-one list() assignment as well. PHP 7.2+ seems to be reducing alternative coding constructs as part of their "standardisation".

1,534

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

Kindly provide the GitHub Link other than here.

1,535

(27 replies, posted in Setup)

Any excel manipulation can be coded into a PHP file and executed on demand and later made into an extension. Exporting data from FA and then doing copy/paste and excel formula gymnastics will certainly make for un-appreciated "hard work" and time drudgery.

1,536

(20 replies, posted in Setup)

There is no real difference in installing FA 2.4.2 or 2.4.4 and moving it across PHP versions since only a few config files are generated during the install. If the code in the core and the extensions used are compatible with the appropriate version of PHP, then all should be okay.

The upgrade, however may not be that straightforward across PHP versions. Various users experiences on and off the wiki/forum will need to be referred.

Upgrade of PHP version will affect older FA installs. The older PHP functions / syntax may have gotten removed in later PHP versions.

There is probably no change in the way Amount in Words is used in FA for quite some time spanning multiple versions. How does the system know that the preferred language of the Supplier / Customer is non English?

1,538

(20 replies, posted in Setup)

Switch service provider or check if they allow multiple versions of PHP to co-exist (CGI?).

Take a backup of the FA DB and the scripts (if you have specific versions of extensions / customisations).

The DB v10.x is that of the MySQL plugin replacement called MariaDB.

There are no real MySQL DB changes from v2.4.2 to v2.4.4 other than some records for the sys_prefs table records and their dependencies.

1,539

(20 replies, posted in Setup)

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.

The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).

The databases may have to be upgraded on first admin login into each company.

Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

Check the FA 2.4.4 announcements page for changed file set.

Or integrate the backends and provide reciprocal links in one another if they are independent applications.

1,542

(9 replies, posted in Setup)

@joe: Worth adding to the core with either a checkbox or sys_prefs flag?

1,543

(9 replies, posted in Setup)

Set the PDF to auto print in the printer preferences if the print profiles do not work. Choose a network capable POS printer of use a software driver for it or open the appropriate port like CUPS Ports 515, 631, 9100-9102 TCP on your router and windows firewall.

1,544

(9 replies, posted in Setup)

Then there is no need to make print profiles. Just print the PDF reports directly onto the local printer.

Also make sure your active fiscal year matches the date you wish to input your invoices. In the first instance, the year ended on 31st August and the invoice was input in September and hence the date was set as the last day of the active fiscal year which was the real previous fiscal year by the time the invoice was entered.

1,546

(9 replies, posted in Setup)

Is POS location different from FA location?
Is there a different printer connected to the POS machine?

Yes. Overwrite the existing file.

Actually it is not an extension. It is just a simple php file placed in the FA root and executed therefrom or used online from my server. See my earlier post.

1,549

(4 replies, posted in Setup)

Use the Company Name as Text instead of dropdown  for login. Set the config.db variable $text_company_selection accordingly.

1,550

(10 replies, posted in Accounts Receivable)

GL code for customer??