4,251 Reply by apmuthu

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

Go to forum: Report Bugs here

4,252 Reply by apmuthu

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

Go to forum: Setup

4,253 Reply by apmuthu

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

Go to forum: Report Bugs here

4,254 Reply by apmuthu

(154 replies, posted in Modules Add-on's)

Have created a Wiki page for it.

Go to forum: Modules Add-on's

4,255 Reply by apmuthu

(2 replies, posted in Banking and General Ledger)

Probably a footnote to state it so would appease the "authorities".

Go to forum: Banking and General Ledger

4,256 Reply by apmuthu

(3 replies, posted in Modules Add-on's)

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.

Go to forum: Modules Add-on's

4,257 Reply by apmuthu

(9 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

4,258 Reply by apmuthu

(9 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

4,259 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Moved discussion to new post.

Go to forum: Report Bugs here

4,260 Topic by apmuthu

(9 replies, posted in Report Bugs here)

Moved discussion from @pilotspelman's post here as it is a different topic.

Verified that this error exists:
Clone a Role, change the role name and description, make role changes and insert as new role.

The role is inserted - but - Elements not selected in existing selected groups will remain unselected as it should be. If any new Access group was chosen, then all elements in them will get selected even if some of them were not chosen which is wrong.

Now if the newly created role is chosen and edited, then any group with any elements currently selected or remained selected, will get all elements of those groups selected even if they were unselected when saved which is certainly wrong.

Attached are the screenshots.

Go to forum: Report Bugs here

4,261 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Do the same with normal English Alphabets for the Role name - it is possible that foreign language characters will evaluate to admin role when not found!

Also try after cloning the role, logout, clear cache and then login again and then edit the role and see if the new settings persist. This will help check out session issues.

Go to forum: Report Bugs here

4,262 Reply by apmuthu

(3 replies, posted in Modules Add-on's)

You can also try LogicWorks of NZ. Phil Daintree there is the lead developer of WebERP - FA is it's fork.

If you are out of commercial support, then you may contact me offline specific of actual workflow.

Go to forum: Modules Add-on's

4,263 Reply by apmuthu

(154 replies, posted in Modules Add-on's)

From the PHP Manual:

The following things are considered to be empty:

"" (an empty string)
0 (0 as an integer)
"0" (0 as a string)
NULL
FALSE
array() (an empty array)
var $var; (a variable declared, but without a value in a class)

Hence it is better to make it:

      if (!empty($person_id))

This has been committed in my Unofficial GitHub Repo and extension file set attached herein.

Also placed the screenshots online as a zip file.

Go to forum: Modules Add-on's

4,264 Reply by apmuthu

(6 replies, posted in Report Bugs here)

The security areas can be expanded to specifically unselect it's child permissions - which browser and version are you using?

Go to forum: Report Bugs here

4,265 Reply by apmuthu

(3 replies, posted in Modules Add-on's)

Checkout http://anterp.com/ for their OpenCart Connector to FA.

You will have to decide which direction you wish to synch: OC => FA or FA => OC for each data element.

Product Codes, Names and balance stock from OC to FA would render all previous transactions using them possibly erroneous if changed. The stocks are to be dynamically adjusted after getting the actual sales bills imported.

Go to forum: Modules Add-on's

4,266 Reply by apmuthu

(48 replies, posted in Setup)

FA 2.4 development moved to Git on Sourceforge. Official FA Unstable 2.4 repo is at GitHub.

The error reported in the 22nd post in this thread is still present in this snapshot.

$allow_demo_mode fixed in renderer.php files all themes but whitespace not synched between them as yet - patched files for whitespace synch attached.

Go to forum: Setup

4,267 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Setup => Company Setup  => Search Customer List => Uncheck

Do the same for the Search items List and Search Suppliers List as needed.

Go to forum: Report Bugs here

4,268 Reply by apmuthu

(1 replies, posted in Announcements)

Thanks Janusz! About time.

Updated the Wiki with the info.

Go to forum: Announcements

4,269 Reply by apmuthu

(6 replies, posted in Setup)

items can be classified into categories stored in the stock_category table.

When a large number of clients / customers / suppliers are there, then use the search option and not the drop down select list.

Setup => Company Setup => Search Items (Suppliers / Customers) List => Check

Go to forum: Setup

4,270 Reply by apmuthu

(7 replies, posted in Reporting)

Excellent, care to post the code?

Go to forum: Reporting

4,271 Reply by apmuthu

(12 replies, posted in Installation)

Set your locale manually:
http://stackoverflow.com/questions/3398113/php-gettext-problems

Go to forum: Installation

4,272 Reply by apmuthu

(7 replies, posted in Reporting)

Make a mockup of with and without the memo_ field and paste the link to the image here so that we can advise you. FA v2.4 now in development state now supports the person_id in these reports (hopefully).

Go to forum: Reporting

4,273 Reply by apmuthu

(4 replies, posted in Jobs wanted/offered, non-free offers)

Dear Effendy Hakim,

Post your hourly rate payable or lumpsum contract value along with detailed specs so that any user may contact you directly.

Also your website does not show your address to be in Indonesia:
Jl. Suasa No. 1-C
Medan 20214
Sumut Indonesia

Jl Pukat VI 81 B
Tegalsari Mandala I, Medan Denai
Medan 20226 Sumatera Utara

This will help you source from among many talented Indonesians locally at local rates. Masino Sinaga runs a popular PHP Tech site I Love PHPMaker and is in Indonesia.

Go to forum: Jobs wanted/offered, non-free offers

4,274 Reply by apmuthu

(8 replies, posted in Setup)

Take the report in Excel and sort inside the report!

Go to forum: Setup

4,275 Reply by apmuthu

(7 replies, posted in Setup)

Multiple taxes can be consolidated by choosing a different subset of exemptions. Study the Wiki page on how Tax is administered in FA.

Go to forum: Setup