Skip to main content
Answer

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

  • April 28, 2025
  • 3 replies
  • 71 views

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

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • 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


Forum|alt.badge.img+1

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 2, 2025

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