Skip to main content
Question

GI for SO line with different warehouses


Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies

Hi,

I am a beginner. I cant think of a way to accomplish what I need so was hoping someone here can help.

Does anyone know a way to create a GI for SO lines with different warehouses per order? Sometimes we have different warehouses on a SO. I would only like to see where the warehouses don’t match so I don’t see all orders.

Thanks.

9 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • April 7, 2022

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 7, 2022

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.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • April 8, 2022

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 8, 2022

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

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2659 replies
  • April 26, 2022

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 27, 2022

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2659 replies
  • April 27, 2022

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • April 28, 2022

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.

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 28, 2022

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?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings