Customer Forum

Two Duplicate Orders showing in Reports

External Posted: 2011-03-02 13:46

Hi,

I've created a simple report to show all customer orders, with the only criteria being exclude where Status = Draft.

For some orders, it's appearing twice - and one doesn't have and organisation attached, and one does.

Clicking through to either line will arrive at the same ORD, so the system knows it's a single order, yet shows two.

Its not on every order, just 2 out of about 20, but I can't find any similarity between them, or work out what happened (or what we did wrong) for this to happen.

Any help would be appriciated.

Thanks

Adam

doulbe

Workbooks Support Posted: Wed, 02.03.2011 - 22:48

Hi Adam

When you created the report, what object (record) type did you use to start with? Was it Customer Orders or Customer Order Line Items?

Thanks, Support

External Posted: Thu, 03.03.2011 - 10:18

Hi, It was Customer Order. One of them is now showing 3 times?

Thanks,

Adam

Workbooks Support Posted: Thu, 03.03.2011 - 11:08

Hi Adam

Thanks for the update. Without seeing your entire report it's a little difficult to say for sure why you're getting multiple rows for some orders. The most likely explanation is that it's to do with using breadcrumbs to link from information held for one record type to another. If you'd like us to investigate more fully please let us know and you can give us access to your account so we can see what's going on.

In the meantime, you should be able to get rid of the problem by adding a column to show the Order Number (if you haven't already got one for this) and then using the Summary tab to summarise by this.

NOTE: Within reporting the column for the Order Number is called Object Reference.

Do let us know how you get on.