Sage 100

 View Only

  • 1.  limit signature on check based on user

    Posted 12-08-2020 10:21
    I am trying to set a condition for an image of the signature on a check based on the user id.  I know there has to be an easy way I am overlooking.  I need the user ID of Sage or the windows user to add a condition to the image to suppress when not a certain list of users.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------


  • 2.  RE: limit signature on check based on user

    Posted 12-08-2020 10:22

    I just put the signature behind a password.

     

    Rhonda McNamara

    Stewart Technologies, Inc.

    410-309-9550 x-1108 New!

     






  • 3.  RE: limit signature on check based on user

    Posted 12-08-2020 10:31
    Are you saying Sage menu security?  

    If so, what they would like to do is have users with rights to print with signature and those without rights to get a check without the signature.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


  • 4.  RE: limit signature on check based on user

    Posted 12-08-2020 10:34
    Create a blank formula field named correctly and the value is passed runtime into the report... same method Sage uses to print logon on journals / registers.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: limit signature on check based on user

    Posted 12-08-2020 10:36
    Parameter.  Suppress if the entered value doesn't match what the user types in.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: limit signature on check based on user

    Posted 12-08-2020 10:41
    I set the formula to PrintedByUser.  I used Basic Syntecs and Null to defaults and it is not returning a result.  I was then going to use that formula in the suppress conditions.

    It returns blank.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


  • 7.  RE: limit signature on check based on user

    Posted 12-08-2020 10:43


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 8.  RE: limit signature on check based on user

    Posted 12-08-2020 10:42
    1. In company maintenance - check off the "Print User ID"
    2. Create formula "PrintedByUser" whose value is Formula=""

    I have noted that this passes the numeric user key but I think I found it actually passed the user code ( ie. "lbradford" ).

    Throw this in a conditional suppress on the image.


    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 9.  RE: limit signature on check based on user

    Posted 12-08-2020 10:48
    User was not appearing because the company setup checkbox for print user id was not marked.  I am on my way.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


  • 10.  RE: limit signature on check based on user

    Posted 12-08-2020 11:26
    Edited by Larry Bradford 12-08-2020 11:27
    And all works and is solved.  Here is the formula...

    not (@PrintedByUser in ["LCB","CLB"]​)

    Also for some reason crystal did not like "not in".  I had to use the above.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


Related Content