GI for SO line with different warehouses

Hi, do you mean, you are looking for all sales orders that reference more than one warehouse? Meaning, if the same warehouse is on every line then you don’t want to see that order?

If so, You can add a Count based on  SoLine.Warehouse. Group by Order number and then Warehouse. Add Condition = where count(warehouse field) >= 2.

I hope this steers you in the right direction.

Thank you. Yes, that is what I mean. I did the grouping you mentioned and did the count in the results tab and added the filter on inquiry itself as I wasn't sure how to add count to the conditions tab in the GI. majority looks good except I received 3 for one order when it was only 1 whse. some screenshots below.

Hello, Please, can you expose the name of the count field? And a screen shot from your GI so we can see the logic of the count field would be helpful.

Thanks.

Hi, Sorry here is it. I used the Count in the Aggregate Function column.

 Hi @marisa10 were you able to resolve your issue? Thank you!

Hi @Chris Hackett, unfortunately I was not. Any thoughts on what I'm doing wrong?

Hi @laura01 an further suggestions for @marisa10 ? Thank you!

Hi, @marisa10  You might have already done this but just attaching the XML GI for reference.

And, we cannot provide the COUNT condition in the CONDITIONS tab, after viewing the results then we need to apply the condition at the Grid column.

Hi @Naveen Boga , Thank you for sending however I am not using the count in the conditions tab. My GI is set up the same as yours and using the Count in the results tab.

I have attached my GI. There are still 2 orders showing on the report with a count of 3 whse however there is only 1 line on the SO. I checked the audit to confirm and there was always 1 whse.

Any suggestions?