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,201 04/07/2015 02:21:30 pm
Re: Report generator (4 replies, posted in Reporting)
4,202 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,203 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,204 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,205 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,206 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,207 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,208 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,209 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,210 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,211 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,212 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,213 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,214 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,215 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,216 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,217 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,218 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,219 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,220 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,221 04/02/2015 04:20:56 pm
Re: extension installation instructions - step by step (13 replies, posted in Setup)
4,222 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.
4,223 04/02/2015 05:46:52 am
Re: Security Role Clone / Addition errors on edit / save (9 replies, posted in Report Bugs here)
Finally fixed it - it was failing since the value of the checked element was not being tested:
--- admin/security_roles.php Sat Mar 14 20:35:36 2015
+++ admin/security_roles.php Thu Apr 02 11:09:29 2015
@@ -85,8 +85,8 @@
$sections = array();
$areas = array();
foreach($_POST as $p =>$val) {
- if (substr($p,0,4) == 'Area') {
- $a = substr($p, 4);
+ if (substr($p,0,4) == 'Area' && $val == 1) {
+ $a = (int)substr($p, 4);
if (($a&~0xffff) && (($a&0xff00)<(99<<8))) {
$sections[] = $a&~0xff; // add extended section for plugins
}
The devs can now port it to FA 2.4 as well using the same patch file.
4,224 04/02/2015 04:59:57 am
Re: FA v2.4 development (48 replies, posted in Setup)
The version 2.4's CoAs seem to have an extra area (permission) for practically all roles - 775 (Edit other users transactions).
Is this intended?
This is appended to the end of the areas field value.
4,225 04/02/2015 04:43:00 am
Re: Security Role Clone / Addition errors on edit / save (9 replies, posted in Report Bugs here)
The fix needs to be corrected since the database storage symptoms are still there although the GUI shows it correctly:
Salesman Role:
sections: 768;3072;5632;8192;15872
areas: 773;774;3073;3075;3081;5633;8194;15873
Cloning Salesman as SalesWoman and adding in 2 areas to existing section and 1 area to new section results in:
sections: 768;3072;5632;5888;8192;15872
areas: 773;774;3073;3075;3081;5633;5889;8194;15873;15874;15875;513;514;515;516;517;518;519;520;521;522;523;524;525;526;2817;2818;2819;2820;2821;2822;2823;3329;3330;3331;3332;3333;3334;3335;5377;7937;7938;7939;7940;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11011;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15628;15625;15626;15627;15629;16129;16130;16131;16132
but it should be:
sections: 768;3072;5632;5888;8192;15872
areas: 773;774;3073;3075;3081;5633;5889;8194;15873;15874;15875
Eliminating all blank areas is better than choosing all selected areas if a mere presence is checked instead of the value!
This persists even in FA 2,4 where an extra permission 775 (Edit other users transactions) is given to Salesman role - is this intended? If so, would it not be better to keep the 775 along with 773 and 774 instead of at the end in the insert statement statements in the CoAs? This (775) seems to be so for practically every role!