Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Selected Reading
Using method getBPLIST() to get list of all orders in SAP Business One
I would suggest using recordset with DI API −
SAPbobsCOM.Recordset rs =
((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset);
rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal
FROM OPOR ORDER BY DocDate ASC");
while (!rs.EoF) {
int DocEntry = rs.Fields.Item("DocEntry").Value;
//OR
DocEntry = rs.Fields.Item(0).Value;
rs.MoveNext();
} Advertisements
