4,201

(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,202

(4 replies, posted in Reporting)

Use the standard Packing List Report (An option in Delivery Report).

View Packing List Report Screenshot in Wiki.

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.

Please try with FA v2.3.24 as there are some manufacturing files that have changed.

4,205

(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

(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.

Does this occur in FA v2.3.24?

4,208

(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

(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

(18 replies, posted in Wish List)

Do you want to try Bank Account Reconciliation?

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

(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;

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

(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.

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

(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.

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!

Install from the official pkg repo from within FA first. Then update the files from my unofficial extensions file set.

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

(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.

The Wiki is the place to look:

Generic Installation of Addons and their links.

Specific to Modules

4,222

(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.

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

(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.

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!