• Import Mass UDF

    Is there a way to import new UDFs into Sage and to place multiple fields on a panel at one time? I have 50 UDFs that need to be created and I would prefer not to have to manually create and place each one of these fields. Is it possible to mass create…
  • Customize Employee Maintenance Screen with "Tabs"

    Hello, I am hoping to find a way to add a tab (or a few) to the "Employee Maintenance" screen in Sage to allow for more fields to be added under different department specific details. Running Sage 100 Premium 2021 (Sage Version 7.00.2.0) (Payroll…
  • User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • Script for Auto-Updating UDF on Kit Lines

    We have a UDF "Total Quantities" that we use for Kit items to show the total quantities of all the components. Currently, we manually sum the quantities of the component lines and enter this into the UDF "Total Quantity" on the Kit line. I need help…
  • How to have a script on the Sales order Header trigger another script on each detail line?

    I added a new script for all new orders on the sales order detail to fire on the column post validate of "Item Code" My concern is for any old quote that will be changed to an order and will not have the script run, how can i add a script on the Header…
  • How to have Copy From not copy UDF field value

    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…
  • UDF numeric mask ending "-" warns of too many decimal places?

    Create a numeric UDF, and edit the mask to include a trailing "-" (so negative values are accepted and displayed properly). #,###,###.000- This presents a warning about too many decimals / rounding, when I am clearly not exceeding three digit decimal…
  • UDT in AP Invoice detail

    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…
  • Linked UDF Description Field

    How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…
  • Editing a UDF field in SO Invoice Data Entry after going thru Shipping Data Entry.

    I've added a UDF to display the customers shipping acct number in Sales Order Entry. But I've run into an issue where the field can't be edited in SO Invoice Data Entry or Purchase order entry. I can however edit in Shipping Data Entry, but the changes…
  • ADD a UDF table to an existing ALE

    I created a UDF Table with 3 UDF fields in the Inventory Module (see photo). Is it possible to add this UDF table to the Inventory Maint./Inquiry ALE look up on Available Fields section see photo..
  • Error 20 Program SWQUERY

    Have an install of Sage 100 v2022.2 Advanced and trying to link a UDF to a UDT for a lookup. When click on the magnifying glass it errors out with error 20 program SWQUERY Line 0504. It doesn't matter what module I add a UDT or the size that error appears…
  • VI import limits data that can be imported

    I have a VI job that imports in to a UDF associated with the IM_ProductLine table. One of the UDF's; "UDF_LIC_ROY_DUE" is a number masked to two (2) digits. It is intended to hold a number between 1 and 31, representing the day of the month payment…
  • How to print Extended Description on Sales Orders?

    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.
  • Add Order Type to Sales Order Entry

    Is it possible to add a different drop down under Order Type in Sales Order Entry? We are wanting to add a drop down for Retainage and invoice those separately and under a different A/R G/L number. Thank you!
  • Event Script - Get child handle from a child handle?

    Probably not, but just asking. I have a script attached to the SO_SalesOrderDetail object. I'd like to reference a UDF attached to the Product Line of the line's item code - Ideally I would use child handles to avoid the need to give all users view writes…
  • User Defined Table fields

    I have created a user defined table with a key field name and six additional fields. I have added created a field in AR_RepetitiveInvoiceHeader so I can select the key field from my table. Is there a way I can also show the other fields in the table on…
  • How are variables passed to external VBScript files from Sage customizer

    How does Sage 100 actually pass the selected variables from customizer to an external VBscript file when a custom button is clicked? Are environmental variables set or some other method?
  • Creating a Time UDF with Default Value

    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…
  • How to Create a Script to Make UDF Required Property to True/False

    Upon Checking a Checkbox in Sales Order Line Item It will Make a line item filed required
  • replace an empty UDF field to a set value base on condition

    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…
  • Sales Order Packing Slip Modification

    We manuf door panels that are in our inventory module & priced by the inch. We would prefer that the packing slip the stores receive show a quantity of 1 panel vs 159 inches. Keeping in mind the number of inches can change. We don't use BOM module. Does…
  • UDF Not Showing up In DFDM

    I added an UDF to the CI_Item, I can add it through custom office to the additional tab in item maintenance. However, I can not see it in DFDM and when I go to check off the check box I get the error message "The column is not in the IOList.". I've tried…
  • Tracking inventory on a detail level

    We currently have a lot of items in sage, we make and sell the same item in different lengths, we want to start keeping track of the inventory on a detail level, keeping track of what length we have in stock. We cannot create different item code for different…
  • Add UDF to Payroll Earnings Report Selection Criteria

    Hello, I have been asked to add the Labor Code to the Payroll Earnings report selection grid under Employee Last Name and have this field filter the report. I was able to add a UDF to the selection grid and the Earnings report work table. However, I…