Moved discussion to new post.
4,251 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)
4,252 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,253 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,254 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,255 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,256 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,257 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,258 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,259 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,260 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,261 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,262 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,263 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,264 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,265 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,266 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,267 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,268 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,269 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,270 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.
4,271 03/25/2015 05:25:51 pm
Re: System Parameter Variables (1 replies, posted in Setup)
Try to accommodate your document types within the regular ones to avoid upgrade hassles. Make these entries in your custom module to be appended to the standard arrays. Only your custom reports will probably use them - beware of some constructs that cause a blanket "not equal to" comparator for document matches that may inadvertently include your new ones.
4,272 03/25/2015 05:22:29 pm
Re: How to handle purchases from outside of country? (7 replies, posted in Setup)
Treat EXCISE as a tax.
4,273 03/25/2015 05:19:53 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Developments to the Unstable branch FA v2.4 have now been synched with changes from the Stable FA v2.3 on the release of FA v2.3.23. Further changes have been committed to the Unstable branch. This set of changes discerned since last reported pertain to this Hg snapshot.
The error reported in the 22nd post in this thread is still present in this snapshot.
The error in the sql/en_US-demo.sql for field definition is now rectified and the demo CoA installs correctly. The CoAs still have redundant indices - the devs have been informed.
Typos:
jiurnal => journal in comment on line 156 in sql/alter2.4.sql
multiply => multiple in comment on line 195 in sql/alter2.4.sql
hiddn => hidden in comment in line 96 in includes/ui/ui_input.inc
SQL Changes:
Improved journal trans: added currency support, tax and source document date and allow multiple customer/supplier allocations to single journal transaction:
New table 0_journal added - full support for any journal transaction
- no demo CoA entries as yet
- populate with:
INSERT INTO `0_journal` (`type`, `trans_no`, `tran_date`, `reference`, `event_date`,`doc_date`,`currency`,`amount`)
SELECT `gl`.`type`, `gl`.`type_no`, `gl`.`tran_date`, `ref`.`reference`, `gl`.`tran_date`,
`gl`.`tran_date`, `sys_curr`.`value`, SUM(IF(`gl`.`amount`>0,`gl`.`amount`,0))
FROM `0_gl_trans` gl LEFT JOIN `0_refs` ref ON gl.type = ref.type AND gl.type_no=ref.id
LEFT JOIN `0_sys_prefs` sys_curr ON `sys_curr`.`name`='curr_default'
WHERE `gl`.`type` IN(0, 35)
GROUP BY `type`,`type_no`;
0_cust_allocations.person_id field added and made part of unique key
0_debtor_trans.debtor_no populated into 0_cust_allocations.person_id
0_supp_allocations.person_id field added and made part of unique key
0_supp_trans.supplier_id populated into 0_supp_allocations.person_id
Added memo, usage fields to Quick Entries:
0_quick_entries.usage field added as a description field to denote where it should be used
0_quick_entry_lines.memo field added as a description field
Tax algorithm handling on supplier side is reverted as impractical:
0_suppliers.tax_algorithm field removed
0_supp_trans.tax_algorithm field removed
0_sys_prefs has a tax_algorithm entry default for customers only
includes/sysnames.inc has:
$tax_algorithms = array(
TCA_LINES => _("Sum per line taxes"),
TCA_TOTALS => _("Taxes from totals")
);
and is used in function get_tax_for_items() defined in taxes/tax_calc.inc
0_trans_tax_details.reg_type TINYINT added (0, 1 or NULL in the demo CoA data) and is populated with:
UPDATE `0_trans_tax_details` reg
SET reg.reg_type=1
WHERE reg.trans_type IN(20, 21); -- ST_SUPPINVOICE, ST_SUPPCREDIT
UPDATE `0_trans_tax_details` reg
SET reg.reg_type=0
WHERE reg.trans_type IN(10, 11); -- ST_SALESINVOICE, ST_CUSTCREDIT
New defines in includes/types.inc:
// tax register type
define('TR_OUTPUT', 0); // sales
define('TR_INPUT', 1); // purchase
0_gl_trans.type_no field definition in sql/en_US-demo.sql now stands corrected
Theme and cleanup changes:
Code cleanup for standard themes ported from FA 2.3 but inter-theme renderer.php files do not yet have their whitespace synched.
General code cleanup and HTML 4.01 compliance ported from FA 2.3 - some tag endings "/>" now become ">" whilst certain tag attribute values are quoted.
Improved error messages in transaction voiding
Sales invoice voiding is blocked when sales credit was issued against the invoice.
Class sys_prefs Method renamed:
$SysPrefs->refresh_company_prefs() => $SysPrefs->refresh()
New functions in UI:
tab_opened($name, $tab)
tab_closed($name, $tab)
tab_visible($name, $tab)
display_caption($msg) to display in <caption> tag added
//Confirm dialog to be used optionally in final form checking routine.
//Displays warning conditionally unless it was displayed
display_confirmation($msg)
New gl function for counter party name:
get_subaccount_data($code_id, $person_id)
Functions moved:
function write_journal_entries(&$cart) moved from gl/includes/db/gl_db_trans.inc to gl/includes/db/gl_journal.inc with single argument
function void_journal_trans($type, $type_no, $use_transaction=true) moved from includes/db/gl_db_trans.inc to new file gl/includes/db/gl_journal.inc
New file gl/includes/db/gl_journal.inc added
Now officially part of 0_sys_prefs table in CoA:
bcc_email
alternative_tax_include_on_docs
suppress_tax_rates
grn_clearing_act
default_receival_required
default_quote_valid_days
no_zero_lines_amount
show_po_item_codes
accounts_alpha
loc_notification
print_invoice_no
allow_negative_prices
print_item_images_on_quote
Theme fix for cool and default themes that still refer to the now defunct variable $allow_demo_mode along with white space synch is attached herein. The devs have been notified to make the necessary change.
4,274 03/24/2015 06:15:18 pm
Topic: Recent Unstable commitswrongly posted to stable branch steadied now (0 replies, posted in Announcements)
Consequent on the release of the FA v2.3.23 stable and the changes there in being merged with the Unstable v2.4 branch, development was possibly intended to go on in the latter only and it was prematurely moved to be the stable branch resulting in the unstable branch commits getting into the stable one. This "mistake" was quickly realised but the repo mess was there to stay along with that in the official Git. Both have since been reverted to the release state for the stable repo as on date. Attached is the equivalences of the snapshot taken from the official Git mirror.
Unfortunately, the Sourceforge Mercurial repo is not very usefully graphical and we will have to wait for some real commit in the stable branch for it's path (blue) to show up properly.
4,275 03/24/2015 11:22:02 am
Re: FA v2.4 development (48 replies, posted in Setup)
FA v2.3.23 stable has been released and it's updates have been merged into FA v2.4 dev repo and some more fixes incorporated into the latter.