Good day,
Please assist,
I have C# code to export data from my local DB to Sage. When inserting invoice headers I get "Object reference not set to an instance of an object"
I am fairly new to project and Never worked on sage before. I have a very narrow knowledge.
See my code below. On the green highlighted that is where the error occurs.
public override void InsertInvoiceHeader()
{
PORCP1header.Order = 1;
PORCP1header.Order = 0;
PORCP1headerFields.FieldByName("RCPHSEQ").SetValue("0", false); // Receipt Sequence Key
PORCP1header.Init();
PORCP1header.Order = 1;
PORCP1detail1.RecordClear();
PORCP1detail3.RecordClear();
PORCP1detail4.RecordClear();
PORCP1detail6.Init();
PORCP1detail2.Init();
sRcpSeq = PORCP1headerFields.FieldByName("RCPHSEQ").Value.ToString();
PORCP1headerFields.FieldByName("RCPNUMBER").SetValue(base.dsHeaders.Tables[0].Rows[base.counterIH]["RCPNUMBER"].ToString(), true); // RECEIPT NUMBER
PORCP1headerFields.FieldByName("VDCODE").SetValue(base.dsHeaders.Tables[0].Rows[base.counterIH]["VDCODE"].ToString(), true); // VENDOR
PORCP1headerFields.FieldByName("PROCESSCMD").SetValue("1", false); // Process Command
PORCP1header.Process();
PORCP1headerFields.FieldByName("DATE").SetValue(base.dsHeaders.Tables[0].Rows[base.counterIH]["DATE"].ToString(), true); // DATE
PORCP1headerFields.FieldByName("REFERENCE").SetValue(base.dsHeaders.Tables[0].Rows[base.counterIH]["REFERENCE"].ToString(), true); // REFERENCE
PORCP1headerFields.FieldByName("DESCRIPTIO").SetValue(base.dsHeaders.Tables[0].Rows[base.counterIH]["DESCRIPTIO"].ToString(), true); // DESCRIPTION
}