Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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.Generic;…
Hello,
I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query.
This needs to be run on the Client…
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…
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.
I would like a piece of code to be executed when something happens in MAS.
Primarily when a sales order is created, and invoiced. Also when an AR_Invoice is created.
Is there a way to do this using the BOI?
Hello All,
I'm trying to create a script that would look up the current customer by name in another company code and insert the corresponding customer number into a UDF. Is there code that could be used to run lines of a user defined script on another…