5,801 Reply by apmuthu

(1 replies, posted in Accounts Payable)

Create a new Currency called Coupon (CPN) and set the exchange rate!

Go to forum: Accounts Payable

5,802 Reply by apmuthu

(2 replies, posted in Setup)

An Access role for the Customer can be adjusted if necessary and a user created and assigned the said role. Placing an order but not being able to edit the order after it has been delivered / invoiced is the need that must be ascertained of role's functionality before trusting it.

Go to forum: Setup

5,803 Reply by apmuthu

(3 replies, posted in Reporting)

Thanks Joe, it would have taken me quite a while fathoming the logic and code hierarchy to set this one right. The fix has come extremely fast!

Go to forum: Reporting

5,804 Reply by apmuthu

(15 replies, posted in Setup)

There is no need for such code at all in general. The packing slip will suffice - only the difference in title exists.

Maybe a title such as "Packing Slip / Delivery Order" instead of just "Packing Slip" is what MacPhotoBiker desired.

Go to forum: Setup

5,805 Reply by apmuthu

(6 replies, posted in Announcements)

Please refer the Wiki page.

Go to forum: Announcements

5,806 Topic by apmuthu

(3 replies, posted in Reporting)

Refer FA Bug 1902.

Only the Pie and Donut do not print correctly.

Server - Apache, PHP 5.3.3.7 on Debian 6.0.6
Client - WinXP
Browser - IE 8 / FF 16.0.2

Any Reporting Menu -> BS and GL -> Balance Sheet -> Graphics -> Select each Graphic in turn.

The attachment contains the graphics screenshots for each graphic choice for the same data.

Go to forum: Reporting

5,807 Reply by apmuthu

(7 replies, posted in Wish List)

Thanks carmelr, changed it in the Wiki as:

ALTER TABLE `0_sys_prefs` CHANGE `value` `value` TEXT NULL;

The code was taken from SQLyog's standard history output.

Go to forum: Wish List

5,808 Reply by apmuthu

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

If the errors have to do with PHP v5.3 in the PDF generation then Mercurial ChangeSet 3107  fixes it. This fix is after the release of v2.3.13.

Go to forum: Modules Add-on's

5,809 Reply by apmuthu

(2 replies, posted in Reporting)

Thanks Janusz. That was fast.

Hope all the strings are in empty.po - there are many references to the string "#" - lines 211 to 244. It is probably a substitute for "Sl.No." - Serial Number - in column headings in some or all the files listed.

The v2.4 alpha needs to get synched with the current default version.

Go to forum: Reporting

5,810 Reply by apmuthu

(7 replies, posted in Wish List)

Wikiied it.

Go to forum: Wish List

5,811 Reply by apmuthu

(15 replies, posted in Setup)

I was addressing the temp fix by twitty1437.

The Packing Slip does fine.

Looking up the code for this issue enlightened me on the report code format that needs to be Wikied.

Go to forum: Setup

5,812 Topic by apmuthu

(2 replies, posted in Reporting)

Line 3121 in reporting/includes/Workbook.php

        if (ereg("^\"[^\"]{0,255}\"$", $this->_current_token)) {

may need to be changed to preg_match for PHP 5.3 compatibility.

Reference

Go to forum: Reporting

5,813 Reply by apmuthu

(15 replies, posted in Setup)

Can have an option in the report request form to print delivery note without prices.

Also may need to blank out the $DisplayDiscount as well.

Instead of value being 0.00, it can be blank and skip the computations it uses.

Go to forum: Setup

5,814 Reply by apmuthu

(10 replies, posted in Accounts Payable)

Could be a cache / session issue. Whenever any config setting / preference is changed it is advisable to clear out the cache and login into a new session.

Also, if any js setting changes (like date format, etc), empty out the company/X/js/*.js files where X is the company number.

Go to forum: Accounts Payable

5,815 Reply by apmuthu

(6 replies, posted in Announcements)

There are 50 altered files from v2.3.12 to v2.3.13 which are attached in this post.

There are no database changes keeping with policy on minor release versions.

There are a few new and / or expanded options in config.default.php that may need to be added to the existing config.php for those upgrading. Backward compatibility has been ensured even if not done, but to leverage new / expanded functionality, it is advisable to include them.

This release is Mercurial Changeset 3106 of the current default branch.

Go to forum: Announcements

5,816 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,817 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,818 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,819 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,820 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,821 Reply by apmuthu

(9 replies, posted in Accounts Receivable)

Wikiied it.

Go to forum: Accounts Receivable

5,822 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,823 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,824 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,825 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