Sage 100

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!

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…

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 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?

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…

Upon Checking a Checkbox in Sales Order Line Item It will Make a line item filed required

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…

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…

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…

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…

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…

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…

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.

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?

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…

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…

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…

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…

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:…

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…

Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

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…

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…

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…

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…