Skip to main content

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.

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>

Reply


Terms & ConditionsCookie settings