Crystal Report Field Edited Date

SOLVED

I have two udf’s that are populated on the SO_SoDetail table, they are also printing on our pick ticket.  How can I capture a date time stamp value for when that udf is edited (it’s a numerical value) and display it on the crystal report for the pick sheet?

Parents
  • 0

    Add a UDF for the date/time, and put a column post-validate script on the UDF you want to track... to set the date/time UDF.

  • 0 in reply to Kevin M

    Would I set the trigger to be if the udf is greater than 0 or can I set if the field is updated?  Thinking out loud, can't do if greater than zero because if we receive an item multiple times, so need to set it on if the udf was updated.  Would the BusObj.EditState =2 be the correct variable to look for this?

  • 0 in reply to jland47

    The event is the event.  Column post validate will trigger when someone changes the data in that column.

    The business logic you apply in the script is up to you, depending on your business requirements.

  • 0 in reply to Kevin M

    I set on a column post val of the udf_qty_received, received this error when I tried to update the udf from a receipt of goods script and also when I tried to update the udf directly on the SO.

    Here is the script.

    rVal = 0	
    dToday = ""
    nQTY = 0
    
    rVal = BusObj.GetValue("UDF_QTY_RECEIVED", nQTY)
    
    if nQTY > 0 then
    	
    rVal = oSession.FormatDate(oSession.SystemDate, dToday, "%M/%D/%Y")
    	
    dToday = oSession.GetFormattedDate(CStr(dToday))	
    
    rVal = oBusObj.SetValue("UDF_QTYREC_UPDATED$", dToday)
    
    end if

Reply
  • 0 in reply to Kevin M

    I set on a column post val of the udf_qty_received, received this error when I tried to update the udf from a receipt of goods script and also when I tried to update the udf directly on the SO.

    Here is the script.

    rVal = 0	
    dToday = ""
    nQTY = 0
    
    rVal = BusObj.GetValue("UDF_QTY_RECEIVED", nQTY)
    
    if nQTY > 0 then
    	
    rVal = oSession.FormatDate(oSession.SystemDate, dToday, "%M/%D/%Y")
    	
    dToday = oSession.GetFormattedDate(CStr(dToday))	
    
    rVal = oBusObj.SetValue("UDF_QTYREC_UPDATED$", dToday)
    
    end if

Children