Skip to main content
Answer

Proper usage of "IN" and Belongs To in Report Designer

  • April 28, 2025
  • 3 replies
  • 71 views
T
Semi-Pro II
Forum|alt.badge.img+1

 

Has anyone used IN or BelongsTo?  I’ve tried both in this format and returning no results.  

 

 

 

Best answer by BenjaminCrisman

​@travislawson I’m not sure entirely what the extent is of how useful these can be, but there is mention of using them in the help documentation:

https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=f6bd0804-543a-4e52-9fe9-4cd8305c575b

Check under:

User-Relative Filter Clauses

 

 

For the Belongs To I think this is relating to Branches or Companies

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀 ➡️ www.linkedin.com/in/-travis-lawson-/

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • April 28, 2025

​@travislawson I’m not sure entirely what the extent is of how useful these can be, but there is mention of using them in the help documentation:

https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=f6bd0804-543a-4e52-9fe9-4cd8305c575b

Check under:

User-Relative Filter Clauses

 

 

For the Belongs To I think this is relating to Branches or Companies

Chris Hackett
T
Semi-Pro II
Forum|alt.badge.img+1

Thanks ​@BenjaminCrisman.  Looks like they only work with those specific user-relative clauses only based on that.  

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀 ➡️ www.linkedin.com/in/-travis-lawson-/
Manikanta Dhulipudi
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 2, 2025

Hi ​@travislawson were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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