• UDF validation to another UDT

    Hi, I want to add a UDF in the JT_Employee table and within the UDF maintenance I see i should be able to use a UDT to limit the options being chosen. When I select the UDT validation button, a few UTDs are available but not the one I want. How do I…
  • Add a Custom UDF for Inventory Price Change

    Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?
  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
  • Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
  • Possible to add editable UDFs to Invoice History?

    Hello, Our accounting team inquired about the possibility of making the "Comment" field on Sales Orders editable even after they are put into the history table.I do not believe this is possible, but was hoping that it IS possible to add a NEW "Comments…
  • Add UDF to Work Table

    I'm trying to pass a field from PO Receipt Details to the PO_ReceiptOfGoodsInvoiceWrk table which is used to generate the Receipt of Goods Register. We have added a field in PO Details which is passed to Receipt Details which I want to pass to this Work…
  • Sage 100 ERP How-to: User-defined fields (UDF)

    In a first of a series of How to blog posts, we take a look at how you can create user-defined fields or UDFs. Why would you want to create a UDF? Well, UDFs can be used to record information about customers, vendors or any other data that may not…