5,976 Reply by apmuthu

(7 replies, posted in Announcements)

Thanks Janusz, the OpenVZ template is now in synch with the FA codebase except for the db fix in Mantis Issue 1758.

Go to forum: Announcements

5,977 Reply by apmuthu

(7 replies, posted in Announcements)

Yes. A possible mailout from the Forum / Wiki to all users about a new release may quicken adoption of latest codebase. If the GitHub model is chosen, then we can avoid releases itself and have it downloadable therefrom - even the Mercurial does have snapshots download possible but is yet to be enabled in FA's Mercurial.

Please look into subsequent additions to Open Bug 1785 - I am having to manually update code each time - the negative values are not so much the issue. The optional avoidance of the faillog is nice besides the ability to take values after a delayed include.

Also please look into whether Fix in Open Bug 1858 can be accepted.

Go to forum: Announcements

5,978 Topic by apmuthu

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

Analysing the SourceForge Download statistics yielded a nice insight into how many downloads occur within 2 days of a new release.

Approximately 300 downloads occur within 2 days of a new release at SourceForge.

* General Users download from SF.
* Developers take it from Mercurial.
* Bleeding edge non developer users take it from snapshots forum post.
* Hosting Panel users get only what their bundles offer (cPanel Fantastico, SimpleScripts, TurnkeyLinux, Webuzo, etc).
* Clients get their code from Consultants' archives

GeoIP based Country Stats indicate that
* USA 14%,
* Indonesia 12%,
* India 9%,
* Netherlands 6%
account for a sizeable share of 41% of downloads in 2012.

Other countries above 2% each are Pakistan, Malaysia and UK. Together, the 7 countries account for 49% of downloads in 2012.

This is certainly not representative of the usage distribution, but rather the segment that actively takes it from SF immediately when released. Weekends, holidays, individual pre-occupation and other geographical differences have not been taken into account.

On the complementary side, there is plenty of scope to usher in fresh adoption in low download countries - business potential!

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

5,979 Reply by apmuthu

(7 replies, posted in Announcements)

Changes upto 2012-11-14 / Mercurial 3099 since release of FA v2.3.12

FA Branch: default

  • Prevent 'Page expired' messages when 'Back' link is used after login.

  • Cleanup in includes/curent_user.inc and includes/session.inc

  • Fixed small bug in mail class, added text/hmtl mime type.

  • Dimensions not utilized in Direct Invoice/Delivery

  • Sales quotation and Sales order should not require sufficient stock.

  • Fixed confirmation on ajax reloaded buttons (small fix for Gecko like browsers).

  • 0001879,0001880: Fixes in htaccess constraints, restricting System Diagnostic view to admin (ApMuthu)

  • Fixed error messages on Sales Groups, updated gettext template.

  • Improved error checking during extension packages installation.

  • Fixed error message in recurrent invoices.

  • Replaced the transaction list in attachments with a pager and made the sorting descent.

  • Filter for non-zero values in Bank Statement Report

  • Removed commented deprecated Session_register().

  • Db error in invoice.ui.inc for certain MySql setup/releases.

  • Db error in po_entry_items.php was already fixed. Look at the line below.

  • Cannot insert a supplier transaction record in Direct Supplier Invoice (certain MySql versions and setup).

  • Date format helper complete.

  • Purchase order/Direct GRN/Direct Invoice showed inactive items in item list.

  • Small fix and rerun of inserts.js.

  • Fixed date_fix to act like before. day and day-month entrance only.

  • Bug in function is_date when implementing new date formats.

  • Moved declaration of short monthnames from config.default.php. Too early for translations.

  • Minor improvement to add_days/months/years for the new dateformats.

  • 0001806: Date problems fixed and new date formats MmmDDYYYY, DDMmmYYYY and YYYYMmmDD implemented.

  • Fixed void_stock_move() to avoid sparse lines in Inventory Items Movements register after DN edition.

  • Having memo or comment displayed on bank_inquiry.php.

  • Improved headers in printing Purchase Orders.

  • Moved access functions from renderer to current_user. They were cluttered into all themes.

  • Invalid input description in account groups for account class parameter.

  • Cleanup in check_faillog().

  • 0001792: BLOOMBERG added to Exchange Rate Providers and config and fixed

