Sage 100

Within the Sales Order ----> Sales Order Entry Module, I am trying to add some customized fields related to "Ship to address" within the button itself. (Shown Below) Is there any way to customize the Panel shown above?

I needed a comment in Time Track Entry for work performed. I added a UDF and was able to post that through to the Job Transaction file in Job Cost. How can I get this to pull into Job Cost billing so it can print on the invoice? I can't find any way to…

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…

Having trouble pinpointing why my script is not ending when a string of text is found in a search string. I am searching in this text string "customer picked up in CS 10/31" for "picked up", I see in the trace window I am getting the full string, I wasn…

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…

I'm just trying to print, or at least view, a list of all of our UDF's from the UDF and Table Maintenance. I'm getting the dreaded error #65: Window element does not exist or already exists:CM_UDFMaintenanceListing_rpt. Tried renaming the existing file…

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

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…

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…

We would like to add a field for Total Last Cost on the Sales Order Entry screen. Can this be done?

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.

we use a external BOI to maintain sales order memo, to validate attachment file path is valid, below script works for all other memo fields except Attachment. Does SetValue not work on field Attachment? retChk(oSS.nSetDate("S/O", Today.ToString("yyyyMMdd…

So I was asked to increase the size of the item code and PO# fields. I know from previous question you can't change the standard out of the box fields you would need to create a UDF. However, I don't see how you can swap those standard fields for the…

in Sage 100 customer maintenance how can we designate customers as distributors? we need this information for tax, insurance, reporting purposes. we can't rely on resale certificates due to the nature of our products.

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!

Can you only add UDF fields to a panel... I wanted to add an existing field to a PO panel but don't see how to do this.

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.

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…

we add a UDF UDF_STATUS_UPDATE in both SO_SalesOrderHeader and PO_PurchaseOrderHeader table to track order fulfill status. when change this order fulfill status in sales order, we want all PO generated from this sales order same UDF fulfill status get…

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…

Customer has been running the "JT" version of Production Management for a couple years, and makes use of UDF's in JT tables. Upgrading them to v2023, and the "PM" version of Production Management, the converted data is missing all the UDF's and the…

Trying to brainstorm possible options for this specific problem we have. In our business we have file names for embroidered logos (roughly 50k files maybe more), right now users have free range on if they type a file name in the description field of a…

Hi All When I am creating a new customer, depending on custdiv, I need to initialize certain field, like custtype, pricelevel, etc. What kind of event would I use? Column event does not have CustDiv. In post-write or pr-write event it did not work.…

My script is on a table-pre-write on the PO_ReceiptDetail table. I've used the debug window to identify the area where the script is giving trouble, sometimes the script does not write and update the sales order. From what I can see the script should…

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?