Sage 100

Hello... I created and updated a second BIN location field I wanted to add to the REORDER Maintenance screen. However during customizing screen when I display all fields and UDF's it doesn't show??

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

Hello, I'm creating a UDF field to duplicate a stock field so I can add the udf to the Open Sales Order Report Selection filter area do I need a script to make the ud field equal the stock field. I believe I read a post here that I did if so does anyone…

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…

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…

With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…

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.

I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…

After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…

Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…

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…

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…

I have a customer that would like to pay the 10th of each month for the previous month, in addition to a 2% discount off invoice at time of payment. Is there a way to do this in Sage without making custom field calculations? I am using Sage 100 2022…

Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?

I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab? am I able to put a custom view in here somehow as a shortcut?

I have been looking for the table that is linked in AR Customer maintenance/Ship to. I need to add a UDF field to the ship to screen so when the ship to codes are added and created for a customer we can add another email field we can map to Starship.…

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…

On Sage 100 with Operations Mgmt. (Job Ops) - I would like to look into the use of the field Sales Order number to see how users are using this field. Currently I use this field for misc. items only and for custom reports and I am trying to locate information…

Looking for a better way to show an item has alternate items tied to it, other than just a UDF checkbox on the main tab in Item Maintenance. Can you display the 1st priority item from the IM_Alternate_Item table on the Main tab under Item Maintenance…

Hello all. I'm new here, so I'm stumbling my way through some of this...it has been enlightening to say the least! Here in Oklahoma, agricultural sales tax exemptions expire periodically. For audit purposes, we must maintain records of our customers…

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…

We use Sage 100 - 2022, is there a way to add a "vendor type" to our Accounts payable vendors? We would like to designate what type of vendor, for reporting purposes. I've searched and found instructions for older versions, but not for 2022. Thank you…

I have entered an extended item description for a new item. We have all the options on sales orders to print these out, we print the descriptions daily, but this new item will not print the extended description. Any help would be appreciated.