I'm trying to pull InvoiceNo's that shipped on a particular day.
I'm using SO_ShippingHistoryReport_rpt but I'm not getting any results back for a day that has records.
I need a fresh set of eyes and more experience to help me with what I'm missing? Any takers?
pvx.InvokeMethod("Init", sagePath); using (DispatchObject oSS = new DispatchObject(pvx.InvokeMethod("NewObject", "SY_Session"))) { #region Sage Set Company oSS.InvokeMethod("nSetUser", sageUser, sagePass); oSS.InvokeMethod("nSetCompany", sageCompany); oSS.InvokeMethod("nSetDate", "S/O", Helper.SageDateNow()); oSS.InvokeMethod("nSetModule", "S/O"); #endregion int TaskID = (int)oSS.InvokeMethod("nLookupTask", "SO_ShippingHistoryInquiry_ui"); oSS.InvokeMethod("nSetProgram", TaskID); using (DispatchObject dispObj = new DispatchObject(pvx.InvokeMethod("NewObject", "SO_ShippingHistoryReport_rpt", oSS.GetObject()))) { string filter = @"ShipDate$ = """+ sageDate +@""""; string columns = @"InvoiceNo$ +""|""+ HeaderSeqNo$ +""|""+ CustomerPONo$ +""|""+ SalesOrderNo$ +""|""+ CustomerNo$ "; object[] getResultSetParams = new object[] { columns, // return columns "InvoiceNo$", // key column "", "", filter, // filter "", "" }; dispObj.InvokeMethodByRef("nGetResultSets", getResultSetParams); getResultSetParams.Dump("results");