02-27-2012 11:13 PM - edited 02-27-2012 11:27 PM
Hi guys, I hope someone can help.
I can't seem to restrict access to the cost field in the product list.
I have just been through the process of getting a nice product list generated from our manufacturing software which I have imported into Act.
I do not however seem to be able to set any access privileges to this information. In particular the cost field which is company sensitive information. Not only do I not seem able to restrict users from viewing this field, I seems I can restrict them from changing it either. It doesn't seem to make sense to have a cost field against a product that any sales person can change with any arbitrary value they see fit.
Am I missing something?
We are using Act 2012 Premium and have applied all the latest service pack
02-28-2012 11:05 AM
You have ACT! 2012 Premium which provides for field level access control,but you cannot restrict field access for the product list table it seems. As developers we are working on a project now that includes better control over product items. If you email me at the below address, in the future we may be able to help.
02-29-2012 09:59 AM
Generally we get along fine with ACT Premium although there are some fundamental weaknesses in the product list table concerning data integrity which almost render the whole application useless. If anyone at anytime can manipulate the cost of an item in the product list, any gross margin reports are at best unreliable, and at worst, could be dangerously misleading.
I will proceed with caution
02-29-2012 11:23 AM
Because we are involved with integrating accounting software with ACT! we are familiar with the requests people have to tighten up security on pricing at the opportunity level. Right now we are involved with a mid-range accounting software integration that calls for improved control over the sales and quoting process within ACT!. So while our focus is on a particular accounting software, the spin off from that will be a module that will run without any accounting software integration but still secure the product and services list and provide for more flexible quoting output from ACT!
I will post back here with more information on completion
02-29-2012 04:09 PM
02-29-2012 05:36 PM
The problem, as pointed out, is a problem with ACT!. With the existing security that applies to the product list in ACT! opportunities, there is no way that any link product at all can integrate with the opportunity workflow without significant customisation within ACT!to maintain security.
02-29-2012 11:25 PM
Thank you all for your input. We are using a complex MRP package in order to control the manufacturing and accounting processes and are definitiliy not looking to integrate Sage Accounting in anyway. If anyone does come up with a solution which will give greater security and data integrity with the product list, but does not require any other linkage to Sage Accounts, then I would be delighted to hear from you.