3,276

(2 replies, posted in Setup)

Contact any of the FA Support consultants in the Wiki.

FA has 78 to 80 tables in MySQL and the schema are well documented. Importing data into FA will be trivial using any MySQL Client (phpMyAdmin, SQLyog, etc).

Creating plugins for features / reports available in your existing accounting system will be the real time hogger.

As you have sufficient tech personnel with Linux experience that should work in your favour.

As far as Magento eCommerce (v1.9.01 2014-05-15) is concerned, upgrading it to the latest version (v2.1.1) will be the first step and as it uses PDO_MySQL, your work becomes easier. The latest version of Magento uses the Zend framework and Symphony quite extensively besides a number of other libraries with their version specifics handled by composer.

If there are any specific roadblock you encounter, the forum here is well supported.

Good Luck.

3,277

(1 replies, posted in Report Bugs here)

Check your upgraded db schema with that of the sql/en_US-new.sql and see what is different.

3,278

(1 replies, posted in Installation)

Copy the FrontAccounting Wiki pages over to your localhost webserver using Win HTtrack or some sort of website copier or use some wiki software (MediaWiki, PMWiki, DocuWiki, etc).

3,279

(9 replies, posted in Setup)

Look at the heading "View/set global locale for all users on a “CentOS/RHEL/Scientific Linux v5.x/6.x” and older" in the CyberCiti.biz link.

3,280

(9 replies, posted in Setup)

Detailed answer specifically for India at CyberCiti.biz.

Also discussed in a forum post.

3,281

(5 replies, posted in Misc. Charts of Accounts)

http://www.oag.go.th/en/home
http://www.thailawforum.com/database1/acconting-act.html
http://www.dbd.go.th/dbdweb_en/ewt_news.php?nid=3937
http://msnagroup.com/thai-accounting-law/
http://msnagroup.com/thai-accounting-standards/
http://www.thailand-business-law-center.com/thailand-tax-and-accounting-regulations-2/
http://www.ifrs.org/Use-around-the-world/Documents/Jurisdiction-profiles/Thailand-IFRS-Profile.pdf
http://www.fap.or.th/
http://www.iasplus.com/en/jurisdictions/asia/thailand

Looks like Thailand appears to follow International Accounting Principles.

Any Thai Accounting professionals would like to check out FA's features and comment on differences?
Any concessions / exemptions for the royalty or special privileged groups?

The reporting standards / requirements can be different everywhere - just build / tweak what reports you need. FA is an open system and can be extended at will.

When an upgrade is done, generally the SysAdmin logs in, logs out and logs in again to check if all is okay. Such upgrade permissions should be unnecessary for the user as the extension should be so designed to upgrade automatically if the admin's records have been updated.

Make sure that the access roles assigned to your other users have the requisite privileges for your activated application.
The password field stores the MD5 of the plain text password unless you have modified it.

3,284

(3 replies, posted in Wish List)

Actually, we need a transaction number for the transaction before attaching files. Also, uploading files when a transaction is being entered will become a waste of time if the latter fails.

You can certainly make a module to extend the transaction entry pages and share the code.

Wiki-ed it.

3,286

(0 replies, posted in Installation)

1. What platform (WinXP, Win 7/8/8/1/10) are you using for your server and browser client?
2. Provide the public download link to the XAMPP binary (version ?) you are using.
3. Provide the download link of the FA build you are using.
4. Which Chart of Accounts are you using?
5. Have you turned Strict mode off in MySQL for the date and time stamps to remain 0000-00-00 and 00:00:00?
6. Is the file includes/current_user.inc available on your server?

Just installed FA 2.4RC1+ dated 2016-09-06 on WinXPSP3 on XAMPP v1.7.3 and all works fine.

@joe: Please move these last 4 posts into a separate thread under installation and if possible make a separate topic for FA 2.4 Installation.

The function user_use_date_picker () is not part of core FA 2.3 but in includes/current_user.inc in FA 2.4. Assume it is part of your module.

function user_use_date_picker()
{
    return $_SESSION["wa_current_user"]->prefs->use_date_picker();
}

The function get_js_date_picker is in FA 2.3 and FA 2.4 in includes/ui/ui_view.inc.

The version of the above function in FA 2.3 uses:

$fpath = company_path().'/js_cache/'.'date_picker.js';

whilst that in FA 2.4 uses:

$fpath = user_js_cache().'/'.'date_picker.js';

This is available in the Wiki too.

3,289

(5 replies, posted in Installation)

This is available in the Wiki too.

3,290

(19 replies, posted in Report Bugs here)

Your zip file was not downloadable.

I have not been able to replicate your issue on a fresh install. Attached are the screenshots of my being able to enter 4 JVs in a row and surviving a browser timeout and editing a JV as well without errors.

My test was done on PHP 5.3.1 on XAMPP in WinXPSP3 for FA 2.4RC1 which should better accomodate PHP 5.4 code. Yours appears to be a specific PHP 5.4 issue or your flavour of Linux's quirks (Cloud OS).

Remove the "?>" (without the quotes) in the last lines in all php and inc files for use of FA 2.3.25+ with PHP 5.4.

