3,501 Reply by apmuthu

(10 replies, posted in Report Bugs here)

@kvvaradha: When you say you fixed it, you need to explain what you did so that the forum users can follow it. Was it a permissions issue or was the $path_to_root variable wrong at your end, etc.

Whilst deleting a fiscal year, turn on the sql_debug audit trail in config file and see what all sql statements are used. Then restore back to the pre-delete state and try out the sql statements one by one and see which statement takes a long time and what indexes are associated with the tables concerned that take time to re-index. Then place a pause like sleep(10); in the php code there so that there is sufficient time to complete the deletion/re-index process before carrying on.

Go to forum: Report Bugs here

3,502 Reply by apmuthu

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

@ gaurangs: Which form are you referring to? Why not just have 2 separate items as kits with different quantity each in a bundle?

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

3,503 Reply by apmuthu

(3 replies, posted in Accounts Payable)

You can probably either hardcode it yourself or modify the string in the .po file and then compile the .mo file and use it to suit your understanding.

Go to forum: Accounts Payable

3,504 Reply by apmuthu

(10 replies, posted in Report Bugs here)

FA 2.4 config.default.php lines 49-50:

    // Build for development purposes
    $build_version     = date("d.m.Y", filemtime("$path_to_root/CHANGELOG.txt"));

Check the value of $path_to_root at that point.

Go to forum: Report Bugs here

3,505 Reply by apmuthu

(3 replies, posted in Accounts Payable)

Probably because it is the prerogative of the Supplier to provide us the credit note that we take cognizance of in our books.

Go to forum: Accounts Payable

3,506 Reply by apmuthu

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

Modify the function that processes the login credentials. Get the second factor from an email or SMS and enter it into a session variable and then verify with the second factor server and populate a second session variable which then becomes a token of the outcome and remains persistent thereafter for the login session.

Go to forum: Modules Add-on's

3,507 Reply by apmuthu

(2 replies, posted in Setup)

Use v2.3.25+ from the GitHub master.
Choose the company in the login page.
The default company is the one from which new companies can be created.
If you did not give a password during company creation then it is assumed to be "password".
Make sure you close all instances of the browser before logging into a different company.
All super users are "admin" for all companies created anew within FA.

Go to forum: Setup

3,508 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

Turn on Audit Trail in config file. It will not be specific to your filter.

Go to forum: Banking and General Ledger

3,509 Reply by apmuthu

(5 replies, posted in Report Bugs here)

@Joe: can you replicate this issue and if so please set the permissions for Items view fields.

Go to forum: Report Bugs here

3,510 Reply by apmuthu

(1 replies, posted in Announcements)

You might want to use the MySQL tuning Wizard and think about using the InnoDB File per table option (it is enabled by default in MySQL v5.6+).

A few index tweaks for the current stable version are available.

Go to forum: Announcements

3,511 Reply by apmuthu

(2 replies, posted in Banking and General Ledger)

Thanks Joe for the v2.3 and v2.4 commits.

Go to forum: Banking and General Ledger

3,512 Reply by apmuthu

(1 replies, posted in Setup)

access/login.php

Go to forum: Setup

3,513 Topic by apmuthu

(2 replies, posted in Banking and General Ledger)

Bloomberg has changed their wrapper from span to div. Attached is the fix for FA 2.3. Kindly update both repos.

Go to forum: Banking and General Ledger

3,514 Reply by apmuthu

(2 replies, posted in Announcements)

Post Release fixes for FA v2.3.25.
Read caveats on using extensions with the new improved entropy.

Go to forum: Announcements

3,515 Reply by apmuthu

(16 replies, posted in Accounts Receivable)

Alternatively, you can send the email out to your gmail address from FA and then manipulate it in gmail and forward to who you want.

If you are using Mercury Mail in Windows XAMPP then you can configure your mail client to approve all outgoing mail before being sent.

Go to forum: Accounts Receivable

3,516 Reply by apmuthu

(3 replies, posted in Reporting)

Have a look at the Reporting Wiki Page which illustrates how to add a Signature to the Invoice and how to add extra lines to the invoice.

Go to forum: Reporting

3,517 Reply by apmuthu

(3 replies, posted in Items and Inventory)

This called Tax inclusive price of product.
Have a look at Sales Types in the Wiki.

Go to forum: Items and Inventory

3,518 Reply by apmuthu

(2 replies, posted in Setup)

