Thanks for the details Januz. A comparative review, even if considered biased, it's low degree of such bias will make for a nice ranking and trust if it is from the horse's mouth so to say.

In fact the ease with which FA could be implemented without a ton of ZZ maintenance scripts was what enticed me to offer it to the OpenVZ (ProxMox VE) community and you will therefore see quite a lot of upgrade requests from v2.2.11 (last released OpenVZ template) to the 2.3 versions. From v2.1 to v2.2.11, every significant development state was diff'ed and patches offered to the community, sometimes even twice a day when warranted, that prompted many to take the plunge into FA.

Thanks for the info Janusz. Please direct me to where you have a Roadmap listed.

Will work on this feature when time permits as it needs a complete implementation.  This is the preferred date format in ASEAN countries what with the EU/US confusion on the date score...especially for CPAs who need to cater to clients across the globe and have "unambiguous" reports.

We need to cull out all instances of
1. Date Display
2. Date Form Fields
3. Date Picker (through wrapper function)
4. Date Picker (any unwrapped)
5. Date field computation
6. Date in SQL unabstracted

Any inputs here will help make for a smooth integration without catastrophic suprises.

Fair enough. Atleast the order of the SQL statements would make it easier to track the changes - All DROP DATABASE statements first, then all the CREATE DATABASE statements and then the INSERT INTO statements all the while maintaining the alphabetical order of table names.

This way, each COA needs to change only in the last part - INSERT INTO statemenst alone.

5,954

(8 replies, posted in Setup)

When we setup a new company and these settings have not yet been decided, we need to have a proper place holder account instead of the very first account that shows up in the drop down list.

Anyway, we can create a Suspense Account in the COA and make it as the default when not assigned as yet.

A complete set of FrontAccounting Tutorials are at:
http://schoolitexpert.com/web/front-accounting

Oh yes, that too! It was in fact the calendar that tripped me several times and continues to do so making me put off such investigation for some later date.....

We need to watch out for converting twice!

Is such a feature fulfillment on the cards in v2.3.x itself?

5,957

(8 replies, posted in Setup)

Thanks Janusz for the P+L clarification. What about the default "Not Assigned" choice for Setup -> System and General GL Setup form ?

Since the chart of accounts across all countries have the same table schema isn't it advisable to bundle the "DROP TABLE", "CREATE TABLE" and some of the common "INSERT INTO" SQL statements into a single database.sql file with the implementation specific "INSERT INTO" SQL data statements (bearing the COA data / demo data) being separated into another sql file?

As there is no provision on this board to attach COAs, I am unable to provide the SG and IN COA files for v2.3.11+ with the new SQL statement order format.

Caveat - the use of UTF8, Latin1 or other collation may warrant a set of ALTER TABLE statements for certain implementations if the proposed order and file separation is used.

Thankyou Januz for the code integration.

Provision of a dynamically linked snapshot in mercurial is trivial and will save the need for installing and operating Mercurial just to get the code. Anyway, as the code changes are few and far between and your regular release schedule takes care of the security fixes it's okay.

The lack of a comparision between WebERP and FA is a pain to explain to every potential end user that FA is an Accounts focussed fork of WebERP.

A small history page with sister forks would be useful to compare notes between projects.

The Debian OpenVZ template is a boon to install many FA sites in a trice each with it's own root access and linux virtual machine. I had provided the ProxMox VE project with FA Templates till v2.2.11 and as there was no real feedback in that community for FA, I stopped updating it.

5,960

(8 replies, posted in Setup)

What is the purpose of the  chart table's account_code2 field?
Must it be unique?

5,961

(8 replies, posted in Setup)

Must the COA have a separate Profit and Loss Account in the chart master or will it be dynamically generated using the chart class of Income, Expense?

Please place a "Not Assigned" dropdown choice in the Setup -> System and General GL Setup form. The label "Profit/Loss Year:' in the said form is confusing

5,962

(27 replies, posted in Dimensions)

An explanation of what tags are and how they fit in here would be nice.

Please let me know if you are interested in providing the OpenVZ template from www.gnuacademy.org on the FA Site. The template will be 180 MB in size. It will also contain the latest SG and IN COAs. The template requires no installation after starting the container.

Thanks Joe, will await your including it in the main code base.

Please publish the API for providing COA from third party sites.

A nightly snapshot of the Mercurial Repo would make it easier for users to test and provide feedback easily.

