Generate your Malaysian Chart of Accounts here.

1,502

(24 replies, posted in Reporting)

Alternatively, make an extension for it, overwriting the variables that hold the output of the said include files.

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. 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 wink . !

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

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

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

(2 replies, posted in Accounts Receivable)

Can you use a unit of 100s?

Make sure you have openssl extension enabled in your PHP.ini and restart Apache.

@joe: What happens if the dimension fields get populated during bank transactions? Will it affect anything else? Any rationale for this current restriction?

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.

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

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

@poncho1234: You had uploaded on as a jpg and another as a png in the wiki - is that okay?

1,515

(10 replies, posted in Report Bugs here)

@joe: does this need a fix in FA 2.4.4?

1,516

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

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

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