Have created a Wiki page for it.
4,227 04/02/2015 03:43:37 am
Re: Profit before taxes (2 replies, posted in Banking and General Ledger)
Probably a footnote to state it so would appease the "authorities".
4,228 04/02/2015 03:42:25 am
Re: Import Transaction issue (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.
4,229 04/01/2015 07:28:48 pm
Re: Security Role Clone / Addition errors on edit / save (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.
4,230 04/01/2015 02:49:52 pm
Re: Security Role Clone / Addition errors on edit / save (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;15873into 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 changesshould have resulted in:
sections: 768;3072;5632;8192;8448;15872
areas: 773;774;3073;3075;3081;5633;8194;8449;15873;15874;15875but 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;16132It 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.
4,231 04/01/2015 02:07:12 pm
Re: Issue with Add and Manage Customers after upgrade to 2.3.23 (6 replies, posted in Report Bugs here)
Moved discussion to new post.
4,232 04/01/2015 02:06:09 pm
Topic: Security Role Clone / Addition errors on edit / save (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.
4,233 04/01/2015 01:08:36 am
Re: Issue with Add and Manage Customers after upgrade to 2.3.23 (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.
4,234 04/01/2015 01:00:27 am
Re: Opencart sync / integration (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.
4,235 04/01/2015 12:53:19 am
Re: Import Transactions (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.
4,236 03/31/2015 06:53:48 am
Re: Issue with Add and Manage Customers after upgrade to 2.3.23 (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?
4,237 03/31/2015 06:48:43 am
Re: Opencart sync / integration (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.
4,238 03/29/2015 01:32:50 pm
Re: FA v2.4 development (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.
4,239 03/29/2015 12:53:03 pm
Re: Issue with Add and Manage Customers after upgrade to 2.3.23 (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.
4,240 03/29/2015 12:42:18 pm
Re: FrontAccounting code repo switched to Git DVCS (1 replies, posted in Announcements)
Thanks Janusz! About time.
Updated the Wiki with the info.
4,241 03/29/2015 12:04:45 pm
Re: Selecting a client... (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
4,242 03/29/2015 11:59:36 am
Re: Include memo_ from gl_trans table in bank statement (7 replies, posted in Reporting)
Excellent, care to post the code?
4,243 03/29/2015 11:58:35 am
Re: Blank page after login (12 replies, posted in Installation)
Set your locale manually:
http://stackoverflow.com/questions/3398113/php-gettext-problems
4,244 03/27/2015 03:58:27 pm
Re: Include memo_ from gl_trans table in bank statement (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).
4,245 03/27/2015 03:50:38 pm
Re: Need Programmer for Modification Front Accounting (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.
4,246 03/27/2015 03:39:53 pm
Re: Sorting Item List (8 replies, posted in Setup)
Take the report in Excel and sort inside the report!
4,247 03/26/2015 05:46:25 am
Re: How to handle purchases from outside of country? (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.
4,248 03/26/2015 05:43:44 am
Re: Customized P&L report (1 replies, posted in Jobs wanted/offered, non-free offers)
P&L is delivered as PDF and Excel in the default install of FA.
In both instances, being static reports, there is no easy scope for drill down.
Changing the period of reporting to a month (in the Company Preferences itself) will provide for the report subset you want albeit not exactly.
Checkout the reporting extensions available in the official FA repo and accessible from within the FA UI and if not there, then you can participate in designing one and submit it to the project for inclusion in the core.
4,249 03/25/2015 05:47:46 pm
Re: trial balance for all accounts (1 replies, posted in Banking and General Ledger)
When requesting for a trial balance, there is an option to suppress zero values.
@joe: looks like the form values are not being parsed properly causing the trial balance to report wrongly when Zeroes are suppressed.
4,250 03/25/2015 05:28:30 pm
Re: Setup Issues (2 replies, posted in Setup)
Hope you are on FA v2.3.23. There were some inadvertant pushes in the last couple of days to the stable repo that should have gone into the unstable one - all are now set right in both repos.