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 a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…

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…

Hello, We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…

Hello, I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…

Hello, I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…