Go to forum: Announcements

5,980 Reply by apmuthu

(5 replies, posted in Reporting)

A comment in the code may be useful if it is one off.

All Booleans may have to be changed to true/false otherwise, to avoid confusion.

Maybe an option to show decimals in the form requesting the report may be useful, the number of decimals being taken from the preferences.

Go to forum: Reporting

5,981 Reply by apmuthu

(9 replies, posted in Accounts Receivable)

Wikiied it.

Go to forum: Accounts Receivable

5,982 Reply by apmuthu

(1 replies, posted in FA Modifications)

Ram Deshmukh can get support from the Wiki.

Line 25 in config.php can be altered to be your TimeZone (Asia/Kolkata) or it can be set in the server's php.ini.

The logged in user cannot set his time zone as is available in many CMSes since all (Front)Accounting package users should see the same date and time in all transactions and reports.

Go to forum: FA Modifications

5,983 Reply by apmuthu

(25 replies, posted in Items and Inventory)

speed => rate - translation quirk!

Has this been fixed in Mercurial Changeset 3094?

Go to forum: Items and Inventory

5,984 Reply by apmuthu

(4 replies, posted in Report Bugs here)

In a similar vein (as changeset 3090), line 30 of sales/manage/sales_groups.php:

        display_error(_("The area description cannot be empty."));

should be:

        display_error(_("The sales group description cannot be empty."));

The patch file has been attached to the first post in this topic.

Go to forum: Report Bugs here

5,985 Topic by apmuthu

(0 replies, posted in Setup)

Normal Report Printing as PDF/Printer output is in TCPDF_4.0.027_PHP4 (2008-09-19) format since /reporting/includes/tcpdf.php is quite old.

$graphics variable gets it's value from the report form request page and if set, chooses to include the file reporting/includes/class.graphic.inc which is the only file that references the name of the only font file reporting/fonts/LiberationSans-Regular.ttf bundled by default in FA. The said file is slightly old and the latest file is available from the debian squeeze package ttf-liberation.

The debian squeeze package ttf-liberation all 1.05.2.20091019-4squeeze1 has the file LiberationSans-Regular.ttf dated 2011-02-16 as opposed to the current one bundled in FA entered on 2010-11-15.

Have attached the latest font file.

The names of the font files have been hard coded in reporting/includes/class.graphic.inc in the function graph().

The file reporting/includes/class.graphic.inc is included only in the following files and only if $graphics is set:

reporting/rep102.php - Aged Customer Balances
reporting/rep202.php - Ages Supplier Analysis
reporting/rep706.php - Balance Sheet
reporting/rep707.php - Profit and Loss Statement

It would be nice to have both the UTF-8 and regular font names to be set as config variables in the config.php file.

If UTF-8 is being used, then the FreeSans.ttf file must be downloaded and placed in the reporting/fonts/ folder.

In debian, the following can be done:

## The older font Vera.ttf is in debian pkg ttf-bitstream-vera
apt-get install ttf-freefont ttf-liberation

## The webroot
cd /var/www/frontac/reporting/fonts

## Remove file bundled in FA
rm -f LiberationSans-Regular.ttf

## Symlink the fonts
ln -s /usr/share/fonts/truetype/ttf-liberation/*.ttf .
ln -s /usr/share/fonts/truetype/freefont/*.ttf .
ln -s /usr/share/fonts/truetype/ttf-bitstream-vera/*.ttf .
chown -h www-data:www-data *.ttf

Go to forum: Setup

5,986 Topic by apmuthu

(0 replies, posted in Report Bugs here)

Setup -> System Diagnostics -> Not allowed for System Administrator for non 0 (non default) company.

It should not show up (must be greyed out) in a non default (non zero company) menu?

Line 62 of applications/setup.php:

    "admin/system_diagnostics.php?", 'SA_OPEN', MENU_SYSTEM);

should be:

    "admin/system_diagnostics.php?", 'SA_SOFTWAREUPGRADE', MENU_SYSTEM);

Filed Bug 1879.

Go to forum: Report Bugs here

5,987 Reply by apmuthu

(5 replies, posted in Wish List)

It is Fuel and not Feul.
The first menu entry has two keyboard shortcuts : &.

Go to forum: Wish List

5,988 Reply by apmuthu

(5 replies, posted in Accounts Receivable)

Banking and General Ledger -> GL Inquiry -> Choose Account -> Choose Period -> Show

You will see the Ledger Folio of the Account chosen and can see the details of the Outstanding balance.

Go to forum: Accounts Receivable

5,989 Reply by apmuthu

(2 replies, posted in FA Modifications)

We may need a hook after all the login fields and before the submit button. This way we can include the Securimage CAPTCHA as an extension.

Go to forum: FA Modifications

5,990 Reply by apmuthu

(4 replies, posted in Report Bugs here)

Normally it would not be a problem for me, as I use only the English language. In the case of changeset 3090, it s a replacement of a translate string - that has to be uniformly carried over to all affected files and the empty.po as well.

In the case of 3091, the new strings can come in during an FA release - if it was done at once, then those using non-English languages can also partake of debugging - we need as many eyeballs as possible on the code to get it up to speed. It will also help those translators in getting the strings translated well before the FA release.

Otherwise, such translate string changes should be withheld till the FA release whence it would update the empty.po as well.

A policy on this score would augur well when more than the current couple of committers comes to pass.

Go to forum: Report Bugs here

5,991 Reply by apmuthu

(7 replies, posted in Banking and General Ledger)

Contact the consultants in the Wiki for custom interface scripts.

Go to forum: Banking and General Ledger

5,992 Reply by apmuthu

(3 replies, posted in Items and Inventory)

What is the other software and what is the sample output format of your sales that you wish to import? Contact the consultants in the Wiki for any custom interface scripts.

Go to forum: Items and Inventory

5,993 Reply by apmuthu

(5 replies, posted in Accounts Receivable)

See the GL folio for that customer

Go to forum: Accounts Receivable

5,994 Reply by apmuthu

(10 replies, posted in Wish List)

Application agnostic CSV import would be nice - templates for each Application to import from.

Go to forum: Wish List

5,995 Reply by apmuthu

(1 replies, posted in Setup)

Please refer Wiki page at:
https://frontaccounting.com/fawiki/index.php?n=Main.Config
for all config variables and their possibilities.

Go to forum: Setup

5,996 Topic by apmuthu

(4 replies, posted in Report Bugs here)

A translate string change has been done in sales/manage/recurrent_invoices.php in Mercurial Changeset 3090.

Whenever a translate string change is done, an inclusion and / or substitution in the lang/new_language_template/LC_MESSAGES/empty.po file should be done and all the files that refer to the original string need to be checked for similar substitution.

In this case line 30 of sales/manage/sales_groups.php needs to have a different string but sales/manage/sales_areas.php should remain unchanged.

Also line 13124 in lang/new_language_template/LC_MESSAGES/empty.po needs to be suitably altered.


Changeset 3091 introduces 2 new strings not yet present in the empty.po file:

Cannot download repo index file.
and
Cannot download '%s' file.

Go to forum: Report Bugs here

5,997 Reply by apmuthu

(2 replies, posted in Reporting)

Thanks Joe, your Mercurial changeset 3088 does it.

Go to forum: Reporting

5,998 Reply by apmuthu

(2 replies, posted in Setup)

Lookup Fiscal Years in the Wiki.

Go to forum: Setup

5,999 Reply by apmuthu

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

Check the First Steps in the Wiki.

What format is your existing data in? CSV, Excel, DBF, Oracle, MSSQL, MS Access MDB, etc.,.

Using CSV files and phpMyAdmin, you should be able to get the data into the relevant tables.

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

6,000 Reply by apmuthu

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

If the intention is to keep the changes private, then, it is better to create a separate table for your new fields with a 1:1 relation to the invoice table and keep your changes as an extension. That way, when the base code changes, your extension functionality will be retaianed and extra table(s) fields will not get erased.

Submitting the changes back to the code base is advisable to avoid re-jig of functional code / table(s) at each upgrade.

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