Try taking the English one and translating it and then putting in the specifics for Finland.
All the SQLs for the various languages are listed out at my unofficial FA Repo:
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Charts
5,101 06/16/2014 03:06:16 am
Re: Finnish COA (1 replies, posted in Misc. Charts of Accounts)
5,102 06/16/2014 02:59:52 am
Re: Default Language not Propagating into Reports (3 replies, posted in Setup)
_("xxx") is the function for retrieving the gettext strings from a po/mo compiled file.
To hardcode it just make it "xxx" by removing the function syntax.
See that the en_US locale has been installed in the linux server as well for the locale issue.
5,103 06/16/2014 02:54:23 am
Re: how to add table like Sales Invoice Items (2 replies, posted in FA Modifications)
Is it just a link back to the Sales Items page to add new Items?
5,104 06/16/2014 02:53:11 am
Re: Purchaseman and salesman in purchaiging and sales invoice (1 replies, posted in Reporting)
"purchase man" ?
Is it the broker for a sale?
The purchaser is already listed isn't it?
5,105 06/16/2014 02:47:57 am
Re: Simple REST API (45 replies, posted in Modules Add-on's)
What has the Autofactura (Site - Translation: Self Invoice) project (based on Ruby/Gems) got in common with Front Accounting?
5,106 06/16/2014 02:44:20 am
Re: User Access Level and Speed (21 replies, posted in Report Bugs here)
phpGACL can to be plugged in if the ZendACL is not easily understandable / implementable.
5,107 05/30/2014 03:45:57 am
Re: Securimage CAPTCHA Integration into FA (9 replies, posted in FA Modifications)
Which version of FA are you using and what platform and LAMP version is it being deployed in.
Have you downloaded the securimage library and integrated it in as well?
5,108 04/17/2014 01:58:25 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
This sql comes from function get_customer_trans() in sales/includes/db/cust_trans_db.inc.
This issue is fixed in:
https://frontaccounting.com/punbb/viewtopic.php?id=4528
Upgrade to FA v2.3.20 and apply the fixes. See posts:
https://frontaccounting.com/punbb/viewtopic.php?pid=19496#p19496
and
https://frontaccounting.com/punbb/viewtopic.php?pid=19720#p19720
5,109 04/17/2014 12:30:37 am
Re: Primary Development Repo from mid May 2013 - Git (17 replies, posted in Announcements)
At the time of the first post, Hg repo on SF was not updated for the public to view and then the Git Mirror was setup. Later Joe/Janusz clarified that the Hg repo is still the main repo where the stable and unstable branches reside. The official Git mirror provides only the stable version. My personal GitHub repo is updated only when I have the time and it also contains the extensions files. Please see the FA Wiki for link details on it's main page.
To view the date of last update and te update itself, you need to browse the commits:
https:/sourceforge.net/p/frontaccounting/mercurial/commit_browser
These code pages from SF need to be viewed in FireFox and not in MSIE for best results.
5,110 04/13/2014 02:29:23 pm
Re: Release 2.3.20 (9 replies, posted in Announcements)
Post 2.3.20 Changed Files till 2014-04-08.
5,111 04/13/2014 02:19:33 pm
Re: Reorder level email (6 replies, posted in Items and Inventory)
Thanks Joe. Wiki-ed it.
Can the first clause of the WHERE statements in the changed files be part of an INNER JOIN clause?
Affected files:
inventory/includes/inventory_db.inc
sales/includes/db/sales_order_db.inc
5,112 04/13/2014 03:08:59 am
Re: Primary Development Repo from mid May 2013 - Git (17 replies, posted in Announcements)
The Hg repo is still the main repo and the official git is only a mirror and it is available only for the default tree (note change in Hg URL):
https:/sourceforge.net/p/frontaccounting/mercurial/ci/default/tree/
My Unofficial GitHub Repo is at:
https://github.com/apmuthu/frontaccounting
and it includes the extension files as well.
5,113 04/05/2014 02:52:25 am
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
Thanks for the quick fix Joe. Hope there are no more such instances of session dependencies.
5,114 04/05/2014 02:43:55 am
Re: Adding extra fields in Journal Entry screen (1 replies, posted in FA Modifications)
If it needs to be stored in the database, create a new table with a 1:1 relationship with the table into which you would normally add these fields and then make an extension for it.
5,115 04/05/2014 02:41:48 am
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
Try to rollback to a version before PHP 5.5.x and revert with the results.
Hope you are using MySQL_PDO or MySQLi instead of MySQL driver, else try with the MySQLi driver even without changing the PHP version.
5,116 04/04/2014 04:30:36 am
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
This has something to do with $order_no being absent in one of the three calls to the add-audit_trail() function in sales/includes/db/sales_order_db.inc
5,117 04/04/2014 04:19:05 am
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
@joe: Thankyou Joe, when codeing it, I was thinking only of the function arguments and not the order...
@crspencer: Yes, it will now have to be your versions of PHP/MySQL or their implementation in the Server OS used. Ref: MySQL v5.5.13 Deprecated use.
5,118 04/03/2014 12:40:17 pm
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
Nice catch.
Replace the file inventory/manage/items.php with the file in the attachment in this post.
Joe - please fix it in the Hg repo - attachment has the patch as well.
5,119 04/03/2014 08:38:59 am
Re: What's the best online solution for this? (1 replies, posted in Accounts Receivable)
Try adding more columns - one for each envisaged payment and then you will find FA interesting....
5,120 04/03/2014 08:37:14 am
Re: Back Button closes window (3 replies, posted in Report Bugs here)
Which Browser, Which version and What OS?
5,121 04/03/2014 08:36:11 am
Re: Activating Chart of Account (1 replies, posted in Banking and General Ledger)
Setup -> backup and then compare with any CoA you want, make changes, upload and restore.
5,122 04/03/2014 08:35:04 am
Re: how does FA perform with huge data? (1 replies, posted in Accounts Payable)
No problems
5,123 03/14/2014 01:08:04 pm
Re: Convert WHERE to LEFT JOIN in cust_trans_db SQL (2 replies, posted in Accounts Receivable)
Should we then use INNER JOINS for all joins here?
Thank you for the explanation of the differences.
5,124 03/14/2014 01:04:22 pm
Re: gl_db sql convert where to join (2 replies, posted in Banking and General Ledger)
Then INNER JOIN would be a good replacement for the last join as it mimics the WHERE very well and uses the indices when available.
5,125 03/13/2014 04:18:46 pm
Re: £ sign in currency (4 replies, posted in Report Bugs here)
The insert statement in many CoA sql sets including the default show "?" for "£". Try to use some hex editor or a special character aware text editor like Notepad++ to edit the sql files before use.
Also using a MySQL client like SQLyog (they have a free community edition) will get the job done.