Is there any PRO version of FA? Is there any intention to do so if one does not exist currently?

Please provide a link on the FA site for the Payroll plugin for FA hosted at Google:

http://code.google.com/p/fa-payroll-module/

Is there any page to show the differences between WebERP and FA?

A fourth date format like 31-Aug-2012 to be represented in the config.php as DDMMMYYYY or DDMmmYYYY or if only 8 chars are allowed then DDmmYYYY would be nice:

Some errors with form field names like TransToDate and OrdersToDate have been experienced when the following 4 files were looked into for minor changes:

pdf_report.inc
excel_report.inc
ui_view.inc
date_functions.inc

In fact the last file above was attempted to be modified in 3 places in vain with:

1.

return $day.$sep.date('M', $year.$month.$day).$sep.$year;

2.

elseif (strlen($date_) == 9)
    {
        if ($how == 3) {
            $day = substr($date_,0,2);
            $month = date('m', strtotime(substr($date_,3,3)));
            $year = substr($date_,7,4);
        } else return 0;
    }

3.

        elseif ($how == 2) // YYYYMMDD
        list($year, $month, $day) = explode($sep, $date_);
    else // $how == 3, DDMmmYYYY
        list($year, $month, $day) = explode($sep, date('Y-m-d', strtotime($date_)));

This issue has been comprehensively fixed where you can enter the nickname of the company and not the number of the company in the array (anyone can just enter numbers sequentially from 0 onwards...).

Look up:
http://mantis.frontaccounting.com/view.php?id=1768
and get the code from there.

Just provided the following:

Company Creation for externally created blank database fix:
http://mantis.frontaccounting.com/view.php?id=1767

Login Company Select box to Edit Box privacy feature fix
http://mantis.frontaccounting.com/view.php?id=1768

Contact Festus at www.GNUAcademy.org for an OpenVZ template with all the very latest Mercurial build and these fixes.

Use a point of sale like www.phppointofsale.com or it's opensource equivalent at https://sourceforge.net/projects/opensourcepos/

Here is a HOWTO to:
Enabling Repository Snapshots in Mercurial Browser at SF.net

http://galfar.vevb.net/wp/2011/enabling-repository-snapshots-in-mercurial-browser-at-sf-net/

It is very simple and will help get the latest snapshot of even just a single subfolder instead of downloading the whole archive.

5,970

(4 replies, posted in Installation)

Thanks!

Just uploaded to:
Help.CompanySetup
Help.Items
Help.ItemCategories

5,971

(4 replies, posted in Installation)

I registered to edit the FAWiki. I am able to edit text. When I try to upload a screenshot - PNG / JPG file, I am asked for a username and password again which does not seem to accept the password I logged in with. How do we obtain file upload privileges for the FAWiki which is grossly lacking in screenshots and help info at the moment?

else {
                document.forms[0].action='create_coy.php?c=u&id=" . $n . "&fn=' + document.forms[0].uploadfile.value
            }

should actually be

else {
                document.forms[0].action='create_coy.php?c=u&id=" . $n
            }

This feature update has been merged into the FA trunk today. The version number for the admin/create_coy.php is 1.13 now. Thanks Joe.

As the admpassword form field is to be posted in another company's database, the following code needs to be appended around the end of the if statement in line 141 or so in admin/create_coy.php file:

    } else {
        if ($_GET['c'] = 'u') {
            $conn = $db_connections[$id];
            if (($db = db_create_db($conn)) == 0)
            {
                display_error(_("Error connecting to Database: ") . $conn['dbname'] . _(", Please correct it"));
                $error = true;
            } else {
                db_query("UPDATE ".$conn['tbpref']."users set password = '".md5($_POST['admpassword']). "' WHERE user_id = 'admin'");
            }
        }
    }

The function db_create_db() creates a new db only if it does not exist, else merely connects to it.

Attached is the corrected file.

Refer to the lines 303-312 in admin/create_coy.php :-
        <script language='javascript'>
        function updateCompany() {
            if (document.forms[0].uploadfile.value!='' && document.forms[0].dbname.value!='') {
                document.forms[0].action='create_coy.php?c=u&ul=1&id=" . $n . "&fn=' + document.forms[0].uploadfile.value
            }
            else {
                document.forms[0].action='create_coy.php?c=u&id=" . $n . "&fn=' + document.forms[0].uploadfile.value
            }
            document.forms[0].submit()
        }

The else statement alludes to uploadfile.value when it is non-existent.