3,251

(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,254

(5 replies, posted in Installation)

This is available in the Wiki too.

3,255

(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,256

(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,257

(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,259

(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,260

(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,261

(19 replies, posted in Report Bugs here)

Test with latest FA v2.3.25+.

3,262

(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,263

(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,264

(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,265

(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.

3,266

(19 replies, posted in Setup)

The dashboard theme must be installed
and then the dashboard extension as well
and then activated too.
Backup before installing them.

If you are upgrading,
take a backup,
then de-activate the dashboard extension,
choose a normal standard theme and
uninstall the dashboard theme and extension.
Now upgrade the FA, install the dashboard theme and extension and activate and choose them. Import your reminders selectively from your backup.

3,267

(1 replies, posted in FA Modifications)

No

3,268

(6 replies, posted in Items and Inventory)

Check the same type of transactions in the demo Chart of Accounts and see what difference it makes. State FA version / build.

Which version of FA are you using? Which supplier did it generate a credit for? The utilities account should not be a supplier if you do not wish to track inventory and payments. It should be a general expense account. Check your Chart of Accounts.

Kindly post links of sample templates you find missing in FA after checking to see if they are already there amongst the reports. What you expect from within FA may already be there in the Wiki. As for PHP hooks, you can fork the FA codebase and design as per your needs and submit a pull request.

3,271

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

The detailed search on specific columns of database need to be designed. Most common ones are already there.

@trecords: Use the latest version 2.3.25+. State your Browser/Server/Platform/PHP versions. Clear cache of browser.

@ericgroen: Clear cache of browser. Test with latest version and provide feedback.

3,273

(4 replies, posted in Setup)

Refer Wiki and Forum Post.

Please check if the error still persists in the latest FA code so that it can warrant inspection. The URLs listed (amongst others) may have changed the functionality that may have cleared the error.

@joe: is this by design?

3,275

(4 replies, posted in FA Modifications)

The debtor_trans_details table has the rate info.
The field debtor_trans_type's value of 10 needs to be taken as it is the ST_SALESINVOICE, whilst the value of 13 represents the actual ST_CUSTDELIVERY. By filtering the field as needed for either price history based on invoice (10) or delivery (13) you can make a report based on other report templates / report extension modules. Take care to remove entries matching transaction numbers' items for voided entries.