1,526

(1 replies, posted in Banking and General Ledger)

Generally the ID field gets to be the order of display if the date field is not doing it. There may be other places where the date stated could be used like in the audit trail table and some summary records if any. Extract out the actual changes from the difference between before and after one such transaction's backups and see what gives.

1,527

(10 replies, posted in Accounts Receivable)

Actually, the Debit / Credit Notes have allocation potential, otherwise a mere Journal would have sufficed.

@joe: can we make DN/CN for all Suppliers and Customers alike?

1,528

(10 replies, posted in Accounts Receivable)

Customer Debit Note: Does a negative value work?

1,529

(3 replies, posted in Report Bugs here)

This was corrected in the FA24Extensions repo on 2018-01-07. Unfortunately, the official extensions do not check out such fixes from the unofficial repo.

1,530

(1 replies, posted in Report Bugs here)

Does the change straddle an older fiscal year?
If so check your sys_prefs table settings and those in your config.php file as well since many config variables have been moved to company-specific ones in the sys_prefs table.

@chunket: Nice way. Thanks for the feedback.

Clear your cache and the cache in FA.

@joe: any solution?

Generate your Malaysian Chart of Accounts here.

1,535

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

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

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

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

(10 replies, posted in Report Bugs here)

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

1,549

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