5,776 Reply by apmuthu

(2 replies, posted in Reporting)

Meanwhile just take a nice dump of the suppliers table - Adminer is quite good at it.

Go to forum: Reporting

5,777 Reply by apmuthu

(11 replies, posted in Items and Inventory)

Dimensions and Tags also help segregate transactions for split-up reports.

Go to forum: Items and Inventory

5,778 Reply by apmuthu

(17 replies, posted in Installation)

Great Janusz. Your HG Changesets 3155 and 3157 did the job.

Go to forum: Installation

5,779 Reply by apmuthu

(4 replies, posted in Installation)

You can use separate database and separate prefix for the second company as they own the physical hardware and have access to the MySQL Server itself.

In fact the new install can be on a separate domain with the newest version on the same physical server and you would need to migrate the COA with no opening balances only.

Go to forum: Installation

5,780 Reply by apmuthu

(9 replies, posted in Setup)

29.30 * 0.21 = 6.153 (Stored as 6.15)

29.30 - 6.153 = 23.147

23.147 may have been stored as 23.14 in the table
23.14 + 6.15 = 29.29 -> one possibility.

Now when preparing the report (dividing factor = 1.00 - 0.21):
23.14 / 0.79 = 29.2911 rounded off to 29.29 -> second possibility.

That is how the error comes in.

The fix should be in storing the properly rounded value in the table and in small value divisions these errors make it to the hundredths position and show up.

Anyone working in a bank that uses FA type accounting system can take all the less than 1 cent values into their account and make millions on billions of transactions!

Go to forum: Setup

5,781 Reply by apmuthu

(4 replies, posted in FA Modifications)

Refer Wiki Screenshot for Setup -> Company Setup -> Search checkboxes.

Go to forum: FA Modifications

5,782 Reply by apmuthu

(5 replies, posted in Accounts Receivable)

User Access Roles will overlap and allow one user from one school to enter details in the dimension for another school.

Go to forum: Accounts Receivable

5,783 Reply by apmuthu

(1 replies, posted in Items and Inventory)

Try federated databases - first on databases on the same server.
Or just views on the item related tables form one "main" database (read/write fror items) in the other databases (read only).

In these methods, no "synch"ing will be needed.

Go to forum: Items and Inventory

5,784 Reply by apmuthu

(17 replies, posted in Installation)

Which version are you upgrading from?
What platform / hosting service is being used?

There is a cache issue introduced in v2.3.14 when adjusting the includes/session.inc for faillog protection (not because of faillog protection) and is a known issue for certain shared hosting that relies on numerous redirects (302 error).

Refer link for causes.

Go to forum: Installation

5,785 Reply by apmuthu

(7 replies, posted in Announcements)

First of all you are using a very old update now that FA v2.3.14 has been released.

Your issue is that you need to uncheck the Search boxes in the middle of the right side in the page Setup -> Company Setup.

The screenshot is here.

Please refer the Wiki first and trawl the forum to minimize support issues.

Go to forum: Announcements

5,786 Reply by apmuthu

(2 replies, posted in Installation)

Yes this is a known issue with some shared hosting accounts especially with subdomain accounts using the redirect method.

FA v2.3.11 works in such circumstances.

The includes/session.inc file got changed to accommodate faillog and may need header session changed from private to private nocache.

Make sure that in such VPSes, the /etc/hosts file has the subdomain entry as well.

One incompatible hosting service identified is shell.gridhost.co.uk on their CentOS 5.2 VPS (read from the /etc/issue file).

If anyone finds the settings to make it work despite disabling the .htaccess file do let the users know.

Go to forum: Installation

5,787 Reply by apmuthu

(10 replies, posted in Announcements)

Attached in this post is the diff file set from FA v2.3.13 to v2.3.14 along with a single patch file as well.

The new release is equivalent to Mercurial Changeset 3153.

Kindly note that the mere extraction of this zip file is insufficient in general to perform a real update. The new config.default.php variables need to be scrutinised and appropriately inducted into the existing config.php file. Any database changes between the standard schema of the sql/en_US-new.sql and the existing database for each company must be propagated thru with any new fields being accounted for with sensible defaults. The Upgrade page in the Wiki can be updated with user experience for each version migration.

Go to forum: Announcements

5,788 Reply by apmuthu

(23 replies, posted in Wish List)

All fixes in this post have been incorporated except ed10's link request where the fix is provided here in Janusz post #18.

Go to forum: Wish List

5,789 Reply by apmuthu

(3 replies, posted in Reporting)

Is this desirable to be added in the current version?

Go to forum: Reporting

5,790 Reply by apmuthu

(1 replies, posted in Installation)

