Skip to Content
0
Former Member
Jun 30, 2009 at 02:43 AM

Data cannot be empty in one of the tables Doc1, Doc3, Doc10. [IGN1.LineNum

63 Views

Doing automatic batch receipt.. and I am getting this. Here the code I am using. Not sure where it went wrong.

Never seen this message before.

 
   ogrdoc = (SAPbobsCOM.Documents)(Global.ocompany.GetBusinessObject  (SAPbobsCOM.BoObjectTypes.oInventoryGenEntry));
                ogrdoc.Reference2 = "Test";
                ogidoc.Lines.ItemCode = Global.breakorecord.Fields.Item("itemcode").Value.ToString();
                ogidoc.Lines.Quantity = System.Convert.ToDouble(Global.breakorecord.Fields.Item("quantity").Value.ToString());
                if (System.Convert.ToDouble(Global.breakorecord.Fields.Item("price").Value.ToString()) != 0)
                    ogidoc.Lines.Price = System.Convert.ToDouble(Global.breakorecord.Fields.Item("price").Value.ToString());
                whscode = Global.breakorecord.Fields.Item("whscode").Value.ToString();
                ogidoc.Lines.WarehouseCode = whscode.ToString();
                for(int y = 0; y<testqty; y++)
                    {
                        if (batchcount > 0)
                            ogidoc.Lines.BatchNumbers.Add();
                        ogidoc.Lines.BatchNumbers.BatchNumber = newbatch.newbatcgen(1).ToString();
                        ogrdoc.Lines.BatchNumbers.SetCurrentLine(0);
                        ogidoc.Lines.BatchNumbers.Quantity = System.Convert.ToDouble(qtyperin.ToString());
                        ogrdoc.Lines.BatchNumbers.ManufacturerSerialNumber = Global.breakorecord.Fields.Item("suppserial").Value.ToString();
                        ogrdoc.Lines.BatchNumbers.InternalSerialNumber = Global.breakorecord.Fields.Item("refernceno").Value.ToString();
                        if (Global.breakorecord.Fields.Item("expdate").Value.ToString() != "")
                            ogidoc.Lines.BatchNumbers.ExpiryDate = System.Convert.ToDateTime(Global.breakorecord.Fields.Item("expdate").Value.ToString());
                        
                        
                        batchcount++;
                    }
ogrdoc.Add()

Edited by: Bo Peng on Jun 30, 2009 4:48 AM

Edited by: Bo Peng on Jun 30, 2009 4:49 AM