Forum Discussion

daniel's avatar
daniel
New Contributor
8 months ago

Filter accounts by Plug Account

Hi, How can I filter accounts by the plug account property just like I can filter by other account properties such as text? I am creating a CubeView and I need to show a series of accounts that h...
Cube View
Reports
Kamila's avatar
Kamila
Contributor

Not sure if that's somehow helpful, but within Excel you can use XFGetmemberProperty function, which retrieves a plug account.

Formula:

=XFGetMemberProperty("Account","1311010","PlugAccount","","Actual","2023M6")

 

Krishna's avatar
Krishna
Valued Contributor
8 months ago

daniel  - If you are looking to get the Plug Account using BRAPI then use the following. It can be retrieved

Dim mbr As Member = BRApi.Finance.Account.GetPlugAccount(si, memberId)

 

using member Id