Sage 100

Here's a brain teaser I need assistance with. New Implementation on Sage 2013 v5.0 PU1. Full Manufacturing company. We have bills created but there are certain bills that are to be kept confidential and only a select few in the company should see or have access to these particular bills (Private formulas). In what ways can you define specific bills available only for certain users or what method of processing can ensure this private information stays secure and private. I've muddled around the idea using another company code like in outside processing and locking that down. Other ideas, anyone?

Have you thought about creating a BM Header UDF to indicate which are private bills, and then create custom lookups to hide those bills from the general population?

You could create a customization group in user maintenance for the restricted users. Use Library Master, User Lookup Wizard to create the custom ALE lookup for the new customization group.

The above suggestions only work in the lookup. You could still browse - using the arrows to gain access to the BOM. You would need to do a script that looks at a udf that grants access to the lines tab. There is a sample script done similar for sales people in only access their accounts in customer maintenance.

I was going to suggest as per above, but the issue will be that users will still have access to the restricted bills by either entering the bill number directly, or using the Next or Previous buttons. The next/prev buttons could be hidden, of course, but this still would not solve the entering directly issue.

Good ideas but this only affects the lookup and not the accessing. They are very strict on keeping the formula's 'secret'. The number could be typed in and accessed. This is the first time this information has even been visible. The information has been kept in their heads until now. But maybe since they are creating part numbers. Thanks, will keep this as an option. Think of any more, please...send

Johnny, you got some more information on how that script would work? I started learning about script writing this year and have only deployed one in the field so far (self taught). But it's working -and correctly (LOL). Would you set this script to show only these restricted formulas when invoked? Create a button to display the formulas but the button is only seen by these select few?

@AlnoorCassim is hosting a great two day scripting class at the end of July..... Worth its weight in gold chips....

Let me guess - customer is Colonel Sanders / KFC

If the BOM number is something that is not easily predicted it would be almost impossible to use the ALE for a lookup (given the next buttons were also hidden). It would be like trying to guess someone's credit card number.... possible but highly improbable.

If the formulas are that secretive you had better lock down the ODBC driver too.

Instead of a UDF, you could rename all of the secretive bills to something that starts with ""z"" (or any character). Then use a filter ( BOM does not start with ""z"") to display only the non-secretive bills. Add each restricted user to a customization group. User Lookup Wizard to create the custom ALE lookup (with he filter) for the new customization group.

Not Colonel Sanders, it's the man with the dog, Bush Baked Beans (LOL-JK)