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/05/2018 03:08:11 am
Re: Sales Invoice, debit note (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/04/2018 03:44:02 pm
Re: Sales Invoice, debit note (10 replies, posted in Accounts Receivable)
Customer Debit Note: Does a negative value work?
1,529 10/04/2018 03:42:43 pm
Re: British COA has a syntax error (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 10/03/2018 06:18:06 pm
Re: Quotations - change of dates (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.
1,531 10/02/2018 09:02:33 am
Re: Recurring Invoice for sales group with different item price (4 replies, posted in Accounts Receivable)
@chunket: Nice way. Thanks for the feedback.
1,532 10/02/2018 08:59:53 am
Re: Login Interface Language Different from Preference (3 replies, posted in Translations)
Clear your cache and the cache in FA.
1,533 10/02/2018 08:55:26 am
Re: Customer statement reflecting wrong balance (19 replies, posted in Report Bugs here)
@joe: any solution?
1,534 09/27/2018 05:59:38 pm
Re: Not able to Install/activate themes/charts/extensions (8 replies, posted in Installation)
Generate your Malaysian Chart of Accounts here.
1,535 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,536 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,537 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,538 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,539 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,540 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,541 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,542 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,543 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,544 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,545 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,546 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,547 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,548 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,549 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,550 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.