Hi Team,
I need to filter out vendors who are not in the my custom table (HMRCVendorRegisterDetail). I wrote following but it is not showing me the results. Any alternative for this?
Only one vendor code is exists in the HMRCVendorRegisterDetail table
[PXSelector(typeof(Search2<BAccount.bAccountID, LeftJoin<HMRCVendorRegisterDetail, On<BAccount.bAccountID,
Equal<HMRCVendorRegisterDetail.bAccountID>>>, Where<BAccount.type, Equal<BAccountType.vendorType>,And <HMRCVendorRegisterDetail.bAccountID, Equal<Null>>>
>),
typeof(BAccount.acctCD),
typeof(BAccount.acctName),
SubstituteKey = typeof(BAccount.acctCD),
DescriptionField = typeof(BAccount.acctName))]
Best answer by Django
View original