AR_InvoiceHistoryInquiry - Lookup by InvoiceNo

Question

I'm trying to set invoice object to a single record and not having much luck. What I'm trying: 
 oSS.nSetProgram(oSS.nLookupTask("AR_InvoiceHistoryInquiry_ui"))
	Dim oInvoices As Object = oScript.NewObject("AR_InvoiceHistoryInquiry_svc", oSS)
	oInvoices.nSetKeyValue("InvoiceType$", "IN")
	oInvoices.nSetKeyValue("InvoiceNo$", "0259999")
	ret = oInvoices.nFind() 
 oInvoices.sLastErrorMsg returns: "The 0259999 is invalid." 
 Here is some columns pulled for that invoice using nGetResultSets: 
 0259999|0140024|20191214|0000000017|John Doe|IN 
 I've also tried: 
 oInvoices.nSetIndex("kPRIMARY")
oInvoices.nFind("0259999+IN")
'oInvoices.nFind("0259999IN") 
 Many thanks -Ken

David Speck · Accepted Answer

If you look at http://help-sage100.na.sage.com/2019/FLOR/index.htm#File_Layouts/Accounts_Receivable/AR_InvoiceHistoryHeader.htm%3FTocPath%3DFile%2520Layouts%7CAccounts%2520Receivable%7C_____65 , you'll see that the primary key consists of the InvoiceNo and the HeaderSeqNo. 
 Said HeaderSeqNo is used in every one of the alternate indexes as well. What you might have to do is use SetBrowseFilter and MoveNext until you find the invoice you are after. Alternatively, you could use GetResultSets and return the InvoiceNo and HeaderSeqNo and use them in the SetKeyValue methods or maybe even try combining them in a single SetKey, i can't recall off the top of my head whether or not that will work if the invoice number's length is less than the full length of the fields, have a feeling it won't.

Sage 100

AR_InvoiceHistoryInquiry - Lookup by InvoiceNo

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING