6,001 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

6,002 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

6,003 Reply by apmuthu

(9 replies, posted in Accounts Receivable)

Wikiied it.

Go to forum: Accounts Receivable

6,004 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

6,005 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

6,006 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

6,007 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

6,008 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

6,009 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

6,010 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

6,011 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

6,012 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

6,013 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

6,014 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

6,015 Reply by apmuthu

(5 replies, posted in Accounts Receivable)

See the GL folio for that customer

Go to forum: Accounts Receivable

6,016 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

6,017 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

6,018 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

6,019 Reply by apmuthu

(2 replies, posted in Reporting)

Thanks Joe, your Mercurial changeset 3088 does it.

Go to forum: Reporting

6,020 Reply by apmuthu

(2 replies, posted in Setup)

Lookup Fiscal Years in the Wiki.

Go to forum: Setup

6,021 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,022 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

6,023 Reply by apmuthu

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

You may want to post in the Wish List and submit changes / additions to be included in the FA code base or as an extension. That way you can be sure that it would be part of fututre releases and not have to re-jig your changed code each time. Maintaining several code bases for the same project and attempting to patch them at each change is time consuming effort that may not be desirable in the long run....

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

6,024 Reply by apmuthu

(26 replies, posted in Items and Inventory)

If there are many lines (yes the order of the lines would matter and a form field in each line would be needed which will take care of it), then we can apportion amounts in any way we choose like loading costs to larger value items or to rounded costs, etc., and possibly with some items not having any shipping costs at all (enter 0 value).

The "N-1" approach was to alleviate the need to manually compute the balance if the total was entered and only one line had the new field blank.

Go to forum: Items and Inventory

6,025 Reply by apmuthu

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

Thanks Andres for starting out on PUT....

It would be useful to put in the Wiki Page URL in the README file in the GitHub so that users can partake of the updated Wiki.

https://frontaccounting.com/fawiki/index.php?n=Devel.SimpleAPIModule

Go to forum: Modules Add-on's