I am trying to create a report where I want to filter Receipt numbers based on the Vendor.
I attempted to use the following expression:
=Report.GetFieldSchema('POReceipt.ReceiptNbr,VendorID')
But this is not working - the lookup does not return the expected receipt numbers for the selected vendor.
My goal is to allow users to select a VendorID first, and then the ReceiptNbr dropdown should only show receipts that belong to that vendor.
Has anyone implemented this kind of dependency between parameters (Vendor → ReceiptNbr).
Any guidance would be appreciated.