• Misc Item and AP vendor No Link

    Have a request to add the vendor number to the Misc Item Maint screen so they can choose an AP vendor for the non inventory item. Other than creating a UDT which we'd import all the AP vendors into and then link to UDF...is there an easier way where we…
  • Work Order Traveler adding a UDT link

    I've created a UDT with 2 fields, ItemNumber (The key) and Description (A multiline text field). I want to link the ItemNumber to the ItemBillNumber of a work order and display the Description on the Work Order Traveler. I've added the UDT table in…
  • Find the largest value in a field of a table

    Hi everyone, Does anyone know the fastest way to find the largest value in a number field using User-Defined Script/VBS? Background : I'm working on creating a unique ID, like GTIN/UPC, for each item code as the item codes are generated. To get things…
  • User Defined Script on Close

    Is there a way to trigger a User Defined Script when a Sales Order is closed without any changes being made to it?
  • User defined table with more than 100 records - Show More Button? Possible bug?

    Sage 100 Advanced I have a client with a UDT that has about 250 records in it. When you go to user defined table maintenance it will only show the first 99 records. Per the knowledgebase - Description A user-defined table contains…