Sage 100

I'm receiving a cryptic error stating "IM_ItemWarehouse" does not have correct permissions when I do a SetKeyValue and Find via IM_ItemWarehouse_bus (and _svc). Code is below. I've also tried using a SetBrowseFilter and that works until it reaches the…

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…

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…

From a BOI script I would like to select individual orders so that a type "4" record will be added to "SO_SalesOrderPrint" table. The method "SelectOrder" calls for two separated string parameters: "hdrRec$" and "dtrRec$". This is confusing. Why would…

I have created a "description" field to hold the description of the unit of measure as the 4 letter unit is often pretty cryptic. I had no problem creating it, but when I go to add the field to the panel (Dmain), I cannot add my UDF. The add field is…

I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution. That will work for invoices being created now. What would be the best way to update existing…

With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…

Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?

Huge thanks to David Speck for your code and your expertise. I've got a script that works well for printing all SOs, but I'm trying to filter it down using a UDF Date Parameter ( UDF_Delivery_By) we have in SO Printing. I'm certain I have my syntax…

Hello, I'm getting the error below indicating the module (S/O), company key (0000004), and the UI. I'm hoping there's something obviously amiss with the code below and that another set of eyes will spot the error. And a huge thanks to David Speck…

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…

I've used DeactivateProcedure on scripts running within Sage, but not on external scripts. I'm working on a script that requires me to disable procedures in SO Entry. I've tried a few variations, but I'm getting "Object doesn't support this property or…

I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

I've recently created some custom versions of reports (AR Aged Invoice Report, for example) and set them as default for all users, but for some users it still defaults to the STANDARD report every time. It is set to the default report via the checkbox…

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…

I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried: In Crystal Reports designer, I created…

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…

I'm working on a BOI script to create Manual Check entries from a CSV. Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…

We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit). The client will have an issue with the Freight amount not saving on the Total tab. I will go in and recreate the customized…

A client asked me to create User Defined fields and add them to their AR Customer Maintenance screen. When I accessed the DMAIN panel this is what I see. I stopped immediately because this looks like corruption to me. I have never seen anything like this…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…