Sage 100

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…

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…

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?

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…

We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?

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…

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions. One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…

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…

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…

Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help. Ctype = "" retVal = oBusObj.GetValue("CustomerType$", Ctype) If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…

Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable? For example, the Unit Cost / Price definition in the Sage Help has this note: " The transaction type selected in the Transaction…

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…

New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

Does anyone know if you can display the billto customer # in the main screen in customer maintenance on the sold to?

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…

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…

I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…

if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…

From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…

I'm new to these products and a bit intimidated by the extensive documentation. Before I waste a lot of time trying to make a change to a production system work correctly, I'd appreciate a simple answer: Is what I want to do possible with these products…

We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.

I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…