Sage 100

Our Item Masters contain 130k plus items.

Typically I tell our sales people to enter a "z" in the item code field, then press F2. This quickly brings up the

items in the item master which start with "z".

Otherwise Sage attempts to…

Getting stuck on this script, I've tried a column post val on the qty received and a table post read.  Both are getting stuck at the same point, on the first "retVal=oSOLines.MoveNext()", should it be MoveFirst?

Dim sPurchaseOrderNo
Dim…

v2022.2 Standard, Column pre-validate on InvoiceNo, as the only script active on the table.

Basically the script checks if the user is allowed to enter an InvoiceNo, and does a SetError (when a specific Role permission is active).

The column pre-validate…

I'm trying to use the SetBrowseFilter method with an external script using the AR_Customer_ui object. and the InvokeLookup method. I need to show only Active Customers with a SortField set to a value. I can't seem to find any documentation for the SetBrowseFilter…

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…

I want to do a search the excludes any Job that starts with the letter "C".

Is there a carrot or symbol that can be used as a wild card to maybe Not Equal to C* to filter them out?

As shown in the picture below I have some jobs that start with…

I'm working on a button script where I'll be looping through multiple Sales Orders, and sometimes an SO will be locked (e.g. when it has an invoice being processed).

oSalesOrder = oSession.GetObject("SO_SalesOrder_bus")
Set oSalesOrder = oSession…

A customer has asked for a way to update pricing on 1000's of SO, for some planned pricing updates they working on.  My idea was to have a button script to loop through all SO, and all lines on each SO, triggering the Sage logic to calculate each line…

Is it possible to search within the SO Detail "Comment" field for a particular word to post-write a check mark in a UDF field?

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?

Writing a script (with role check), where I want to prevent a user from editing a customer's credit limit (ideally preventing a non-admin order entry person, with Customer Maintenance access, from raising a credit limit... without going through an approval…

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…

I have a script on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…

FYI,
I've just gone through a new upgrade to v2021.1 on the weekend with strange errors opening Invoice/Shipping entry, and again after choosing an SO.  Sage support pointed me at *ESC to isolate the issue to scripting, and I found the problems to…

I'm starting a script for account segment substitution (CoGS / Sales accounts on specific SO lines), and before I start testing different methods for getting the formatted Account number based on the key values (ChildHandle, open a new object...) I'm…

Are for each loops allowed in BOI vbscript?

I have this code in a BOI script (SO Header, PreWrite)...

...
Set oPayment = oSession.AsObject(oBusObj.PaymentObj)
retVal = oPayment.GetValue("CreditCardAuthorizationNo$", sAuthNo)
retVal = oPayment.GetValue("AuthorizationDate$", sAuthDate)
retVal…

We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…

I have a script in SO Header where I open Customer Maintenance, and I want to pass a Storage Var to that Customer Maintenance object (to change what happens in an AR_Customer post read script), but the values are not transmitted.

To test, I created a…

A customer has asked for an easy way to change the invoice date for an entire batch (without using VI).  What I am trying is a button script run from SO Invoice Entry, opening a new object, grabbing the ModuleDate, scrolling through the batch and setting…

I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI.  I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…

Hello,

I have two PO's and one line detail for each. I'm trying to add two lines to the Receipt of Invoice screen using BOI, using Sage 100 v2020 multiple POs. This is a new functionality with their cloud license. I get the header by setting Purchase…

Our developers have written an interface to pull and push AR customer data.  Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below.  Any ideas?

using System;
using System.Collections.…