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();
}
Updated on: 2020-02-14T10:01:47+05:30

532 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements