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

Question

sweta68 · Accepted Answer

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

Fernando Amadoz · Answer

I recently had this same question while working on the report designer with the ‘belongs to’ condition.

This is a very specific condition from the framework that is used to identify the Branches associated to a given Organization/Company’s BaccountID value.

All references to this condition in the standard Acumatica reports show the pattern Branch belongs to OrgBAccountID. Here is an example from one of the 1099 reports

What is occurring underneath during this SQL representation is that the parameter displays the one - or many - BranchID associated to said Business Account.

Notice that the SQL representation of the query converted the second parameter to this result:

AND [CompanyBranchBAccount1099_BAccountR].[BAccountID] = 7128 AND [AP1099History].[BranchID] IN ( 125, 29, 66))

Be aware that belongs to and IN are not the same. IN condition does not replace the value.
If we change the example above to use IN instead, this is the SQL representation (which will not print correct results)

AND [CompanyBranchBAccount1099_BAccountR].[BAccountID] = 7128 AND [AP1099History].[BranchID] IN ( 7128))

(	@OrgBAccountID	IsNull				Or
	PRPayment.BranchID	BelongsTo	@OrgBAccountID		)	And

Sign up

Social Login

Login to the community

Social Login