• 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…
  • UDF validation to another UDT

    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…
  • Can I add User-Defined Table to Work Order module?

    Does Work Order module allow UDT? I tried and it seems Work Order module is the only module which doesn't allow me to add UDT. Is it the case? Thanks.
  • PO Detail link to SO Detail

    I see where you can source data from the SO Detail to the PO Detail but not seeing anything for the other way around. What would be the best method to get the data from a UDF on the PO Detail lines to the same named UDF on the SO Detail lines?
  • Crystal Report Field Edited Date

    I have two udf’s that are populated on the SO_SoDetail table, they are also printing on our pick ticket. How can I capture a date time stamp value for when that udf is edited (it’s a numerical value) and display it on the crystal report for the pick sheet…
  • Possible to change text color of a locked UDF?

    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…
  • User Defined Table Magnifying Glass

    Hello, We have added a UDT with a list of fees, and we are wanting the magnifying glass icon to show up so the user can click on it and see the list of options. Currently the magnifying glass is not showing up. Is there a trick to getting this functionality…
  • Script to blank out a Date field

    Hi Is there a way to set a Date field to Blank? On a detail form when entering a new line the custom date field is blank. They must enter a date within a certain range. This range set on the Header level. The script works fine for checking and sending…
  • Script: GL Lookup by Account #, not Key

    I am writing a script, and need to lookup a GL AccountKey when I know the GL Account #. Scenario : I am changing a the GL code on a line item on a Sales Order based on inputs from user (custom fields on the line item). If they enter Item A, UDF1:…
  • UDF for Actual Freight Expense

    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…
  • Add a Custom UDF for Inventory Price Change

    Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?
  • Add Field in UDT to Employee Master Panel

    Hi Everyone, I have added a UDT to Payroll which contains a list of supervisors. The key is the employee number with additional first name and last name fields in the table. The employee number shows up when I create a UDF in the Employee Master and…
  • Link PO Detail to SO Detail

    Trying to update the SO Detail line after a receipt of goods is updated for a PO. I have this script set in PO Detail on a table-postwrite but the first time I ran it the SO udf did not update. Does the PO Detail table get updated after a receipt of goods…
  • Sales Order Entry screen Order Type

    Hello, We wanted to change the default Order Type from Standard to Quote. I went into Customizer found field but Insert List on Main Tab is greyed out and states Program Defined plus Options tab Default field is also greyed out.. So it seems I'm blocked…
  • 'Table' Does not have correct permissions, when running script

    Hi, I made a script in Sales Order Entry that loops thru the lines and changes a few fields based on the previous lines (trying to group lines together for a report). I'm getting an error now and after a lot of troubleshooting I realized that I only…