3,291

(0 replies, posted in Installation)

The line 74 in includes/errors.inc is:

    $bt = $SysPrefs->go_debug>1 ? get_backtrace(true, 1) : array();

Try to replace it with and see:

    $bt = (($SysPrefs->go_debug > 1) ? get_backtrace(true, 1) : array());

$go_debug is defined in config.php and gets into the $SysPrefs object is all is well.
The backtrace comes in correctly.

The line 85 in the same file is:

        error_log(user_company() . ":$user:". basename($file) .":$line:$context $errstr");

Try to replace it with:

        $msg_tmp = user_company() . ":$user:". basename($file) .":$line:$context $errstr";
        error_log($msg_tmp);

The function user_company() is defined in lines 425 - 430 in includes/current_user.inc:

function user_company()
{
    global $def_coy;
    
    return isset($_SESSION["wa_current_user"]) ? $_SESSION["wa_current_user"]->company : $def_coy;
}

Make sure that the user you logged in as exists in the company's database's users table.

3,292

(19 replies, posted in Report Bugs here)

The code is correct.
The way you entered the JV is wrong.
Each JV must have atleast 2 entries or the default 1060 (in your case) will be the contra entry filling in for the difference of all entries made in the JV till then. You had chosen the default contra account of 1060 (set in Banking & GL => Bank Accounts => Dflt=Yes) as the first entry and then did not provide any second entry as the transfer account.

@joe: JV should not be allowed to proceed if there is only 1 entry and it is the default Bank Account. Also, we need to prevent a JV from being entered if there are 2 entries and both have the same Account Code and Amount (one on the Credit side and the other on the Debit side). Mere transfer of one amount from one account to itself in entirety is meaningless.

Convert the least count as a unit and provide price per unit. Then translate that into tax % for that item.

3,294

(19 replies, posted in Setup)

The Bank Payment is the correct way to go since it also labels it as a different voucher type used by FA in it's processing of payments allocations.

3,295

(19 replies, posted in Report Bugs here)

FA v2.3.25 was released on 2016-02-21. Since then there have been many fixes. Please use FA 2.3.25+ which was last updated on 2016-07-26.

The errors you are getting possibly arise with incompatible php settings for your later version of PHP. What is your PHP/MySQL version and what platform and version is your server on (CentOS 6, Debian 8, etc)?

The offending line 295 in gl/gl_journal.php is:

    $_SESSION['journal_items']->add_gl_item($_POST['code_id'], $_POST['dimension_id'],
        $_POST['dimension2_id'], $amount, $_POST['LineMemo']);

The class member function add_gl_item is defined in includes/ui/items_cart.inc and it was last changed on 2014-09-22, much before the release of the version you are using. The file gl/gl_journal.php was last changed on 2015-03-15 and that too hasn't changed in your version. Hence it must be a generic issue of handling $_POST array's elements and that points to the newer PHP's idiosyncracies.

3,296

(19 replies, posted in Report Bugs here)

Test with latest FA v2.3.25+.

3,297

(2 replies, posted in Accounts Receivable)

If the custom cron php file is in the FA web folder then anyone from outside too can execute it. Why would you want a security vulnerability?

If you wish to directly interact with the FA's DB tables, then write your own php file and keep it outside your webroot and include the relevant files like config_db.php, includes/db/connect_db.inc and operate on them directly.

If you wish to simulate a login and perform the FA's form based operations then use php cURL to achieve it. Teaching PHP is outside the scope of this forum.

Provide an example of what you wish to achieve and in which version of FA?

3,298

(19 replies, posted in Setup)

The function text_input() is declared in FA 2.4RC1 only once in includes/ui_input.inc. If the said file gets included more than once, then any such include / require should be made include_once / require_once. Removal of such seemingly redundant include / require should be done with caution as it may not always be redundant.

Dashboard extension v2.4.0.1 and dashboard_theme v2.4.0.1 are available to be installed via the official FA 2.4 extensions repo. Dashboard hooks are already present in FA 2.4 and as the said function above gets re-declared when using these plugins, they must be fixed.

Alternatively, using disposable functions / a check and unload if present can be attempted before re-defining the said function or naming it differently and using this new name in all dashboard functions (will need to be cascaded into all the dashboard type themes). Lets avoid namespaces.....and PECL runkit / APD's rename_function....

@joe: your thoughts?

3,299

(3 replies, posted in Banking and General Ledger)

I shall assume you are working on FA 2.4RC1 with all fixes till date.

As for the 4 GL Accounts issue, check their entries in the db tables for any record / field differences other than account code and name. Also check their entries in the sys_prefs table if the mischief is in it's being set as some default.

As you are using PHP7, there seems to be a sticky post in announcements that could be useful.

Counterparty is just the contra account in a transfer transaction. It can be between 2 bank accounts or even between some balance sheet entries and P&L entries like in depreciation entry transactions apart from the ones you already mentioned.

3,300

(19 replies, posted in Setup)

Make sure that the said extension's features are enabled for the System Administrator Role.

You might want to try a fresh installation of FA 2.4 and then update the database with the relevant tables' data from your current upgraded backup.