Skip to main content
Solved

Get all accounts under a particular account group

  • 9 March 2023
  • 1 reply
  • 42 views

Forum|alt.badge.img

I am trying to write a PXSelect to fetch the accounts under the account group screen Id PM201000.

I found the table for the Account Group (PMAccountGroup) but not able to find a way to get only the accounts tab records as it is a  VirtualDAC anyone can see a way here ?

Also the VirtualDac does not a GroupId to fetch the related records.

Best answer by aaghaei

Look into Account DAC and filter on AccountGroupID. Always child DACs inherits the parent DAC keys not the opposite.

You should select from Account where Account.AccountGroupID.IsEqual<PMAccountGroup.GroupID.FromCurrent>

View original
Did this topic help you find an answer to your question?

1 reply

aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • Answer
  • March 9, 2023

Look into Account DAC and filter on AccountGroupID. Always child DACs inherits the parent DAC keys not the opposite.

You should select from Account where Account.AccountGroupID.IsEqual<PMAccountGroup.GroupID.FromCurrent>


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings