It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
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.
@itronics: need to update the sql/alter2.1.php at line 73 (line 71 in v2.3.25+) replacing 0_ hardcoding to ".TB_PREF.".
Done in my FAMods - commit and removed all CRs (crlf => lf) as well later.
Use the links from my earlier post. The official SF link / release download has some bugs fixed later in the repos.
@notrinos: Thanks. Fork my GitHub repo and include your extension and update it there and send in a pull request.
Replaced the said lines with:
$emp_id = $_POST['person_id'];
$from_date = DateTime::createFromFormat("m-d-Y H:i:s", $_POST['from_date']);
$to_date = DateTime::createFromFormat("m-d-Y H:i:s", $_POST['to_date']);Updated your extension and removed whitespaces and attached herein.
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.
FA uses MySQL whilst many applications use MS Access. PHP on Windows allows for interfacing with both MySQL and MS Access. Attached herewith is the possible choice of PHP data connection strings for both MDB and ACCDB versions (2000 and 2007) of MS Access databases and sample usage PHP code to interface with it.
Those who run POS applications based on MS Access can use this means to interface with FA.
Further interfacing sample code is available in my GitHub repo.
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.
From PHP 5.4 onwards, a new type of array syntax has been introduced amongst other changes.
<?php
$array = array(
"foo" => "bar",
"bar" => "foo",
);
// as of PHP 5.4
$array = [
"foo" => "bar",
"bar" => "foo",
];
?>If these libraries like PHPMailer, (as fixed in phpList) or other code snippets are going to be ported to FA for use in earlier versions of PHP than v5.4, then we will need to code them back to the earlier simple array() syntax.
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?
MySQL I expect has been restarted.
Which version of FA are you using?
Where did you take it from?
The latest versions are at:
FA 2.3.25+
FA 2.4RC1+
@notrinos: good work.Attached the same zip file without the MAC OS temp files. Updated file attached in a later post.
How? What assistance do you need? Any Irish users?
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
You will need to build a custom extension for it in FA.
What version of Excel are you using? Does the OS have the necessary language installed? It works correctly in Excel 2007 atleast for English.
Please read @joe's post above (4th post). @randr and @seahawk have not provided their sql dumps for analysis.
Rebuilding indexes in FA is quite simple - drop the index and recreate it from the schema in the Chart of Accounts used.
Windows or Linux Server?
PHP/MySQL versions?
The discount % is stored as an integer in the database table. Attempting to put in a string with % in it will break FA. Make a module for it.
Please alter all flag fields:
`inactive` TINYINT(4) NOT NULL DEFAULT '0',to be:
`inactive` TINYINT(1) NOT NULL DEFAULT '0',The following should achieve it:
ALTER TABLE `0_departments` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_overtime` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_salaryscales` CHANGE `inactive` `inactive` TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE `0_salary_structure` CHANGE `type` `type` TINYINT(1) NOT NULL COMMENT '0 for credit,1 for debit';Attached is the sql after above changes.
This has something to do solely with the code rendering the images - graphs. Check if there are any hard coded character sets used.
FA does not have any payment integration out of the box.
1. Roll your own extension for it or
2. Integrate FA with any POS software which has one or make/buy one for that.
Most Mobile Payment service providers would be happy to make it free for you to get traction for their business.
All or most reports in FA have the option of outputting in Excel.
All FA Reports can be customised (see the reporting/repXXX.php files) and new ones made.
Assume you are using a Windows desktop.
1. Install XAMPP for Windows.
2. Use a version that runs PHP 5.3.x, probably in the XAMPP v1.x series.
3. Install Frontaccounting after downloading the latest stable version into the XAMPP htdocs folder.
4. Refer the Wiki.
Since you are interested in the Chinese language, it would be best if you install the latest Chinese Language Extension and then take it from there. Each language used by FA must be an element in the $installed_languages array.
I have an example for the Tamil language in my repo (recently updated) you can use for reference.
Make a mockup of the final payslip printout pdf file and link it in here. We can then hammer out the tables needed. Highlight the data elements in different legend-ed colours for each of the following, data as pertinent to:
1. This pay slip instance only
2. All Pay Slips
3. This employee only
4. All such designations/pay scales
5. All such payment accounts
Only after the ERD as above is done, should we begin to make the module code and menu items.
QNAP can host multiple websites. Setup a joomla instance in the QNAP device and then ftp the FA files into it instead of the joomla file and folder structure.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.