Sage 100

We have Sage 100c 2022 with Operations Management. I would like to add a button to the Work Ticket Printing screen that replaces the Print button, launches a script to cycle through the JT_WorkTicketAttachments file for all attachments for the current…

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…

Hi guys, To interactively approve or cancel an entered value by a user, is there a way to make it work just in PreValidation event? I'm working in SO_SalesOrderHeader The basic logic flow is as follows User enters a value in a ShipVia Script…

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

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…

Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?

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

I actually kind of figured that this would have been asked a few times, but my search attempt wasn't all that successful. The only somewhat related topic was Script to Select File , but the script I found here only displayed server-side files since it…

I have a button script that successfully changes the price level on SO Lines but the changes aren't visible in the grid until either moving to another tab and then back to Lines or closing and reopening the sales order. Is there a way to refresh the…

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…

Hi, I made a script in Sales Order Entry that loops thru the lines and changes a few fields based on the previous lines (trying to group lines together for a report). I'm getting an error now and after a lot of troubleshooting I realized that I only…

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…

Hi, I'm trying to write a script to find the Contact Code using the Confirm To in the Sales Order header so that I can populate some user defined fields in the contact code maintenance into the sales order header. I have this so far, but it's not finding…

Hello, I'm trying to convert numbers entered into a text field to an integer value. I have tried: number(textfield) CInt(textfield) but nothing seems to work. Any ideas? Thanks, Kevin

Hi, I am trying to create a script that puts the focus back on the GL account field when specific GL accounts are selected by user. So, when a user enters a GL account with a UDF_RESTRICTED value of Y, then Sage will focus back on the GL account and not…

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…

I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?

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…

I have a working event script tied to S/O detail that fires on post validation of quantity ordered. The script automatically creates a BOM Production Entry for the item entered, updates the production entry and updates the GL DTR. The problem I'm having…

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?