Solved

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

  • 20 October 2023
  • 2 replies
  • 33 views
A
Rank
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?

icon

Best answer by Laura02 20 October 2023, 21:53

View original

2 replies

Laura02
Rank
Badge +18

Hello,

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

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
A
Rank
Userlevel 1

Thanks @Laura02 for your response!

Reply


Terms & ConditionsCookie 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