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.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
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?
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.
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.....
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.
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?
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.
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.
@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.
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.
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!
Have created a Wiki page for it.
Probably a footnote to state it so would appease the "authorities".
Working example:
reference,date,memo,amount,accountcode,taxtype,dim1_ref,dim2_ref,person_type_id (supplier=1 customer=2),person_id
JNL1,01/12/2014,Bad debts using account 8100,222.24,8100,0,D1,D2,,
JNL1,01/12/2014,Debtors Control using account 1100,-222.24,1100,0,D1,D2,2,2
JNL2,02/12/2014,Rent outstanding,122.25,7100,1,D1,D2,,
JNL2,02/12/2014,Accruals,-122.25,2109,0,D1,D2,,
JNL3,03/12/2014,Prepayments,322.26,1103,0,D1,D2,,
JNL3,03/12/2014,Rent Prepaid,-322.26,7100,1,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Prepayments,400,1103,0,D1,D2,,
JNL4,04/12/2014,Rent Prepaid,-800,7100,1,D1,D2,,
Do not use double quotes (or any quotes) in the file and use commas as the separateor - do not use it in the description / content of any of the fields. Make sure that the CR/LF is proper and does not occur within a field.
What a nice way to Ajax the whole page temporarily! Thanks for the real fix - that was fast - will test and revert.
When you release the FA v2.3.24, please make the now unused field 0_sys_types.type_no = 1 for all records in both CoAs in the insert statements.
Also "stay in old page when customer is updated fix" can also be committed.
To prevent uneditable item descriptions in "purchasing" files from being unnecessarily being updated with same content (and mangling special characters), my commits to the files:
FAMods/purchasing/includes/po_class.inc
FAMods/purchasing/includes/ui/po_ui.inc
FAMods/purchasing/po_entry_items.php
may be taken into the new release as well.
Further analysis on attempting to clone the simplest role: Salesman
sections: 768;3072;5632;8192;15872
areas: 773;774;3073;3075;3081;5633;8194;15873
into a new role SalesWoman with extra permissions:
section: Inventory analytics
area: Reorder levels
section: Banking & GL transactions
area: GL postings view
area: Exchange rate table changes
should have resulted in:
sections: 768;3072;5632;8192;8448;15872
areas: 773;774;3073;3075;3081;5633;8194;8449;15873;15874;15875
but in actuality resulted in the same section field but with extra areas as in:
sections: 768;3072;5632;8192;8448;15872
areas: 773;774;3073;3075;3081;5633;8194;8449;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;5889;5890;5891;7937;7938;7939;7940;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
It is clear that the routine parsing the areas is wrong as it takes all areas for the given sections instead of the chosen ones alone, appending the rest to the proper ones.
This may be alleviated if the next area to be inserted is greater than those already in the area list.
As usual, functions are interspersed with sequential code in admin/security_roles.php where all this presumably occurs or triggers.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.