Thanks Joe, Mercurial Changeset 3143 fixed it.

Go to forum: Installation

5,791 Reply by apmuthu

(23 replies, posted in Wish List)

sales/customer_invoice.php was slated to be updated with the fix here in v2.3.14 - it appears not to have been done as yet.

Go to forum: Wish List

5,792 Reply by apmuthu

(4 replies, posted in Reporting)

Thanks Joe. Mercurial Changeset v3142 did it.

recalculate() is now a normal function in includes/current_user.inc instead of being in 2 different class files. It can be further modified to (intelligently) selectively expand only the text fields needed - possibly through an array containing boolean values in each report for allowing expansion.

Go to forum: Reporting

5,793 Reply by apmuthu

(2 replies, posted in Installation)

Thanks Joe.
For the record, Mercurial Changeset 3150 did it.

Go to forum: Installation

5,794 Topic by apmuthu

(2 replies, posted in Installation)

During an inadvertant commit in Mercurial Changeset 2297 of the file update.html the encoding got changed to iso-8859-2. Please revert to iso-8859-1 in the said file as well as in both (application and install) empty.po files.

Go to forum: Installation

5,795 Reply by apmuthu

(3 replies, posted in Reporting)

In that case, then the default page to be displayed should be Add New Quotation Form when there are no Quotations in the database - that way we need not bother about the database warning ever occurring here.

Thanks for the clarification.

Go to forum: Reporting

5,796 Topic by apmuthu

(3 replies, posted in Reporting)

In sales/includes/db/sales_order_db.inc in the function get_sales_order_header we have a few hardcoded strings:

Line 310: You have duplicate document in database

Line 317: You have missing or invalid sales document in databaseYou have missing or invalid sales document in database

In the demo company, Reports => Customers => Print Sales Quotations results in the following error:

You have missing or invalid sales document in database (type:32, number:0).

The database does not have any demo data for sales quotations - it does not degrade gracefully.

Almost all variables in reporting/inxludes/doctext.inc need to be gracefully degraded like line 40:

$this->formData['document_date'] = this->formData['ord_date'] ;

which should become

$this->formData['document_date'] = isset($this->formData['ord_date']) ? $this->formData['ord_date'] : '';

Go to forum: Reporting

5,797 Reply by apmuthu

(4 replies, posted in Reporting)

Attached is the patch file to update the reporting/repXXX.php files in synch with the unstable branch prior to the Orientation Feature induction. This will help clarify errors if any before orientation inclusion.

Go to forum: Reporting

5,798 Reply by apmuthu

(4 replies, posted in Reporting)

Analysing what and how to backport from Unstable 2.4 to Stable 2.3.13 Mer Build 3141:

Copy over reporting/includes/reporting.inc from Unstable to Stable
Others can be backported directly for orientation:
101 - 106, 114, 201-204, 301-306, 401, 501, 701, 704-710
rep 107, 110 & 113 (can backport block of logic), must exclude new FA 2.4 field while backporting
rep 108, 109, 111, 409 block of logic can be backported with / without orientation
rep 112 backport with removal of inline deprecated function (3027 mer build done in unstable) with / without orientation
rep 209 - beware that get_tax_for_items() function has changed due to new tax_algorithm field in 2 tables.
rep 210 - backport with removal of inline deprecated function get_allocations_for_remittance() (3027 mer build done in unstable) with / without orientation

rep 601 - only beware of new fa 2.4 function get_counterparty_name in includes/types.inc used instead of older function payment_person_name which is still available
rep 702 - only beware of new fa 2.4 function get_subaccount_name() in gl/includes/db/gl_db_accounts.inc used instead of older function payment_person_name


function payment_person_name from includes/types.inc used in reports 601, 702 and 704 (in 602 [copy of 601 with reconcile] and 704 in unstable as well)
function get_subaccount_name() [rep 702] and is_subledger_account() in FA 2.4 in gl/includes/db/gl_db_accounts.inc

Go to forum: Reporting

5,799 Reply by apmuthu

(9 replies, posted in Setup)

Please state the exact numbers involved in the division / multiplication like base amount and / or final amount, taxrate(21%), erroneous amount (29.29, 29.30) name, etc.
Also one navigation is given as General Ledger > Tax Inquiry and what is the other navigation for invoice?

Go to forum: Setup

5,800 Topic by apmuthu

(1 replies, posted in Installation)

Whilst the stable v2.3.x code seems to have been following the PHP 5.3 standards in some places, the Unstable v2.4 seems to be lagging - example the file:
Line 3121 reporting/includes/Workbook.php:

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

should follow the stable version and be:

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

The above is the only instance of the leftover ereg function.

Go to forum: Installation