Sage 100

Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…

Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

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…

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…

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

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…

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…

We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…

We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…

Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…

We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…

Experts, I have a button script that generates an item code. The generated item code does not yet exist in CI_Item. The desired behavior is that I can populate the new ItemCode on a new line in SO Entry and from there default Sage logic takes over …

Running Sage 100 Advanced 2018: I have created a UDT to hold key information needed for our accounts by zip code, and a Button Script to look up the data by zip code, populate certain fields, then show a message to the user. I can run the script just…

Experts, I am using the button script below to open Customer History by Period from a Sales Order line (Sage has this button in Item Maintenance on the History tab). It works. It opens properly for the item. But there is a secondary selection criterion…

We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more. Have you built or found an Order Manager…

Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…

I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?

Is there a way to block items from being invoiced to countries that do not accept those items? We are a large manufacturing company with several distributors, some times its not so easy to catch items on their purchase orders, that they're not allowed…

I have a script in Sales Order Entry triggered from a new 'Accept' button that searches for other open orders for the same customer with at least one line item that is not out-of-stock (new UDF I have three references to "SO_SalesOrder_bus" I use oBusObj…

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