avolpe - I think you need to pad the key value segments with NULLs

try: (btw, I haven't tried this but should work)

sBill = "2480-8-50"

sBnumRev = sBill & String(30 - Len(sBill), Chr(0)) & "000"

retVal = oSession.InvokeProgram("BM_BillInquiry_ui", sBnumRev)

Hope this helps

Elliott

Getting closer for sure! Now its saying the revision is required.

 

I think something must be getting lost on the call using Invoke Program. (likely the nulls are getting stripped or something)

You could try something like:

Set oBillInqUI = oSession.AsObject(oSession.GetObject("BM_BillInquiry_ui")

retVal = oBillInqUI.Process(sBillNumRev)

Does that work for you?  It's a little different in that it won't be in it's own session, it'll be modal to what you are doing, but should populate with the proper bill/revision.

Elliott

You could try something like:

Set oBillInqUI = oSession.AsObject(oSession.GetObject("BM_BillInquiry_ui")

retVal = oBillInqUI.Process(sBillNumRev)

Does that work for you?  It's a little different in that it won't be in it's own session, it'll be modal to what you are doing, but should populate with the proper bill/revision.

Elliott

You were on the right track, big help thank you.

This ended up working

sItem = SO_SalesOrderDetail_bus_ItemCode
sRevision = SO_SalesOrderDetail_bus_Revision

set oBMUI = oSession.AsObject(oSession.GetObject("BM_BillInquiry_ui"))
sMsg = sItem & String(30-len(sItem),&H00&) & "000"
retVal = oBMUI.process(sMsg)

Hi avolpe, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short survey