@joe: possible updation should be tried first before insertion or there is a primary key issue that is not satisfied in the query....
4,226 04/08/2015 12:00:33 pm
Re: Editing a Journal Entry results in a duplicate entry on Tax Report (20 replies, posted in Report Bugs here)
4,227 04/08/2015 07:18:12 am
Re: extension installation instructions - step by step (13 replies, posted in Setup)
For those attempting to use FA on Ubuntu 14.04, replace all instances of gzopen with gzopen64 to get it working.
The following should be self-explanatory:
php -r 'var_dump(function_exists("gzfile"));'
bool(true)
php -r 'var_dump(function_exists("gzopen"));'
bool(false)
php -r 'var_dump(function_exists("gzopen64"));'
bool(true)The following posts are useful references:
generateSitemap.php gzopen() fatal error on Ubuntu 14.04 (replace gzopen() by gzopen64())
Zlib functions (gzopen etc.) are undefined while gzopen64 etc. exist
Bug #20246 Broken with php 5.5.9
4,228 04/07/2015 05:29:49 pm
Re: FA v2.4 development (48 replies, posted in Setup)
All changes in the unstable FA 2.4 branch on and after 2015-03-31 till and including 2015-04-06 have been checked out and committed to my Unofficial GitHub Repo.
The error reported in the 22nd post in this thread is still present in this snapshot.
The Security Role fix has yet to be ported in from FA 2.3.
Here is a summary of changes:
Foreign language characters in password now allowed
0_sys_prefs.value changed from tinytext in FA 2.3 to TEXT NOT NULL default ''
demo data fiscal year and transactions moved from 2013-2014 to 2014-2015
Prices adjusted for discount directly from form field
Existing entries adjusted with:
UPDATE `0_stock_moves` SET + price = price*(1-discount_percent);Removed fields:
stock_moves.visible,
stock_moves.discount_percent
API functions and CoAs adjusted accordingly.
Sales Kits: 3rd parameter in function update_component($kit_code, $selected_item) dropped
function get_mb_flag($stock_id) moved from includes/db/manufacturing_db.inc to includes/db/inventory_db.inc
Adjusted file includes accordingly everywhere
Renamed includes/manufacturing.inc to includes\inventory.inc
4,229 04/07/2015 02:21:30 pm
Re: Report generator (4 replies, posted in Reporting)
1. Navigate to Sales tab => Inquiries and Reports section => Customer and Sales Reports
2. Under Reports For Class: Customer, click Print Deliveries
3. In the right side form for Print as Packing Slip: choose Yes.
4,230 04/07/2015 01:53:35 pm
Re: Report generator (4 replies, posted in Reporting)
Use the standard Packing List Report (An option in Delivery Report).
View Packing List Report Screenshot in Wiki.
4,231 04/07/2015 01:42:28 pm
Re: EMail All Customers report / module in Official Git (4 replies, posted in Modules Add-on's)
1. Upload the folder in the attached zip file into the modules folder in your FA webroot.
2. Login to your default (control) company
3. Navigate to Setup => Install / Activate Extensions
4. Install the EMail Customers Extension by clicking the green install icon to the extreme right in the row.
5. Choose the Working company from the top drop down box to Activate the extension
6. Tick the checkbox to activate the extension for the said company.
7. Logout from the default (control) company
8. Login to the Working Company
9. Navigate to Sales => Inquiries and Reports => Customer and Sales Reports => EMail Customers
The Wiki has the screenshot.
4,232 04/07/2015 01:21:16 pm
Re: Bug deleting lines on journal entry and issue items to work order (3 replies, posted in Report Bugs here)
Please try with FA v2.3.24 as there are some manufacturing files that have changed.
4,233 04/07/2015 01:00:22 pm
Topic: MSIE 8.0 Ajax not working (0 replies, posted in Installation)
When was the last time (version of FA) that Ajax functionality worked in MS IE 8.0 dropdown select box populating customers, suppliers, inventory tems and Security Roles, CoA Accounts, etc?
The ExactCA.com site FA review stated that v2.3.21 worked on MS IE 8.0 - but it didn't.
Reverting changes in insert.js and utils.js if any did not provide succour.
4,234 04/07/2015 11:50:27 am
Re: Release 2.3.24 (1 replies, posted in Announcements)
The changes in FA v2.3.24 above include the ones in FA v2.3.23 since the latter was revoked.
Subsequent to the release of FA v2.3.24, additional fixes are attached herein.
4,235 04/07/2015 11:45:25 am
Re: Bug deleting lines on journal entry and issue items to work order (3 replies, posted in Report Bugs here)
Does this occur in FA v2.3.24?
4,236 04/07/2015 11:43:17 am
Re: HTML Reports (3 replies, posted in Reporting)
Actually the PDF should print well in the Dot Matrix Printer (DMP) - try to choose Fixed Font like Courier New. Printing HTML on a DMP will be all over the place....
Convert your PDF files to HTML using PDF-to-HTML-Ex. It is on the web in GitHub.
4,237 04/07/2015 11:40:45 am
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
If you wish to track inventory of Services, then create a Service Item of Inventory Type (and not Service Type) and put in a huge value of stock so that it does not run out... A separate stock category if you want.....
4,238 04/07/2015 11:39:10 am
Re: Add check payments (18 replies, posted in Wish List)
Do you want to try Bank Account Reconciliation?
4,239 04/07/2015 11:38:10 am
Re: Choosing a preferred chart of accounts (CoA) after installation (1 replies, posted in Banking and General Ledger)
When installing, choose the US New CoA in Company #0. This will be your "default" company for making settings changes and installing addons (like themse, CoAs, Languages and Extensions) across companies and should not be used for any transactions.
From within Company #0, create a new company #1 and in your case choose the preferred Australian CoA.
Now logout of the default company #0.
Then, login to the Company #1 which will be your "working" company and enjoy FA.
4,240 04/05/2015 04:03:12 pm
Re: Labour and Overhead Cost (1 replies, posted in Items and Inventory)
You can look at the stock_master table:
CREATE TABLE `0_stock_master` (
`stock_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`category_id` int(11) NOT NULL DEFAULT '0',
`tax_type_id` int(11) NOT NULL DEFAULT '0',
`description` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`long_description` tinytext COLLATE utf8_unicode_ci NOT NULL,
`units` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'each',
`mb_flag` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'B',
`sales_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`cogs_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`inventory_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`adjustment_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`assembly_account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`dimension_id` int(11) DEFAULT NULL,
`dimension2_id` int(11) DEFAULT NULL,
`actual_cost` double NOT NULL DEFAULT '0',
`last_cost` double NOT NULL DEFAULT '0',
`material_cost` double NOT NULL DEFAULT '0',
`labour_cost` double NOT NULL DEFAULT '0',
`overhead_cost` double NOT NULL DEFAULT '0',
`inactive` tinyint(1) NOT NULL DEFAULT '0',
`no_sale` tinyint(1) NOT NULL DEFAULT '0',
`editable` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;4,241 04/05/2015 03:53:59 pm
Re: extension installation instructions - step by step (13 replies, posted in Setup)
https://bugs.launchpad.net/ubuntu/+source/php5/+bug/1315888
If gzopen64() function exists, use it else use gzopen() => needs to be implemented in FA.
The said function appears in 4 core files (and not in any extension file):
admin/backups.php (1 hit)
Line 102: if (function_exists("gzopen"))
admin/db/maintenance_db.inc (1 hit)
Line 723: if ($zp = @gzopen(BACKUP_PATH . $backupfile, "a9"))
includes/archive.inc (2 hits)
Line 441: if ($fp = gzopen($this->options['name'], "wb{$this->options['level']}"))
Line 462: return @gzopen($this->options['name'], "rb");
includes/packages.inc (2 hits)
Line 165: $list = gzopen($file, 'rb');
Line 220: $file = $zip ? gzopen($fname, 'wb') : fopen($fname, 'wb');Maybe a wrapper function is in order.... fa_gzopen()
@joe: any ideas?
4,242 04/05/2015 03:47:48 pm
Re: Add check payments (18 replies, posted in Wish List)
If all you want is to search the memo field, then you have to strictly follow some text syntax in entering the cheque details that can be searched using a custom report with a text search query to feed it. The dates - from and to - can be entered in the report form request data.
4,243 04/05/2015 03:43:43 pm
Re: need php developer to customize frontaccounting (8 replies, posted in Jobs wanted/offered, non-free offers)
To get PHP work done it is not necessary to get the programmer into Saudi Arabia from anywhere in the world and subject them to your local laws, security and social mores. Your "employees" can remain anywhere in the world as long as they are connected.
In this world, it is sustainable for people to work with each other and not for any other.
4,244 04/05/2015 03:39:23 pm
Re: No theme in install/activate theme list (2 replies, posted in Setup)
The standard set of themes that come with FA need no activation / installation. They are available for the logged in user under Preferences => Misc => Theme and in Setup => Display Setup Menus.
4,245 04/05/2015 03:35:13 pm
Re: Security Role Clone / Addition errors on edit / save (9 replies, posted in Report Bugs here)
The ui_input.inc fix was committed after the release of FA v2.3.24.
Thanks for your diligence in ferreting out this bug and testing it through to it's logical end!
4,246 04/04/2015 08:30:58 pm
Re: extension installation instructions - step by step (13 replies, posted in Setup)
Install from the official pkg repo from within FA first. Then update the files from my unofficial extensions file set.
4,247 04/04/2015 08:25:06 pm
Re: Security Role Clone / Addition errors on edit / save (9 replies, posted in Report Bugs here)
The problem you are getting is because all areas have been stored in the security_roles tables for all roles that got edited with the erroneous file. Start afresh for the security_roles table and see how it goes.
Check out the latest FA v2.3.24 and see if that solves your problems.
4,248 04/02/2015 04:22:36 pm
Re: Import Transaction issue (3 replies, posted in Modules Add-on's)
@rossaddison, @joe: wherever csv files are used in FA, we need to take care of line endings making it OS agnostic. Just replace all CRLF with LF and start to work.
4,249 04/02/2015 04:20:56 pm
Re: extension installation instructions - step by step (13 replies, posted in Setup)
4,250 04/02/2015 06:33:34 am
Re: Release 2.3.23 has been revoked. (1 replies, posted in Announcements)
For those of you who have happened to migrate to FA v2.3.23 in production, just overwrite your existing files with the ones in this post. It contains all changes and fixes till date including the as yet unreleased fix for the security roles issue.
Rest assured that this was no April Fools day joke. Deliverance before Good Friday / Easter Sunday provided! Have a nice holiday....
FA Team.
