Sage 100

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…

I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution. That will work for invoices being created now. What would be the best way to update existing…

Hi Community, We have just upgraded a customer from V2015 Standard to V2020.1 Advanced and I have noticed that the UDFs in the selection grid on reports are no longer in alphabetical order - we have a couple of UDFs (12) but in the selection grid without…

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…

Recently upgraded client to v2019 Adv. They wanted some UDF's cleaned up and I am seeing these fields from the report on older tables that are no longer available. How can I clean these up so they do not show on the report anymore? The report I am referring…

I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…

I am trying to update a UDF in Purchase Order entry lines during a receipt of goods. The issue I am having is that the purchase order record is locked while a receipt of goods / invoice records exist referencing the purchase order. Here is the code I…