Scripting

  • 1.  Has anyone ever triggered a script from the Credit

    Posted 02-06-2018 12:20
    Has anyone ever triggered a script from the Credit Limit Warning screen that opens during SO Entry? Looking to capture the user that said ""OK"" to allow the Credit Limit to be exceeded. Thx.


  • 2.  RE: Has anyone ever triggered a script from the Credit

    Posted 02-06-2018 12:23
    You could use customizer to hide the standard buttons and then add replacement buttons that execute a script where you will be able to handle capturing the user and doing whatever it is that you want to with it.


  • 3.  RE: Has anyone ever triggered a script from the Credit

    Posted 02-06-2018 12:29
    There's a property CreditExceeded available in SO_SalesOrder_bus. You should be able to do something like: if oBusObj.creditexceeded <> 0 then retVal = oBusObj.SetValue(""UDF_UserExceeded$"", oSession.UserCode)


  • 4.  RE: Has anyone ever triggered a script from the Credit

    Posted 02-07-2018 06:27
    These are both good suggestions, thank you very much!


  • 5.  RE: Has anyone ever triggered a script from the Credit

    Posted 02-13-2018 09:38
      |   view attached
    I added the script to set the value to a UDF using the .creditexceeded logic, which works in SO Entry. I would also like to populate it to SO History Inquiry, but its not happening correctly every time. -If I create an order, use the override, & then delete it, SO History is then populated & correct. -If I create the order, use the override, & just accept it, that field is not populated in SO History. -If I create the order, accept it, go back & change it, it populates into SO History. -If I create the order, accept it, change it so it populates to SO History & place on hold. Then, I go back as a different user & take it off Hold & Accept it, it doesn't change it in SO History. Problem because this is what I need to capture in both places. I need to know that after the fact, when they look back on an order & need to know who released it, that SO History Inquiry is accurate. I have this running as Table - Pre-Write in SO Sales Order Header, should I change this? The UDF is automatically placed on SO History Header when I placed it on the SO Header. Do I need another script event on SO History Header? I've tried it without one & also I tried a Table - Post-Read, Table - Pre-Write, Table - Post-Write, & Table - Set Default Values & none of them are helping. TIA!


  • 6.  RE: Has anyone ever triggered a script from the Credit

    Posted 02-13-2018 14:13
    Why not flow the UDF value to the invoice, then invoice history, and do your reporting off of that?