Looping a table while batches enabled

Question

Hi, 
 I want to loop through all my not-registered invoices. 
 What I do (in general) is: 
 dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession);

obj.nMoveFirst(); //To get to the first record 

//Rest of code 
 The problem is that I have batches enable for AP Data Entry, so when trying to do MoveFirst(), I get the error: "A batch number is not set up." 
 Probably means I need to first set the Batch and then to loop it's own invoices. The problem is I want to loop through all the invoices regardless of the batch they are in 
 
 Is there a way to loop through the table even if I have batches enable?

David Speck · Accepted Answer

You can always first loop through active batches for the task using the GL_CompanyActiveBatch_Svc class with a browse filter and then for each batch found, use AP_ManualCheck_bus' SelectBatch method and then loop through each record or you can use AP_ManualCheck_bus' GetResultSets to get the primary key and batch number for each record and split it into an array that you can loop through. Depending on what you are trying to accomplish with the records, like just getting information about them, you can probably get what you need by just using GetResultSets, if you must edit them, then either approach should work to get you what you need to select the correct batch and put the record in an editable state. 
 File Layouts and Program Information - SY_Service (sage.com) 
 
 Advanced GetResultSets() - Business Object Interface - Sage 100 - Sage City Community 
 You can search the forum for more examples of GetResultSets. In is a very useful method and is worth becoming familiar with it.

Sage 100

Looping a table while batches enabled

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING