Sage 100

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 was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.

I would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report. Using UDF links and customize the Crystal AR Aging Report.

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…

I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory. I've tried several links and can't seem to get the correct combination. Can someone…

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 am trying to add a UDF with a one to many relationship with an inventory item. I created a UDT to store the values of the UDF that will be associated with the items. Then I created a second UDT to store the relationship between the items and the UDF…

Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…

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…

When adding a particular SO Header UDF to the report I get this error message. "data provider or other service returned an E_FAIL status" I have reviewed all the data in the field and there are no unusual characters it's all numbers. the report…

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…

We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…

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, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry? The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…

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…

Hi, I have a UDF created in Inventory Management in tab 8. Web, which is called UPC, so I can add this information into Sage 100. I'm wondering if there's a way to bring this UDF for UPC from the tab in Inventory Management to the Sales Order module…

I have a UDF in Customer Maintenance that is validated against a UDT. The UDT has 3 values: NoCal, SoCal, and Texas When I select the UDF in Customer Maintenance, the UDF value is stored as upper case. Is there any way to store the UDF value as…

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…

Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…

Is there a way to get Kit Component Items to show on Item Maintenance panel? (If the item is a kit)

Hi... I want to create a new tab on the customer maintenance screen with each of the 50 states listed. Each customer may have one or many of the states listed checked. My question is will I need to create a user defined field for each state, which is…

Sage 100 version 2017

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

Hi Forum, I cannot seem to find a way to update the AP_InvoiceRegisterWork table and AP_InvoiceRegister.upd. We have a Vendor that need to print checks to with different Names. One vendor hundreds of different Names the invoices need to be updated…

I created this script for sales order detail lines that works if I key a number into the backordered quantity field but does not work if I tab past the field with no entry. tmpQtyOrd = 0 tmpQtyBkOrd = 0 retVal = oBusObj.GetValue("QuantityOrdered…