151 Reply by apmuthu

(17 replies, posted in Reporting)

@joe: Is this essential to include in the core FA. If so clean up the kludge herein which was just a Quick'n Dirty fix.

Go to forum: Reporting

152 Reply by apmuthu

(17 replies, posted in Reporting)

Attached is modified version of reporting/rep201.php file to suit your needs. You may do the same for reporting/rep201.php.

Such modified files should be placed in the company/#/reporting folder so as to be applicable as a substitute for the default one in the reporting folder.

Go to forum: Reporting

153 Reply by apmuthu

(2 replies, posted in Installation)

Have a separate application for managing the truck transaction data and have a middleware to synch with FA tables when at the HQ. Issues such as change in data that was already synched will render the HQ server data as stale even though newer data are in synch.

Go to forum: Installation

154 Reply by apmuthu

(11 replies, posted in FA Modifications)

Let us freeze the PHP version for this FA version.
People should not keep updating PHP version frequently.

Go to forum: FA Modifications

155 Reply by apmuthu

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

If you are referring to Notrinos FrontHRM module, visit
  https://frontaccounting.com/punbb/viewtopic.php?id=9773
Check for newer version.

Go to forum: Modules/Add-on's

156 Reply by apmuthu

(2 replies, posted in Report Bugs here)

Check if there are any overdue items.

Go to forum: Report Bugs here

157 Reply by apmuthu

(5 replies, posted in Installation)

Navigate to Setup => Company Preferences and in the left side bottom check if the DB version is:
Database Scheme Version    2.4.1

This setting comes from the #_sys_prefs table "value: field for "name" field = version_id.

Then check your database schema and settings / constants in the your database with the schema sql of the Chart of Accounts used and make the necessary changes to match the version you used. All CoAs are for the install are in the sql folder. Also see if the version numbers match the ones in the "installed_extensions.php file if they were added from withing the UI.

After you have updated the core FA files, navigate to Setup => Software Upgrade and see if all is okay.

Go to forum: Installation

158 Reply by apmuthu

(17 replies, posted in Reporting)

Did you mean:
https://frontaccounting.com/fawiki/uploads/Help/Rep201_SupBalRpt.png
https://frontaccounting.com/fawiki/uploads/Help/Rep101_CustomerBalances.png

Go to forum: Reporting

159 Reply by apmuthu

(1 replies, posted in Setup)

https://www.tax-rates.org/taxtables/sales-tax-by-state

Go to forum: Setup

160 Reply by apmuthu

(5 replies, posted in Installation)

check version.php file.

Go to forum: Installation

161 Reply by apmuthu

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

What are the demo limitations?

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

162 Reply by apmuthu

(38 replies, posted in Reporting)

Some have success with PHP 8.0 and many have problems with later PHP versions.

Go to forum: Reporting

163 Reply by apmuthu

(38 replies, posted in Reporting)

Some have success with PHP 8.0 and many have problems with later PHP versions.

Go to forum: Reporting

164 Reply by apmuthu

(11 replies, posted in FA Modifications)

A note page in the wiki would be good to know the extent of PHP version compatibility for each release.

Go to forum: FA Modifications

165 Reply by apmuthu

(1 replies, posted in Reporting)

Generally only the repXXX.php files can be so placed. @joe - can the above be done too?

Go to forum: Reporting

166 Reply by apmuthu

(5 replies, posted in Installation)

A cronjob is easily done in linux. Contact your hosting admin.

Go to forum: Installation

167 Reply by apmuthu

(17 replies, posted in Reporting)

Which Report are you referring to?

Go to forum: Reporting

168 Reply by apmuthu

(2 replies, posted in Wish List)

Make a multi lingual string for the description with a utf8 field type

Go to forum: Wish List

169 Reply by apmuthu

(3 replies, posted in Reporting)

Why don't you fork the FA in GitHub and make a folder with changed files after a commit to import the original into the changes folder. That way it will be able to track changes whenever a changed file is updated in the core. Have a look at my fork.

Go to forum: Reporting

170 Reply by apmuthu

(2 replies, posted in Setup)

Possible write permission error in the web server path.

Go to forum: Setup

171 Reply by apmuthu

(3 replies, posted in Accounts Receivable)

It doesn't appear to have been pushed into the GitHub repo yet here. but is available in the SF.net repo. Hope the GitHub repo gets synched correctly in time.

Go to forum: Accounts Receivable

172 Reply by apmuthu

(2 replies, posted in Report Bugs here)

Unofficial FA 2.4.x extensions repo

Go to forum: Report Bugs here

173 Reply by apmuthu

(3 replies, posted in Wish List)

Please make customisation to current version / master code base listing diff files. Use WinMerge for it as you are using windows (CRLF in your files).

Go to forum: Wish List

174 Reply by apmuthu

(5 replies, posted in Installation)

Can re-validate session when it expires until logout - no need for db tables and other customisations. A cronjob to revalidate all sessions from time to time is also another option without FA code change.

Go to forum: Installation

175 Reply by apmuthu

(7 replies, posted in Report Bugs here)

This occurs due to lines 28-32 in includes/db/audit_trail_db.inc:

    $sql = "UPDATE ".TB_PREF."audit_trail audit LEFT JOIN ".TB_PREF."fiscal_year year ON year.begin<='$date' AND year.end>='$date'
        SET audit.gl_seq = IF(audit.id=".db_insert_id().", 0, NULL),"
        ."audit.fiscal_year=year.id"
        . " WHERE type=".db_escape($trans_type)." AND trans_no="
        . db_escape($trans_no);

If there is no valid matching value of the field fiscal_year as happens when no records for fiscal year in question, this will error out.

Go to forum: Report Bugs here