This needs to be addressed in the core!

It will need the db user to have trigger and some other privileges as well I think.

ECB does not have SAR:
http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml

5,129

(12 replies, posted in Banking and General Ledger)

Best is to make a single non-normalised table of all the transactions in an excel sheet like manner from the old program and then in FA use a subset of the data for the textcart extension and import them in!
If the excel sheet is standardized and and FA Import extension is made for it, that would be great!

If you wish to do it manually on a staged site, send me your existing version number and what extensions you are using and then provide a sql and web dump - pm me. Upgrade will not be straightforward and it s possible your data may get mangled. The config file too will need some new variables although the devs have taken good care to make it backward compatible.

5,131

(1 replies, posted in Wish List)

Any chance of hacking it into the core?

5,132

(45 replies, posted in Modules Add-on's)

Some posts in the forum indicate it was used for a desktop version of FA.

Is this a candidate for fixing the script that writes the installed_extensions.php file everywhere?

5,134

(3 replies, posted in Setup)

Number of people and the what all roles they will take on will determine the roll out of FA.

5,135

(1 replies, posted in Banking and General Ledger)

Please do not add any fields to existing tables. Make a new table and have a 1:1 relationship with the table you intended to extend and then create an extension to do your extra work.

5,136

(9 replies, posted in Setup)

So frequently changing IPs are generally in mobile based ISP connections. A list of such ISPs where IPs get changed so frequently would be useful to be wikied. Some mobile devices keep changing their MAC addresses in response to which the ISPs keep changing the IPs allotted to them.

5,137

(4 replies, posted in Setup)

http://www.frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram needs updation

5,138

(7 replies, posted in FA Modifications)

Mobile number / Phone Number would be useful to integrate with Asterisk / Call Center Agents. The CallerID will then be able to popup the relevant record without manual search intervention!

5,139

(1 replies, posted in Misc. Charts of Accounts)

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

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

Is it just a link back to the Sales Items page to add new Items?

"purchase man" ?
Is it the broker for a sale?
The purchaser is already listed isn't it?

5,143

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

(21 replies, posted in Report Bugs here)

phpGACL can to be plugged in if the ZendACL is not easily understandable / implementable.

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?

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

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

(9 replies, posted in Announcements)

Post 2.3.20 Changed Files till 2014-04-08.

5,149

(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

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.