Duplicating a found set of invoices

[Ron Cates]

Hi all,

I have a found set of invoices that I need to duplicate. I would like to loop through the found set and create a duplicate record for each invoice then set a couple fields before moving on to the next one. Of course I realise it isn't as simple as looping through and duplicating because once the first duplicate record is created it becomes the last record in the found set and the script then exits the loop (all the better of course, otherwise it would get stuck in an infinite loop).

So, Can anyone tell me what the best techniqe for doing this would be?

Thanks

Ron

[LaurenKuhlman]

Perform Find

Set a $counter = Get ( FoundCount )

Loop

Exit Loop If ( $counter = 0 )

Go to Record $counter

Duplicate Record

Omit Record

Set Variable $counter - 1

End Loop

[Ron Cates]

Beautiful!! Thank you very much. I will let you know how it works out.

[Ron Cates]

Worked perfect!! You Rock!!