Disable Strict Mode in MySQL 5.7 and beyond:

https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server
https://mattstauffer.co/blog/how-to-disable-mysql-strict-mode-on-laravel-forge-ubuntu

MySQL actually looks five different places for configuration files, so you can make the change I'm about to recommend several places. It'll look in

/etc/my.cnf,
/etc/mysql/my.cnf,
SYSCONFDIR/my.cnf,
$MYSQL_HOME/my.cnf, and
~/my.cnf.

The last one above is user-specific, and the third and fourth options rely on specifics from your environment.

In the my.cnf file, use the following:

[mysqld]
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Then restart MySQL - in Debian / Ubuntu it is:

/etc/init.d/mysql restart

Go to forum: Setup

3,519 Reply by apmuthu

(3 replies, posted in Translations)

Thanks Janusz. Fixed in this commit.

Go to forum: Translations

3,520 Reply by apmuthu

(16 replies, posted in Accounts Receivable)

First decide where you will have your pdfs to be attached and what naming convention you would use so that the "id" of the invoice is part of the file name. When creating links, the invoice number will be available to the script which can be used to construct the desired link for the file. Check out the code where the invoice is attached and add a similar line for your file.

Please note that this kind of change should be attempted by PHP programmers and is not meant for the faint of heart. Sufficient debugging will be needed as well besides checks for file presence, content and permissions need to be taken care of.

Go to forum: Accounts Receivable

3,521 Reply by apmuthu

(3 replies, posted in Reporting)

Checkout the reporting/includes/doctext.inc and reporting/includes/header2.inc files.

Go to forum: Reporting

3,522 Reply by apmuthu

(3 replies, posted in Wish List)

Create a reporting folder in your company/# folder and place your modified repXXX.php files there. They will override the ones in the one in the webroot. This way your will not get overwritten on any update though you will have to manually update your mods for any enhancements changes in the core.

Make the different "Company Names" as part of the "Branch Address".

Go to forum: Wish List

3,523 Reply by apmuthu

(5 replies, posted in Installation)

If it is just an issue of password, then reset it to "password" by using phpmyadmin or sqlyog or any other mysql client (even CLI) and execute the command for your company (assumed 0 here):

UPDATE 0_users SET 
  `password`=MD5("password")
, inactive=0
, role_id=2
, startup_tab='orders' 
WHERE user_id='admin';

Go to forum: Installation

3,524 Reply by apmuthu

(3 replies, posted in Wish List)

Make a list of reports in FA where VAT is used that you would like to get rid of and see if a mere translated string can be hardcoded (as possibly blank) or removed from it. All such report files are in reporting/repXXX.php though the header files reporting/includes/*.inc/php.

It is indeed quixotic that the default CoAs distributed with FA are for the US whilst the EU/Asian VAT/GST seems to be in them!

Go to forum: Wish List

3,525 Reply by apmuthu

(2 replies, posted in Setup)

When posting information on an error you should post the choices made in the preceeding form. Assuming you chose the en_US-new.sql Chart of Accounts in the previous form, line 42 in sql/en_US-new.sql is:

  `tran_date` date NOT NULL default '0000-00-00',

Some recent versions of MySQL do not allow '0000-00-00' as a valid date field value. Try removing all such constructs (default '0000-00-00') from the said sql file and re-try the installation after emptying the db. Alternatively set strict mode off in MySQL.

The following links provide further info:
https://dev.mysql.com/doc/refman/5.6/en/datetime.html
http://stackoverflow.com/questions/25349126/how-can-i-set-the-default-value-of-a-field-as-0000-00-00-000000
http://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime

The error is because of the sql mode which can be strict mode as per latest MYSQL 5.7 documentation

MySQL Documentation 5.7 says:

    Strict mode affects whether the server permits '0000-00-00' as a valid date: If strict mode is not enabled, '0000-00-00' is permitted and inserts produce no warning. If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.

To Check MYSQL mode

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session

There are a total of 31 places in the en_US-new.sql file where the said construct is there.

There are many places in the php codebase where the equivalent of the following constructs are available:

if ($date == 0) $date = '0000-00-00';

and

        $sql .= " tran_date > IF(ctype>0 AND ctype<".CL_INCOME.", '0000-00-00', '$from_date') AND";

Hence it is better to turn the strict mode off in the mysql and not tamper with the Charts sql.

Go to forum: Setup