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,527

(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 replies, posted in Accounts Receivable)

GL code for customer??

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.

@joe: see if you want to implement @braathwaate's version of rep108.php, diff attached.

1,531

(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 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 replies, posted in Accounts Receivable)

Customer Debit Note: Does a negative value work?

1,534

(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

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

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

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

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