Skip to Content
0
Oct 21, 2020 at 07:26 AM

Error: [sql server native client 10.0][sql server]invalid column name 'loginstanc'.

77 Views Last edit Oct 21, 2020 at 01:21 PM 3 rev

Hi,

I am having an issue when i add A/R invoice using SDK.

this is the error i am getting "[sql server native client 10.0][sql server]invalid column name 'loginstanc'."

i checked this field in the DB in table OINV and it does exists

i am using SAPbobsCOM v9.0.0.0

SAP B1 9.3 (9.30.100) PL:00 64-bit

any idea why this is happening? and any fix for that?

Thanks

         var arInvoice = (Documents)Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oInvoices);

            arInvoice.DocDate = dmsData.BillingDate;
            arInvoice.CardCode = debtor.CardCode;
            arInvoice.CardName = debtor.CardName;
            arInvoice.DocTotal = (double)dmsData.TotalAmount;
            arInvoice.Comments = dmsData.Remarks;
       
        


            var result = arInvoice.Add();
            if (result == 0)
            {
                return "";
            }
            else
            {
                throw new InvalidOperationException(Company.GetLastErrorDescription());
            }