The change file list between the said versions and the changed files thereafter are all available in the Announcement thread.
1,577 09/19/2018 06:29:33 pm
Re: Inventory Items CSV Import 2.4.0-3 in FA 2.4.4 on MYSQL 5.6.21 (7 replies, posted in Items and Inventory)
@poncho1234: See attachments to your post.
1,578 09/16/2018 02:46:38 pm
Re: Need help regarding service business (6 replies, posted in Setup)
Then everything is a service charge!
All are your profits as you have provided them!
1,579 09/16/2018 02:37:14 pm
Re: Wrong column comment in table crm_contacts (1 replies, posted in Report Bugs here)
1,580 09/12/2018 04:03:11 am
Re: How to do reimbursments or third party allocations? (1 replies, posted in Accounts Payable)
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.
1,581 09/11/2018 04:16:06 pm
Re: error creating customer credit note: Undefined index: sales_gl_code (2 replies, posted in Report Bugs here)
@joe: fix in core?
1,582 09/10/2018 03:37:57 am
Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php (10 replies, posted in Report Bugs here)
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)).')';1,583 09/07/2018 04:56:34 pm
Re: Prevent Duplicate Suppliers Short Name (5 replies, posted in FA Modifications)
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.
1,584 09/07/2018 04:32:05 pm
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
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 09/07/2018 04:30:45 pm
Re: THEME ADDITION (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 09/07/2018 04:27:37 pm
Re: User permission for each company/database (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).
1,587 09/07/2018 04:23:17 pm
Re: Tree Structure design for Account chart (1 replies, posted in Banking and General Ledger)
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.
1,588 09/07/2018 03:52:52 pm
Re: Prevent Duplicate Suppliers Short Name (5 replies, posted in FA Modifications)
@joe: nice fix?
1,589 09/05/2018 07:20:45 pm
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
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 09/05/2018 07:15:37 pm
Re: REST API (86 replies, posted in Modules Add-on's)
You can use my unofficial version for PHP 5.3.
1,591 09/05/2018 07:13:23 pm
Re: Missing store data for Salesman on debtor_trans table (3 replies, posted in Report Bugs here)
A suggested mod may be in order in the meanwhile.
1,592 09/05/2018 07:09:52 pm
Re: Remove all example data (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 09/01/2018 04:15:42 pm
Re: Import functions (3 replies, posted in Modules Add-on's)
Then, don't forget to logout and login again.
1,594 08/29/2018 05:33:43 pm
Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php (10 replies, posted in Report Bugs here)
@joe: should a flag be used or should it simulate the old functionality with the inclusion of the said code?
1,595 08/29/2018 05:26:59 pm
Re: User permission for each company/database (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.
1,596 08/29/2018 05:24:07 pm
Re: Update material cost when quantity on hand is zero (4 replies, posted in Report Bugs here)
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.
1,597 08/29/2018 03:16:31 am
Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php (10 replies, posted in Report Bugs here)
@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?
1,598 08/29/2018 03:14:52 am
Re: Need to see Dimension on Bank Statement (12 replies, posted in Report Bugs here)
@joe: is this the desired design outcome?
1,599 08/26/2018 11:05:53 am
Re: Closing a fiscal year needs to update the query a bit. (9 replies, posted in FA Modifications)
@joe: any developments?
1,600 08/25/2018 03:01:59 pm
Re: Experienced Deleloper - Batch Processing Modifications for FA (6 replies, posted in Jobs wanted/offered, non-free offers)
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.
