Generate your Malaysian Chart of Accounts here.
1,501 09/27/2018 05:59:38 pm
Re: Not able to Install/activate themes/charts/extensions (8 replies, posted in Installation)
1,502 09/27/2018 03:19:01 am
Re: New Copy of Sales Order (24 replies, posted in Reporting)
Alternatively, make an extension for it, overwriting the variables that hold the output of the said include files.
1,503 09/27/2018 03:16:07 am
Re: Not able to Install/activate themes/charts/extensions (8 replies, posted in Installation)
1. Get the Malaysian Chart of Accounts (have they done away with GST now?).
2. Edit the SQL as desired.
3. Upload the Chart SQL file into the <FA PATH>/sql/ folder.
4. Now login to your default company and create your new company with the new chart that appears in the select box.
1,504 09/27/2018 03:13:37 am
Re: Recurring Invoice for sales group with different item price (4 replies, posted in Accounts Receivable)
1. Take FA DB backup
2. Make 1 invoice entry manually
3. Take new FA DB Backup
4. Use WinMerge or similar DIFF program and compare the DB Backups taken in 1 and 3 above.
5. You will see the INSERT / UPDATE statements of interest - create them in a spreadsheet and execute them on your DB directly with some support MySQL constructs.
If you cannot get anyone to do it for a fee (post in the Job Offers board) and are willing to pay "an arm and a leg" for it, PM me . !
1,505 09/26/2018 03:48:39 am
Re: Not able to Install/activate themes/charts/extensions (8 replies, posted in Installation)
Manually install the necessary extensions for now and then check if your ISP's IP was blacklisted in the repo host. They are also in my unofficial FA 2.4 extensions repo.
1,506 09/26/2018 03:47:02 am
Re: No access to GL entries (3 replies, posted in Banking and General Ledger)
If you are on a public hosting service, then ask them to provide for atleast a CGI means of running an older version of PHP. Most hosting plans now allow for this. If you are hosting it on a custom VPS / physical server you have access to and manage yourself, then you can do likewise as well by choosing an appropriate repo that has the older version for your OS.
1,507 09/25/2018 06:58:44 pm
Re: Deliver Over original order amount (2 replies, posted in Accounts Receivable)
Will the sales order allow editing to increase it in the first place? A new sales order can be part of the same invoice too.
1,508 09/25/2018 06:57:39 pm
Re: Decimal Places on invoice (2 replies, posted in Accounts Receivable)
Can you use a unit of 100s?
1,509 09/25/2018 06:56:01 pm
Re: Not able to Install/activate themes/charts/extensions (8 replies, posted in Installation)
Make sure you have openssl extension enabled in your PHP.ini and restart Apache.
1,510 09/23/2018 03:04:03 am
Re: Need to see Dimension on Bank Statement (12 replies, posted in Report Bugs here)
@joe: What happens if the dimension fields get populated during bank transactions? Will it affect anything else? Any rationale for this current restriction?
1,511 09/21/2018 07:17:04 am
Topic: No exchange rate working in FA now (20 replies, posted in Report Bugs here)
Even the stable ECB exchange rate seems to fail in FA most of the time atleast here in India - not IP blocking but something else and from localhost on windows.
The ECB site page for the forex has a For developers link with php constructs used to acquire the exchange rate and all are in EURO as expected. The page has not changed but does not recognise the IP based url and redirects the http to https though.
1,512 09/21/2018 06:40:49 am
Re: Sales order price after tax and shipping tax (1 replies, posted in Accounts Receivable)
Check the sys_prefs table records and their Web UI settings pages. Also check your config.php values.
Setup your Shipping tax in tax groups - also see this post.
1,513 09/21/2018 06:38:29 am
Re: No access to GL entries (3 replies, posted in Banking and General Ledger)
The default document numbering system may have changed to the new FA 2.4 defaults during the upgrade and the new company specific sys_prefs table record values and config.php values need to be re-jigged.
The actual problem you may have encountered in your old version install would have been a change in PHP version in the OS updates that may have caused the functionality breakage.
1,514 09/20/2018 04:24:52 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: You had uploaded on as a jpg and another as a png in the wiki - is that okay?
1,515 09/20/2018 04:23:15 pm
Re: Inventory Valuation (10 replies, posted in Report Bugs here)
@joe: does this need a fix in FA 2.4.4?
1,516 09/19/2018 06:36:20 pm
Re: Upgrade from 2.4.2 to 2.4.4 (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.
1,517 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,518 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,519 09/16/2018 02:37:14 pm
Re: Wrong column comment in table crm_contacts (1 replies, posted in Report Bugs here)
1,520 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,521 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,522 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,523 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,524 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,525 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.