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.
Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation.
Did they forget that dates are usually paired…
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…
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 created an SY UDT, and then I tried to add the field from this UDT into the AR_Customer table. I don't see the UDF from that SY UDT as a Data Source under the AR_Customer_Bus. Is there one more step to link them before I'm able to select the…
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…
Created a UDT for customer type and now trying to set validation on CustomerType field in AR_Customer to my UDT for customer type. It will only let me do this if I choose all users, all companies in advanced field settings. I don't want this validation…
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
Hello,
In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…
Hello,
I have a UDF/script combo on sales order entry which requires the user to input a customer of type "A" into the UDF if the customer placing the order is of type "B". The values allowed are located on a UDT which I use the UDF to validate against…
In general is there a maximum number of UDF's per table.
And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
I've got a UDT that isn't displaying in the list under user-defined field and table maintenance. It used to display but has since disappeared. I wonder if anyone knows some tricks to refresh the menu system?
The table I'm looking for is called SY So…
I've created a custom script to record changes made to the order status of a sales order through a generic shadow table format but I'm having issues getting the time to record properly in the UDF_TIME field specifically. I'm not sure what could be causing…
During our shipping process we scan all inventory from the pick sheet into shipping data entry. I like to create a process that using a UDF will track that the item the was scanned into shipping data entry.
Example:
Item A quantity 2 Item A we scan…
Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…
I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…
I want to link data in a detail line of PO Material Requisition Issue Entry through to IM_ItemTransactionHistory.
But when I try to pull a data value into the IM_TransactionPosting table, none of the Business Object sources listed are from the PO Mat…
I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…
I want to add field [Category4] from CI_Item to the Item Maintenance, but can not seem to find it in Custom Office User-Defined Field and table Maintenance. Can anybody help with that? Thanks.
I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…
