Hi,
I am making an EFT only report of report AP Payment Register. One of the changes includes wanting change the RefNbr parameter to use the APPayment DAC to select a payment rather than from APRegister.
Currently, the report parameter is defined as follows:
And parameter Doctype is this:
When you select a doctype first, the RefNbr parameter selector then displays all AP register records for the doc type you’ve chosen. So I naturally figured I’d change the RefNbr view name definition simply to the following below so that it works like the selector in bills and adjustments:
=Report.GetFieldSchema('APPayment.RefNbr,DocType')
However, when I go to select a payment using the new selector, while the payment selector pops up, it’s always empty. There are plenty of EFT payment method records listed with Doctype Check. Going to the bills and adjustments transaction and using the selector is proof of this. Is there something I’m doing wrong or does APPayment selector simply not work properly with reports?
Thanks,
Andrew