Solved

how to use ‘belong to’ filter in acumatica report design

  • 6 July 2023
  • 2 replies
  • 86 views

how to use ‘belong to’ filter in acumatica report design

icon

Best answer by sweta68 6 July 2023, 07:23

View original

2 replies

Userlevel 7
Badge +10

Hi @vannakheng,

The term "Belongs to" is not a standard filter type in Acumatica.

To achieve similar functionality in Acumatica report designer, you can use the "In" filter type. 

By using the "In" filter, you can achieve a similar filtering behavior as the "Belongs to" filter, where you can specify a list of values that the field should match.

 

Regards,

Sweta

You state that BelongsTo is not a standard filter type in Acumatica but it is used in some reports.  For example in Payrol report PR641060.rpx it is used.  However, I cannot find any help on how it works.

( @OrgBAccountID IsNull       Or
  PRPayment.BranchID BelongsTo

@OrgBAccountID

  ) And

Reply


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