I am just spit balling here. Think we are close.
DING DING DING Worked on the first swing! But which line was changed that made the difference? Was joining through Db.RMAHead instead of straight from ttRMADtl to Db.HDCase what did it?
I was thinking that the temp tables didn’t have all of the information the first time. That is why I went to the db.RMAHead with the last function. Granted I am not an Epicor guy, so I am not certain of what is going on the wire with the call.
Now you can have some fun cleaning up the variable names. lol
That makes sense. Thanks for everything!