Sage 100

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?

How come nGetResultSets doesn't want to return the InvoiceAmounts in this situation? It just returns a bunch of empty strings. Can nGetResultSets not return a decimal column as retItems or retJunk? Below is what I am trying to do. My InvoiceNos return…