Duplicates on Saved Transaction Search

Question

I'm searching over transactions with the following criteria:

Type is Transfer Order Internal ID is 547871 Main Line is false Tax Line is false Shipping Line is false COGS Line is false

I just have one results column, which is Quantity.

So I'm just looking at a single Transfer Order, and it happens to only have a single item on it, but that item is showing up three times, with different quantities each time.

Here is the results page. What is going on here?

score 1 · Answer 1 · answered Sep 04 '18 at 11:23

1

As per your requirement Main Line should be set to true. If you will try using mainline is true then you will not get duplicate lines. Thanks

answered Sep 04 '18 at 11:23

EMP

46
3

score 1 · Answer 2 · edited Jul 10 '21 at 00:24

1

you need to add following condition in the search:

Transaction Line Type = Item

edited Jul 10 '21 at 00:24

Jeremy Caney

7,102
69
48
77

answered Jul 08 '21 at 10:38

Jef

11
1

score 0 · Answer 3 · answered Dec 03 '18 at 18:56

0

You can try "transfer order quantity received" is not empty and main line is false. This way it will eliminate the duplicate lines & show only the actual line item from TO.

answered Dec 03 '18 at 18:56

Mic S

13
3

Duplicates on Saved Transaction Search

3 Answers3