Moved discussion to new post.

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.

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

(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

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

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

4,257

(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

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

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

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

Thanks Janusz! About time.

Updated the Wiki with the info.

4,261

(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

Excellent, care to post the code?

4,263

(12 replies, posted in Installation)

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

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

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

(8 replies, posted in Setup)

Take the report in Excel and sort inside the report!

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

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.

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

(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

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

Treat EXCISE as a tax.

4,273

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

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

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