Sage 100

 View Only
  • 1.  Is it possible to use scripting with Custom Office

    Posted 06-13-2014 10:39
    Is it possible to use scripting with Custom Office to prevent someone from assigning the Drop Ship Order Type when creating a new Purchase Order in PO Entry?


  • 2.  RE: Is it possible to use scripting with Custom Office

    Posted 06-13-2014 11:00
    Jane: I'm guessing here, but you might try: OrderType="""" retVal = oBusObj.GetValue(""OrderType$"", OrderType) if OrderType = ""D"" then retVal = oScript.SetError(""Drop Ship Purchase Orders not Allowed."")


  • 3.  RE: Is it possible to use scripting with Custom Office

    Posted 06-13-2014 11:04
    Thank you @LeeGraham for the quick response. I will give it a try.


  • 4.  RE: Is it possible to use scripting with Custom Office

    Posted 06-13-2014 14:08
    What @LeeGraham said. Set it on Pre-Validate event on column OrderType. You can also shorten it to If value = ""D"" then sMsg = ""your no no finger wag msg"" retVal = oScript.SetError(sMsg) End If


  • 5.  RE: Is it possible to use scripting with Custom Office

    Posted 06-13-2014 14:10
    Love it @AlnoorCassim ! Might have to give that a try!