Skip to main content
Solved

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

  • April 28, 2025
  • 3 replies
  • 133 views
  • Translate All
Pro I
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

View original
🚀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

​@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

Translate
    Pro I
    Forum|alt.badge.img+1

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

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

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

      Translate
      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 & ConditionsAccessibility 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