5,951 Reply by apmuthu

(7 replies, posted in Reporting)

Yes I figured that out and filed Bug 1906 since the prices_dec field in the #_users table was not being respected for displaying the Unit Cost in the Inventory Valuation Report (rep301.php) as seen from the attachement in the first post in this topic for one item that has 10 decimals in it's Unit Cost.

Go to forum: Reporting

5,952 Reply by apmuthu

(7 replies, posted in Reporting)

Attempting to fix includes/current_user.inc by replacing Line 310:

function price_decimal_format($number, &$dec)

with

function price_decimal_format($number, $dec)

by omitting the pass by reference, the Unit Cost column now has no decimals.

Even any forced value of $dec in Line 312 does not provide any decimals at all in the above attempted fix.

Go to forum: Reporting

5,953 Reply by apmuthu

(18 replies, posted in Setup)

C.po

What happened on browser?

Go to forum: Setup

5,954 Topic by apmuthu

(7 replies, posted in Reporting)

FA v2.3.13 Mer 3109

File: reporting/rep301.php lines 148 to 158 place the individual detail entries for the Inventory Valuation Report. The decimal formatting is not respected as the deprecated 

&$dec

is used.

Lines 310 - 312 of includes/current_user.inc:

function price_decimal_format($number, &$dec)
{
    $dec = user_price_dec();

clearly do not take in the $dec from the function parameter.

This results in the kind of multi-decimal output in the report snapshot attached.

Go to forum: Reporting

5,955 Reply by apmuthu

(6 replies, posted in Setup)

Check the SQL schema diffs between before and after backup/restore

Go to forum: Setup

5,956 Reply by apmuthu

(18 replies, posted in Setup)

lang\new_language_template\LC_MESSAGES\empty.po
needs to be copied to
lang\C\LC_MESSAGES\C.po

Beware of case sensitivity and all paths are relative to the FA folder in the webroot.

This is probably specific to Win7 installs.

Go to forum: Setup

5,957 Reply by apmuthu

(18 replies, posted in Setup)

Copy over the empty.po as C.po.
Create a faillog.php file in the webroot.

It is most certainly a permissions issue on the folders.

Which versions of XAMPP / Uniform server are you using?

Go to forum: Setup

5,958 Reply by apmuthu

(5 replies, posted in Setup)

Refer Forum Post for both the changed file sets (v2.3.12 to v2.3.13 and from v2.3.13 to Mercurial 3109) and overwrite your existing files.

There are no db changes.

Just check the difference between your config.default.php and your config.php file for newer options and update config.php accordingly. Use WinMerge2 for the job if you're on Windows.

Go to forum: Setup

5,959 Reply by apmuthu

(6 replies, posted in Announcements)

Since the release of FA v2.3.13, a few fixes have been made especially those that deal with module installation requiring sql updates. Attached is the Mercurial Build 3131.

Go to forum: Announcements

5,960 Reply by apmuthu

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

Weight can be a unit of the item and it will be shown in the invoice if the price of the item is based on the Weight then it would appear in the Quantity column.

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

5,961 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,962 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,963 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,964 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,965 Reply by apmuthu

(6 replies, posted in Announcements)

Please refer the Wiki page.

Go to forum: Announcements

5,966 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,967 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,968 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,969 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,970 Reply by apmuthu

(7 replies, posted in Wish List)

Wikiied it.

Go to forum: Wish List

5,971 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,972 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,973 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,974 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,975 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