Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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.…
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…
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…
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…
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…
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…