Sage 100

With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…

Is there a way to setup a UDF so that when the Copy From button is used on a record to copy values from an existing record to a new record that the UDF field value is not copied? For example, in Inventory Management, if we have a UDF field to store…

We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?

I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail. The Code field appears from the table but i cannot select it. what needs to be changed? UDT AP Invoice Detail UDF in AP Thanks for your assistance…

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…

Can anyone help, I test it for long time, doesn't work retVal=0 Ppat="" Ppatdesc="" Ppatdesc1="CREDIT HOLD" Ppatdesc2="REDUCE CREDIT LIMIT" Ppatdesc3="NEW CUSTOMER OR SPECIAL ALERT" Ppatdesc4="GOOD STATUS" retVal = oBusObj.GetValue("UDF_PAYMENT_PATTERN…

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…

New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

Is it possible to have a locked UDF field display its contents in red, possibly via a DFDM property change? I've attempted (without success thus far) to update the color via the DFDM Nomads_Color property to 01FF which appears to be the hex code for…

In which table should I place a UDF for actual freight expense to compare against the freight billed to a customer? We use StarShip Online but do not write back actual freight charges to the Shipping Data Entry Freight Amount field since we bill them…

Hello, I am attempting to create an audit table that will show the value of the filed before and after a change, but I can't seem to find anything online that shows how to do that. Would I need to run one pre-write script to capture the value first…

We are being forced to integrate with two other systems that don't allow 3 character country codes. Therefore, I have been forced to add 2 char country codes to our country table. Using the alt-country code field was not an option for these integrations…

I have created a "description" field to hold the description of the unit of measure as the 4 letter unit is often pretty cryptic. I had no problem creating it, but when I go to add the field to the panel (Dmain), I cannot add my UDF. The add field is…

I have added a UDF to our Sage 100 SO_SalesOrderHeader table. I added it to the screen and set it up to print on the packing slip (uses the same table). When I try to add it to a report (which again has the same table) its not on the list to select from…

With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…

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…

We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

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…

A client asked me to create User Defined fields and add them to their AR Customer Maintenance screen. When I accessed the DMAIN panel this is what I see. I stopped immediately because this looks like corruption to me. I have never seen anything like this…

Hi, Every time I try to create a UDF in Sales Order Details, I get the error message that SO_SalesOrderDetails in is use.....Make sure all users are out... I am very familiar with this message, but only when people are actually logged in. I've terminated…

A button script has been working for 8 years that writes 4 string UDF's and the TransactionDate started failing immediately after upgrading to 2020. After getting successful returns on all the SetValue statements, the Write fails (retVal = 0). The IM…

We have a client that would like to add the Weight field that is shown on the Main tab in Item Maintenance to a new tab he created. I am not asking to move the field from the Main tab, just repeat it on the new tab. I thought perhaps to create a UDF field…

I'm attempting to make a UDF that will appear on the 8. Cost Detail Tab in Item Maintenance and be available to report on for some government requirements. I've been able to add the UDF in IM_Transaction Tier Distribution Entry, PO_Receipt Tier Distribution…

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…

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…