5,476

(7 replies, posted in Reporting)

Provided backlink to this post in the Wiki.

5,477

(12 replies, posted in Announcements)

Thanks Janusz. The patch set has been updated as well.

Please check if this issue has been sorted out using the latest patch.

All Chart of Accounts have the same db schema (with possible collation difference but basically UTF-8). Country specific language used will be available in the Language Extensions. Country and business specific COAs will have to be customized but Country generic COAs are available from within the GUI (on linux, locale for the specific country may have to be installed / activated as well). The sql file for each COA is available in the webroot's sql folder where others may be uploaded manually as well.

Create your own COA starting from one of the existing ones like the default sql/en_US-new.sql.

FA is made to be as simple as possible with quick support from the community here in the forum and distilled in the Wiki - even so, it might be intimidating to the uninitiated whence commercial support is available as well.

Joe, kindly change this in code to show it when $contact['name2'] is not empty. Possibly with a config variable if needed.

Would Banking and General Ledger ->  Quick Entries suffice?

5,482

(1 replies, posted in FA Modifications)

The same goes for a FA wiki menu entry in the sidebar.

5,483

(3 replies, posted in Report Bugs here)

Joe, possibly a boolean parameter for allowing zero value price to be listed (Sales Price Listing Report - reporting/rep104.php) would be in order here. Another parameter to omit price would make for the inventory and service list.

5,484

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

Install the en_IN language extension.
Install any Chart of Accounts (English Indian COA - New.) and modify it to suit your needs.

Refer documentation for the extension.

Has this been done now?

5,487

(3 replies, posted in Setup)

Please update the wiki FAQs with these answers.

GAAP for each country (Canada, France, UK, US), IFRS and other reporting standards are just a matter of reports being possibly different with making sure FA having the least count of info available in its' db.

Line 118 of gl/includes/db/gl_db_trans.inc
and
line 93 of gl/includes/db/gl_db_bank_trans.inc
have the said phrase: AND ISNULL(v.date_)

Any corrections needed?

Can be a simple database collation issue to a missing Apache config directive.....

5,490

(12 replies, posted in Announcements)

Since there were some glitches in the published FA v2.3.17, taking care of the new variables in the config.default.php, with no db changes needed, a FA v2.3.16 can be upgraded to the latest FA v2.3.17 with Git fixes till date updating the changed files alone.

Further changes done.

5,492

(7 replies, posted in Reporting)

Clear browser cache and try again.

These can possibly be set up serverwide in the /etc/mysql/my.cnf file. It could also be a collation difference between the old mysql server and the new one for the character fields.

5,494

(5 replies, posted in Translations)

Available here.

Thanks. Wiki-ed it.

Wiki-ed it.

For commercial support contact any FA partner.

5,498

(5 replies, posted in Report Bugs here)

The file is sales/inquiry/sales_orders_view.php and the line 106:

            && date1_greater_date2(Today(), sql2date($row['ord_date']))

should be:

            && date1_greater_date2(Today(), sql2date($row['delivery_date']))

Any reason why this has not been corrected in the Git Repo now?

5,499

(7 replies, posted in Reporting)

To clarify for end users, the change has to be made in reporting/includes/class.pdf.inc by replacing lines 156-162:

                switch ($this->l['a_meta_language'])
                {
                    case "ar_EG" :     $fontname = "ae_tholoth";     break;
                    case "zh_CN" :     $fontname = "gbsn00lp";     break;
                    case "zh_TW" :     $fontname = "chinese_traditional_cid0";     break;
                    default :          $fontname = "dejavu";         break;
                }

to

                switch ($this->l['a_meta_language'])
                {
                    case "ar_EG" :     $fontname = "ae_tholoth";     break;
                    case "zh_CN" :     $fontname = "gbsn00lp";     break;
                    case "zh_TW" :     $fontname = "chinese_traditional_cid0";     break;
                    default :          $fontname = "chinese_traditional_cid0";         break;
                }

Is this what you did?

Further changes done.

Last Git commit here.