Hello,

I am trying to recreate this for my own purposes, and every time I make a change in my table I do see a new record is added, but it's only giving me a date/time stamp, no other fields are being populated. Any advice?

retVal = 0
oAudit = 0

Set oAudit = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "AR_UDT_CUSTSHIPTOTAXEXEMPT_AUD"))

Customer = ""
retVal = oBusObj.GetValue("CustomerNo$", Customer)

ShipTo = ""
retVal = oBusObj.GetValue("ShipToCode$", ShipTo)

user = ""
user = oSession.UserName

dateStamp = ""
timeStamp = ""
userKey = ""
retVal = oSession.GetStampInfo(userKey, dateStamp, timeStamp)

retVal = oAudit.SetKey(Customer+dateStamp+timeStamp)
If retVal > 0 Then
retVal = oAudit.SetValue("UDF_CHANGEDATE$", dateStamp)
retVal = oAudit.SetValue("UDF_CHANGETIME$", timeStamp)
retVal = oAudit.SetValue("UDF_USERKEY$", user)
retVal = oAudit.SetValue("UDF_CUSTOMERNO$", Customer)
retVal = oAudit.SetValue("UDF_UDF_SHIPTOCODE$", ShipTo)
retVal = oAudit.Write()
If retVal=0 Then
 ' error on the write to audit table
End If
End If

Thank you!!

Is your key field in the UDT long enough to hold the number of characters in your SetKey value?  Did you verify the retVal is good?  (What's oAudit.LastErrorMsg after the SetKey)?

I'd create the key string in advance, using specific commands for formatting the date / time as text (eg. YYYY-MM-DD_hh-mm-ss), and confirm that formula works before the SetKey (instead of just hoping the GetStampInfo return values are acceptable).

That is a great question! I set it to hold 50 characters to ensure that it would be more than long enough. I am actually new to all of this and don't know how to check retVal. Where can I see this value?

This is the current output when a value is changed in the panel. It doesn't even show any of the other columns!

Thank you so much for your response!

Kevin, I just saw your comment on another post about needing to exit the panel for changes to take place! That did the trick.. THANK YOU SO MUCH!

Greetings,

One note about UDTs and Security (Role Maintenance) when UDTs are added to the menu in Sage 100.  Prior to Sage 100 Versions 2021 PU4 and 2022 PU1 if multiple UDTs were added to the menu there was no way to set security for a specific UDT.

The first UDT listed in UDT Maintenance had to have access in Role Maintenance in order for the UDTs to be accessible via the script. i.e. if security not set for top UDT, the following may fail:

     Set oAudit = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SO_UDT_ORDERAUDIT"))

The workaround is to grant access to all UDTs in Role Maintenance.

With the proper version and PU, this issue is corrected and security can be set in Role Maintenance for only the UDT(s) that requires access.

There should also be a program fix available (by request?) for version 2020

Thank you,

Kent

That's good info.. thank you so much Kent

Is there a method to load a bus obj into memory (possibly from a script init event) for the session itself? I have been trying to create a 'hack' of sorts in DFDM where a custom multiline obj can obtain a value from a UDT without a linked validation. I am in the process of creating an integrated credit release tracking system for use between Sales, Shipping, and Accounting. The UDT simply uses the s/o # as the key field since it should always be a 1-to-1 relationship at most (i.e. a sales order wouldn't have two different release records in this table but could have none).

So the issue is that there is a validation-linked relationship between SalesOrder + Credit Releases UDT. The key of this UDT is simply the order # and is linked by validation, so that allows SO Entry to return columns from this UDT - which is good. However, within the UDT itself is a reference to a 2nd UDT that has the descriptions for the status codes (also validation-linked), which does not pull over to the SO Entry since the link is between the two UDTs not with the S/O.

So I've been attempting to use my limited knowledge of DFDM in an attempt to trick Sage into grabbing this information anyways, but have always come up unsuccessful. I feel the issue is that the BUSOBJ from the 2nd UDT isn't loaded into memory when attempting to use this 'tag' property:

In text form:

BUSOBJ=CM_UDTMaint_bus,SO_UDT_CR_STATUSCODES;
UDTTBL=SO_UDT_CR_STATUSCODES;
UDFTBL=SO_UDT_CR_STATUSCODES;
UDFCOL=UDF_DESCRIPTION;
UDFLOCK;
BIND=ALB_UDF_CRDRELNO_UDF_ML_STATUS,UDF_DESCRIPTION$; (Also tried UDF_ML_STATUS)

My hopes is a similar issue with this topic - but instead of loading the UDT BusObj for scripting, load it for the actual session.

For a better visual, I am trying to get the description for this UDF_ML_STATUS field that's located in another UDT:

Which I am aware is not officially supported, hence the reason I called it a 'hack' earlier.

Add your UDF to the SO header table (but not on the panel), and set up a script to refresh that UDF value from the UDT when each record is opened (Post Read).  Then you can have the description, properly linked without any "hack" of the panel settings.

I know this post is old and not sure if anything has changed since its creation, but for me to get the _svc object of UDTMaint to work I had to use:

CM_UDT_SVC

instead of CM_UDTMaint_svc as was listed here.