6,126 Reply by apmuthu

(18 replies, posted in FA Modifications)

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.

Go to forum: FA Modifications

6,127 Reply by apmuthu

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

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.

Go to forum: Misc. Charts of Accounts

6,128 Reply by apmuthu

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

Go to forum: Setup

6,129 Reply by apmuthu

(8 replies, posted in Jobs wanted/offered, non-free offers)

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

Go to forum: Jobs wanted/offered, non-free offers

6,130 Reply by apmuthu

(18 replies, posted in FA Modifications)

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?

Go to forum: FA Modifications

6,131 Reply by apmuthu

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

Go to forum: Setup

6,132 Topic by apmuthu

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

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.

Go to forum: Misc. Charts of Accounts

6,133 Reply by apmuthu

(7 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,134 Reply by apmuthu

(8 replies, posted in Setup)

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

Go to forum: Setup

6,135 Topic by apmuthu

(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

Go to forum: Setup

6,136 Reply by apmuthu

(27 replies, posted in Dimensions)

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

Go to forum: Dimensions

6,137 Reply by apmuthu

(7 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,138 Reply by apmuthu

(7 replies, posted in Report Bugs here)

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?

Go to forum: Report Bugs here

6,139 Topic by apmuthu

(18 replies, posted in FA Modifications)

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_)));

Go to forum: FA Modifications

6,140 Reply by apmuthu

(3 replies, posted in FA Modifications)

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.

Go to forum: FA Modifications

6,141 Topic by apmuthu

(7 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,142 Reply by apmuthu

(5 replies, posted in Setup)

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

Go to forum: Setup

6,143 Topic by apmuthu

(0 replies, posted in Setup)

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.

Go to forum: Setup

6,144 Reply by apmuthu

(4 replies, posted in Installation)

Thanks!

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

Go to forum: Installation

6,145 Topic by apmuthu

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

Go to forum: Installation

6,146 Reply by apmuthu

(2 replies, posted in Report Bugs here)

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
            }

Go to forum: Report Bugs here

6,147 Reply by apmuthu

(2 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,148 Reply by apmuthu

(2 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,149 Topic by apmuthu

(2 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

6,150 Topic by apmuthu

(2 replies, posted in Report Bugs here)

When we login as admin into the default company and attempt to go to Setup -> Create/Update companies and choose to edit one of the non-default companies and we attempt to change that company's Administrative Password, the new password does not enter that company's database. The status of such a submission however states that the change has been successful even though it is not.

However, when we login to a specific company as admin and attempt to change the admin user's password, we are able to do so.

Go to forum: Report Bugs here