jepritch Elliot, do you have any suggestions? Thanks!

-Greg

Good morning Greg,

Let me have a look at this today.  I'm not sure the generation of transactions is geared to be scripted but let me see if i can spend some time on this and get back to you.

Thanks!

Good news is this should be relatively easy.  Not sure how you're scripting this (BOI or someother mechanism), but below is a VB Script example of how to invoke the generation itself.  The generation is actually in the same object as the update.  Something like below should work.

oGen = 0
Set oGen=oSession.AsObject(oSession.GetObject("RA_GenerateTransactions_upd"))

' need to set the where clause for the selection, this is typically the range of RMA's
' at minimum it should equate to something true to select everything.
' ie filter = "1=1" <== all RMA's
' ie filter = "RMANo$="+Chr(34)+"0001000"+Chr(34) <== Only for RMANo 1000
' ie filter = "RMANo$>="+Chr(34)+"000001"+Chr(34)+" AND RMANo$<="+Chr(34)+"0001000"+Chr(34) <== For Rma's 1-1000

filter = "1=1"
r = ""
r = oGen.SetWhereClause(filter)

retVal = 0
retVal = oGen.GenerateTransactions()

That's perfect! Thanks for your help!