Sequence Number Assigning to invoice..

[ray.wurlod]

Show us precisely what you did with stage variables. An approach based on stage variables can certainly work, provided your data appear sorted as in your example here. You need stage variables to "remember" Inv and RecType from the previous row, others to detect whether there's been an change in RecType and Inv, and others to perform the conditional incrementing logic.

[chulett]

http://www.dsxchange.com/viewtopic.php?t=112975