Announcements
No record found.
Hi D365 FO Experts,
I am looking for options to filter the Vendor posted payment journal report with Vendor Account ID. Is there any way to get this filter. like with joins or any other way. Please suggest some workaround.
Hi D365,
Records to include will show the tables that are used in the report query.
Navigate to the dp class of the report >>on the top they will mention the query used for the report using query attribute.
Thanks,
Girish S.
You can do this without coding also. Select the Journal lines >> Select Add table join >> It will open the new form with all the tables >> Select Dimension code combination >> Click on "Select" at the top >> Now you can add the range to "Display value" field >> On the criteria field you can type the vend account id and ran the report.
Hi Girish,
Thanks for replying. I am Not able to find field Vendor Account in the Dimension code combination.
I guess field name should be Display value not vendor account.
Hi D365 Functional,
As Girish suggested create a new record in that select query and in that click on add table join and see what are the tables available there. If you find any table where you might think vend I'd would be available, then just add that and select that. So while giving range you can select that vend I'd. But I'm sure you should have a Vendaccount or Accountnum field to filter.
Thanks
Bharani
Also here directly you have LedgerJournalTable. I think join is also not required. In this table itself you have AccountNum field or LedgerDimension field. Please try with these.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
