Vendor Account Statement doesn't show data after adding Voucher number filter

Finance and Operations/AX Developer Forum
1

Hi,

I added one parameter Voucher field from Vendor Trans table , the report showing not data available, but when i removed these parameter and run the report it is showing same voucher number…

Is there any issue or Limitation of AX ?

pastedimage1483990540969v1.png

2

Can you please explain this in detail?

3

Hi Kranthi,

after adding the table vendTrans and add below parameter from VendTrans, the report showing not data.

pastedimage1484017013220v1.png
pastedimage1484017013220v1.png1239×648 30 KB

if i remove the table and parameter the report show all transaction including the voucher which i selected…

4

If you check the Data providerr class (VendAccountStatementIntDP) , you could fine the underlying details. I experienced the same, but now I couldn’t remember the logic. So check the business logic in dp class.

5

Look at \Classes\VendAccountStatementIntDP\initVendTransQuery. The vendTrans is already added to the query in this method. Look at the difference in the query before and after adding the vendTrans.