duplicate orders

[jsaltzman]

i need to set up a script that will show me which orders have the same title. I have no idea how i would do that.

I have two companies that give me orders to process and sometimes a book will sell with the first company and that same book will sell with the second company. i simply want to mark the orders that have already been sold for the day. Any ideas?

[Razumovsky]

If the titles are unique (unless duplicated), you could do this without a script.

create a self join relationship title::title

create a calc "DupCalc"

case(Count(title::title)>1, "Duplicate", "")

[Ugo DI LUCA]

Hi,

that have already been sold for the day

So you need to "concanate" the book_id and the day within a calc, then use Raz calc changing the selfjoin to

Concanate::Concanate...

Depending on the structure of your files (line item shared for both PO and invoices), you would need to change it again to only see the books attached to a PO.

But I still agree with Razumovsky....no need for a script here.