Sage 100

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?

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…

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…

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

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…

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…

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

Why would a Sage 100 2022 Customizer Utility import fail if it is used to copy from a ".M4X" file a P/R UDT, VI jobs, and event script to the same level (Both are Sage 100 Standard 7.10.2.0 and P/R 2.23.0.0) from which it was created?

When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…

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…

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

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…

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…

When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…