1,576

(20 replies, posted in Setup)

The change file list between the said versions and the changed files thereafter are all available in the Announcement thread.

FA_2.4.2_to_FA_2.4.4_changed_files.zip

FA24_post_release_fixes_2018-09-15.zip

@poncho1234: See attachments to your post.

1,578

(6 replies, posted in Setup)

Then everything is a service charge!
All are your profits as you have provided them!

@joe: atleast this can be done in FA 2.4.x itself!

Fixed in my repo's FA24Mods.

@itronics commit.

Reimbursements can be treated as cash advances to original purchasers and then a payment allocation and settlement to them. Otherwise, a normal cash purchase can be entered and cash given as reimbursement and recorded in the memo accordingly. The latter will not track supplier.

When one Vendor's payment needs to go to another vendor upon suitable authorisation, it is best to create a credit/debit note pair for each vendor and then make the allocation as normally done.

@joe: fix in core?

This happens when there are no transactions in function get_customer_trans_version() in sales/includes/db/cust_trans_db.inc. The construct at lines 37-43:

    $sql= 'SELECT trans_no, version FROM '.TB_PREF. 'debtor_trans
            WHERE type='.db_escape($type).' AND (';

    foreach ($trans_no as $key=>$trans)
        $trans_no[$key] =     'trans_no='.db_escape($trans_no[$key]);

    $sql .= implode(' OR ', $trans_no) . ')';

can be modified to be

    $sql= 'SELECT trans_no, version FROM '.TB_PREF. 'debtor_trans
            WHERE type='.db_escape($type).' AND trans_no IN ('.implode(',', db_escape($trans_no)).')';

This can be implemented in FA 2.4 itself as it only affects one small index. FA 2.5 is certainly years away and such important db changes should not be delayed. Remember how long FA 2.4 was in the making.....

The code changes however, are independent of the index.

Thanks. Their free plan provides for:

Currency values are refreshed every 60 minutes.
Maximum of 100 requests/hr & 2 query conversions per request

1,585

(8 replies, posted in FA Modifications)

Please search and read the forum before asking.

Dashboard is integrated into FA 2.4.x. If your theme is Dashboard enabled, then it can have it's permissions / roles activated for it and does not require the Dashboard theme / extension at all in FA 2.4.4.

1,586

(5 replies, posted in Setup)

FA is multi tenant. You can choose to hos each company in a separate database or use different table prefixes and place them in the same table. Each "tenant" is then chosen in the login screen. The FA code is just a single instance but each company has it's own folder for it's data files.

If you create User A in both companies with same / different passwords, FA will accept that as well, since the users table is different for each company (with either different table prefixes in the same database oand/or different databases).

The tree structure actually exists in FA only that it appears flat in a table. With the sub-ledger concept, the parent-child relationship exists but not used by most. Drill Down is also available in FA. You can write a script to read the chart of accounts and display it as a tree for your understanding as an extension if you want.

@joe: nice fix?

The following service providers support XCD:

Oanda
mataf.net
CoinMill.com
XE.com
GoodReturns.in

Maybe we should use a plugin system for Exchange rates.

1,590

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

You can use my unofficial version for PHP 5.3.

A suggested mod may be in order in the meanwhile.

1,592

(3 replies, posted in Banking and General Ledger)

If you use the sql/en_US-new.sql as your Chart of Accounts it will be without the dummy data.

1,593

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

Then, don't forget to logout and login again.

@joe: should a flag be used or should it simulate the old functionality with the inclusion of the said code?

1,595

(5 replies, posted in Setup)

This is clearly a FA user and company instance. The login system uses the company name from the $db_connections array in config_db.php file. The login user and password come from the appropriate database's users table.

If you need to implement it this way, then the following should suffice as $qoh=0 for the first computation:

if ($qty > 0 && ($qoh != -$qty)) {
    if($qoh == 0 && $avg_cost != 0)
        $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/$qty)/2;
    else
        $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);
}

Hope the first computation too will remain a weighted average cost.

@joe: Please verify and include if okay. Why was this done in the first place - was it the remnant of some debug coding? Or must there be a flag to suppress zero entries?

@joe: is this the desired design outcome?

@joe: any developments?

The last version of CMS archived home page is of v12.1 / 2009. They still state that they are a Microsoft Silver Partner and the DB may still be MS SQL Server.

You may want to use the SlimAPI as a REST client to push batch info into FA.

The version of the REST API tested for FA 2.4.x is here.