Search options (Page 126 of 246)

Advance payment to supplier should be a "loan" till the invoice is booked.

Debit Card, direct debit, standing order etc are "cheques" in FA where the Transaction number can be the Cheque Number. Make it part of the name of the Bank Account.

Before safely using strings in SQL statements, cleaning them up has traditionally been done using the likes of mysql_real_escape_string and add_slashes. Whilst the latter can be used for insertion/updation of records in MS Access, the following function will be suited for many instances where offending/unsafe/exploitable characters need to be stripped:

function msaccess_escape_string($str) {
    $lf = "\n";
    $str = str_replace(Array("'", '"', "\t", "\r", $lf, "\\"),"", $str);
    if ($str == NULL) $str = ' '; // Access does not allow null fields to be blank in insert using this method
    return $str;
}

PM me the access details.

Check your PM mailbox.
Your host has switched to PHP 7 - ask them to revert back to PHP 5.3 to 5.6 as it originally was.

You may be able to make the change from your hosting control panel itself like this and if using SuPHP, like this and if using Plesk, like this.

PHP 7 incompatibilities are here.

MySQL functions have been removed in PHP 7 and only PDO_MySQL and MySQLi are available in it now.

Use the links from my earlier post. The official SF link / release download has some bugs fixed later in the repos.

Migrating data from any string format especially the MySQL ANSI date format yyyy-mm-dd into MS Access Short Date format irrespective of the locale setting (m/d/Y or d/m/Y) is done using the DateValue(str DateAsString) function.

Check Wiki.

Although the customer currency is set in the Customer management page (attached), when payment is made, it is generally into the company's main / default bank account and is available as a choice in the Customer Payment page. A possibly related post.

FA does not have the possibility to set the default bank account into which a customer's payment is credited. You can however check past payment bank account creditings of the said customer and use that as a default by customising the code.

The function user_company() is defined in includes/current_user.inc. Check if the said file exists. It may have been inadvertently been deleted or got corrupted (hard disk error). Take a dump of the html folder (web root) and compare with the original version you installed from and see if there are any files that are missing. Check with a filesize and date compare and beware of some false positives where some files may have been overwritten by extensions (rare) or customised.

It is also possible that on date change (next day), the session may ahve expired - cleare browser cache and try to login again or restart the webserver and try. What do the server logs show?

@notrinos: good work.
Attached the same zip file without the MAC OS temp files. Updated file attached in a later post.

Disable the MySQL strict setting and restart MySQL. Later versions of MySQL do not like zero dates: 0000-00-00 and 0000-00-00 00:00:00.

Search your web server folder for error log files. In Windows XAMPP 1.7.3 / Apache it will generally be in WEBSERVER_FOLDER\apache\logs\error.log

What version of Excel are you using? Does the OS have the necessary language installed? It works correctly in Excel 2007 atleast for English.

Windows or Linux Server?
PHP/MySQL versions?