Hello,
To solve a performance issue, I need to get VendorID list from this query :
select distinct (VendorID)
from APPayment, APRegister
where
APPayment.doctype='PPM'
and status='N' -- Statut ouvert'
and APPayment.RefNbr = APRegister.RefNbr
and APPayment.DocType = APRegister.DocType
To comply Acumatica, I guess I have to use a DAC to do that. In a way, this DAC would we be a kind of reduced version of the APPayment DAC in which I just would need to embbed the following fields an not the other ones :
- DocType,
- VendorID,
- Status
Hence the title of this topic. Is it possible to do that in Acumatica ?
Best answer by Dmitrii Naumov
View original