Actually it is not an extension. It is just a simple php file placed in the FA root and executed therefrom or used online from my server. See my earlier post.
1,526 10/08/2018 03:59:23 pm
Re: Auto Chart of Accounts Generator (2 replies, posted in Misc. Charts of Accounts)
1,527 10/08/2018 03:45:27 am
Re: Conceal companies (4 replies, posted in Setup)
Use the Company Name as Text instead of dropdown for login. Set the config.db variable $text_company_selection accordingly.
1,528 10/08/2018 03:42:59 am
Re: Sales Invoice, debit note (10 replies, posted in Accounts Receivable)
GL code for customer??
1,529 10/07/2018 04:07:40 am
Re: Build a web based ordering tool connected to our FA system (3 replies, posted in Jobs wanted/offered, non-free offers)
Actually, to simplify the extension design, all customers must be registered in the FA system natively first before getting to use the online ordering. Their customer id can be then tagged to a separate set of tables having it's own authorisation, possibly integrated into WordPress and the likes of WP-Adminer plugin for simplifying UI design.
Simpler still will be to have a dumb insecure form with no usernames / passwords that generates a long hash code after populating a standalone table where even rubbish / unauthorised info can get in, throttled by some CAPTCHA system. One of the fields will be a user hash code in that form. The salesman's interface to this rubbish table will be to select "his" customer's records only and decide what to do. If the salesman chooses to capture it as a valid order possibly corroborated in other ways (phone, email, etc), then he can paste the hash code of the customer request record into the FA subsystem which should then populate another field in the rubbish table with the Sales order number from the FA system. This way there is no need for any username/password for the customer.
1,530 10/05/2018 03:19:00 am
Re: Customer statement reflecting wrong balance (19 replies, posted in Report Bugs here)
@joe: see if you want to implement @braathwaate's version of rep108.php, diff attached.
1,531 10/05/2018 03:11:08 am
Re: Bank Rec (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,532 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,533 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,534 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,535 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,536 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,537 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,538 10/02/2018 08:55:26 am
Re: Customer statement reflecting wrong balance (19 replies, posted in Report Bugs here)
@joe: any solution?
1,539 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,540 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,541 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,542 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,543 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,544 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,545 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,546 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,547 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,548 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,549 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,550 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.