Skip to main content
Solved

GI Problem when grouping by and filtering by siteCD

  • January 27, 2023
  • 1 reply
  • 42 views
R
Jr Varsity II
Forum|alt.badge.img

I have a GI where I am joining AMMRPBucketDetailInq to INSite (joined by siteId) and to InventoryItem (joined by inventoryId). I am also grouping by siteId.

I want the user to be able to select a warehouse, so I have set up a Parameter for INSite.SiteCd (NOT INSite.SiteId). When I execute, no matter what siteCD I enter, the GI displays all rows. It appears to be ignoring the INSite.SiteCd from the Parameter. 

The GI XML is attached.

Thank you!

Best answer by Julia Lukina

Hi @rdennisj57 , condition is missed on the GI. Please try:

 

View original
Did this topic help you find an answer to your question?

1 reply

Julia Lukina
Acumatica Employee
Forum|alt.badge.img+1
  • Julia Lukina
  • Acumatica Employee
  • 48 replies
  • Answer
  • February 2, 2023

Hi @rdennisj57 , condition is missed on the GI. Please try:

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved