• Read validation configuration of UDF

    Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…
  • DFDM Modifications to Allow UDT Field Lookups

    When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
  • Crystal Report Feeding DM2 Returning Blank

    Hello, I am trying to write a crystal report formula that does the following: If an amended PO number exists in the UDF_AMENDED_PO field, then return UDF_AMENDED_PO, if not, return CustomerPONo When I test this, when UDF_PO_NO is NULL, it returns…
  • User Defined Scripts to populate a UDF

    I'm creating a script to auto-populate an SO_Detail UDF (UDF_SHIP_REF1) so that I can pass data to StarShip. The goal is to concatenate the item number with the Customer PO Number (i.e. "3131000 / 123456789" ) I have developed a more detailed script…
  • UDF Field Not always showing for reporting

    I have added a UDF to our Sage 100 SO_SalesOrderHeader table. I added it to the screen and set it up to print on the packing slip (uses the same table). When I try to add it to a report (which again has the same table) its not on the list to select from…
  • Alter Report Sort in Crystal

    My customer wants to alter the Accounts Receivable Aged Invoice Report to sort on the Salesperson number listed in the AR_CUSTOMER (name sp?) table rather than the salesperson number in the AR_AgedInvoiceRportWrk table which is the same number that is…
  • List of UDF columns

    I want to get a list of all the UDF columns in a particular table eg. AR_Customer. Is there a way to get this list? There is a method which returns a list of all the columns in any particular table but I cannot differentiate between the custom ones…