4,001 Topic by apmuthu

(0 replies, posted in Misc. Charts of Accounts)

The latest FA 2.4 beta snapshot of the en_US-new.sql and en_US-demo.sql files have been cleaned up and made comparable to enable the creation of other CoAs based on them for ease of comparison using tools like WinMerge.

The patch files and changed files are attached herein.

Some important diffs:

en_US-new.sql  - 0_grn_batch => `rate` double NULL default '1',
en_US-demo.sql - 0_grn_batch => `rate` double default '1',

The latter also has an initial statement:
SET NAMES latin1;

The sys_prefs table entries differences in the latter are:

name          category    type    length    value

coy_logo     setup.company    varchar    100    logo_frontaccounting.jpg
coy_name     setup.company    varchar    60    Training Co
email        setup.company    varchar    100    delta@delta.com
gst_no       setup.company    varchar    25    33445566

Go to forum: Misc. Charts of Accounts

4,002 Reply by apmuthu

(9 replies, posted in Banking and General Ledger)

Try using the FA 2.3.24+ snapshot as it has some issues fixed since the stable release? If you still have issues, PM me with remote access details.

Go to forum: Banking and General Ledger

4,003 Topic by apmuthu

(0 replies, posted in Announcements)

FA Forum Users with > 5 Posts till date have been counted by the year they joined and plotted and attached herein.

The recent decline in posts can either be construed as

the project has now matured into needing less assistance for newbies

  or

that interest is being postponed as FA 2.4 has yet to be released.

Go to forum: Announcements

4,004 Reply by apmuthu

(5 replies, posted in Report Bugs here)

Wikied it.

Go to forum: Report Bugs here

4,005 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Thanks Janusz for the clarification. Wikied it.

Go to forum: Report Bugs here

4,006 Reply by apmuthu

(48 replies, posted in Setup)

Screenshots of FA 2.4 Beta - Install, Usage and Extensions available.

FA v2.4 beta can be installed after incorporating the fix detailed in this post.

sys_types and movement_types tables are still present in en_US-demo.sql while being absent in en_US-new.sql - not used in FA 2.4.

journal, reflines and wo_costing are the new tables introduced in FA v2.4.

If you have installed the en_US-demo.sql, then update the currency symbols with:

UPDATE `0_currencies` SET `curr_symbol`='£' WHERE `curr_abrev`='GBP'; 
UPDATE `0_currencies` SET `curr_symbol`='€' WHERE `curr_abrev`='EUR';

The demo data has been pruned and computer images (items) have been replaced with the more contemporary cell phone images.

PDFs render well in windows without any cludge fixes anymore.

rep709.php fix in FA v2.3 not ported to FA 2.4 as yet.

demouser is no longer in the en_US-demo.sql

The $src_version variable is now "2.4 beta" and is different from the $db_version which is "2.4.0" in version.php.


Anyone using it in production?

Go to forum: Setup

4,007 Topic by apmuthu

(1 replies, posted in Installation)

Attempting to install FA v2.4 (latest current unstable master) will result in the following error:

Call to undefined function cache_invalidate() in D:\WebServers\XAMPP\htdocs\fa24\admin\db\maintenance_db.inc on line 248

.

Have informed the devs a few days ago but the fix has not been incorporated yet.

During installation, after filling in the db parameters, on submission, there is an error due to recent inclusion of the function cache_invalidate() in FA 2.4's includes/session.inc, without including it in the install/isession.inc file.

The fix is to append the following snippet of code to install/isession.inc:

/*
 Ensure file is re-read on next request if php caching is active
*/
function cache_invalidate($filename)
{
 if (function_exists('opcache_invalidate')) // OpCode extension
  opcache_invalidate($filename);
}

Go to forum: Installation

4,008 Reply by apmuthu

(6 replies, posted in Report Bugs here)

A cron job to flush out stale pdfs is one way. Randomised file names are another way. Multiple ways to beat file snooping will be needed in the meanwhile till we plug this one. Currently, the preferred method is possibly making a linux user with permissions for viewing the folder having the reports.

Go to forum: Report Bugs here

4,009 Reply by apmuthu

(6 replies, posted in Setup)

Enable MySQL logging and see if anything turns up.
If an external DB Dump from phpMyAdmin is available then it can be analysed for any non escaped characters and / or data size issues.

Go to forum: Setup

4,010 Reply by apmuthu

(9 replies, posted in Banking and General Ledger)

For records and settlements, even if there are no transactions/invoices, every day's exchange rate may be got.

Go to forum: Banking and General Ledger

4,011 Reply by apmuthu

(9 replies, posted in Accounts Receivable)

You will need to make a hidden field with assigned value.

Go to forum: Accounts Receivable

4,012 Reply by apmuthu

(27 replies, posted in FA Modifications)

Fork on GitHub and post changes

Go to forum: FA Modifications

4,013 Reply by apmuthu

(1 replies, posted in Reporting)

Report Watermarking is one way.

Go to forum: Reporting

4,014 Reply by apmuthu

(6 replies, posted in Setup)

Try to take a backup from SQLyog and analyse the dump to see where the time hog is.

Go to forum: Setup

4,015 Reply by apmuthu

(2 replies, posted in Setup)

https://frontaccounting.com/punbb/viewtopic.php?id=997

Go to forum: Setup

4,016 Reply by apmuthu

(22 replies, posted in Reporting)

Thanks for the feedback.

@joe: is another release in the 2.3 series due?

Go to forum: Reporting

4,017 Reply by apmuthu

(9 replies, posted in Report Bugs here)

TCPDF 's UTF-8 option embeds the font file in the generated PDF. You can try to turn t off by tinkering with the defaults in TCPDF.

Go to forum: Report Bugs here

4,018 Reply by apmuthu

(22 replies, posted in Reporting)

In general, it wll be best for you to replace all files that have changed since the release of FA v2.3.24 but in this instance, it should be okay for you to just replace the it with the one in the dev repo.

Go to forum: Reporting

4,019 Reply by apmuthu

(9 replies, posted in Report Bugs here)

Read the Wiki page on it under dejavu.php missing - TCPDF Font Failure part.

Go to forum: Report Bugs here

4,020 Reply by apmuthu

(22 replies, posted in Reporting)

Please paste the line 59 in your version of FA's includes/ui/ui_controls.inc file. If it is as per the latest commit, then my answer in the 6th post herein would solve the issue.

Go to forum: Reporting

4,021 Reply by apmuthu

(2 replies, posted in Setup)

FA v3.1.19 ?

Go to forum: Setup

4,022 Reply by apmuthu

(1 replies, posted in Manufactoring)

Check the barcode scanner setting for field termination - in some cases it is a tab (\t) and in others it is a carriage return (\r\n) or Enter key.

Go to forum: Manufactoring

4,023 Reply by apmuthu

(1 replies, posted in Items and Inventory)

Use the Packing List option in Delivery Note report.

Go to forum: Items and Inventory

4,024 Reply by apmuthu

(3 replies, posted in Accounts Payable)

Would not general categorization of the Items available in FA be sufficient for reporting purposes?

Go to forum: Accounts Payable

4,025 Reply by apmuthu

(24 replies, posted in Setup)

Anything wrong with the official Dutch / Belgian CoA?

Go to forum: Setup