Sage 100

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

I'm trying to find the last unit cost for a warehouse in Sales Order entry. Sage defaults to the last unit cost for all warehouses. I'm getting a not found from this code. I don't know the GROUPSORT. If oSession.CompanyCode = "TST" Then retval = oSession…

I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

Hi All, Getting this funky error in method movenext. This script runs through SOs and deletes the ones in a particular range for a particular customer. This is the snippet in question. Any idea what I might have goofed? it seems to work sometimes…

I have 2 sets of GetResultSets that produce different results. Could some please explain to me why these 2 examples of GetResultSet methods return different result sets? I've read some examples, including Advanced GetResultSets() by a Sage developoer…

Tearing my hair out on this one. My goal is to look through detail purchase order detail lines looking for specific inventory items. This is a button script on the Inventory Item Maintenance Screen. Sage 100 2018 Advanced (script is set to run on…

How do you get number of seat licenses available using Providex ODBC? Meaning, is there a Table that stores the number of users taking a seat? I know there is the sy_console table, but that just shows who has what window/process open.