Skip to Content
0
May 29, 2018 at 01:03 PM

(ODBC-2028) Error When Adding Purchase Order

168 Views

Hello,

I am trying to add a purchase order by DI API. My code is working on my computer but I tried it as an addon on another company that has different data. And it give the error:" No matching records found(ODBC-2028)". Here is a part of my code:

 public void createPOrderFor(int id,
                                    string itemCode,
                                    string itemName,
                                    int qty,
                                    int satisSip,
                                    string cardCode,
                                    string cardName,
                                    string releaseDate)
        {
            SAPbobsCOM.Documents BO_item;
            BO_item = (SAPbobsCOM.Documents)getCompany().GetBusinessObject(SAPbobsCOM.BoObjectTypes.oPurchaseOrders);
            base.doConnectionInfo();
            server = base.server;
            database = base.database;
            user = base.user;
            pass = base.pass;

            string year = releaseDate.Substring(0, 4);
            string month = releaseDate.Substring(4, 2);
            string day = releaseDate.Substring(6, 2);
            releaseDate = year + "-" + month + "-" + day;

            BO_item.Lines.ItemCode = itemCode;            
            BO_item.Lines.ItemDescription = itemName;         
            BO_item.Lines.Quantity = qty;          
            BO_item.Lines.ShipDate = DateTime.Parse(releaseDate);           
            BO_item.Lines.UserFields.Fields.Item("U_SatisSip").Value = satisSip;           
            BO_item.Lines.Add();
            BO_item.Comments = satisSip + " numaralı satış siparişine istinaden";
            BO_item.CardCode = cardCode;
            BO_item.CardName = cardName;           
            BO_item.NumAtCard = "";
            BO_item.Series = 13;//birincil
            //BO_item.Segment -- it is read only.
            BO_item.TaxDate = DateTime.Now;
            BO_item.DocDate = DateTime.Now;
            BO_item.DocDueDate = DateTime.Parse(releaseDate);
            BO_item.SalesPersonCode = 4;//default Hakan Yılmaz
            BO_item.DocumentsOwner = 4;
            BO_item.DiscountPercent = 0.0;
            BO_item.Address2 = "TURKEY";
            BO_item.Address = "";
            BO_item.TransportationCode = 1;
            BO_item.AgentCode = null;
            BO_item.JournalMemo = "Satınalma siparişleri - " + cardCode;
            BO_item.GroupNumber = 1;//net30 
            BO_item.PaymentMethod = null;
            BO_item.Project = null;
            BO_item.UserFields.Fields.Item("U_SatSip").Value = satisSip;
            var retVal = BO_item.Add();
            int errorCode = 0;
            string errMsg = "";
            if (retVal != 0)
            {
                getCompany().GetLastError(out errorCode, out errMsg);
                SAPbouiCOM.Framework.Application.SBO_Application.StatusBar.SetText("Error: " + errMsg , SAPbouiCOM.BoMessageTime.bmt_Long, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
            }