GI condition to exclude results where two fields have the same value

  • 20 October 2023
  • 2 replies

Userlevel 1

I have a GI with INTran records. I don’t want the GI to include any records where the BuildingID of the SiteID is the same is BuildingID of the ToSiteID. Can I create a condition that will do that?


Best answer by Laura02 20 October 2023, 21:53

View original

2 replies

Badge +18


I think we can use conditions to select where two different Site ID Fields do not match.  I don’t know the tables you are using so I can’t give an exact answer, but here is an example that I think might work for you:

Condition example


Userlevel 1

Thanks @Laura02 for your response!


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