web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Payments Table

Small and medium business | Business Central, N...

Suggested Answer

Payments Table

(0) Share

Report

Report

Posted on by Community member

How can I get Payments table with Invoice id associated from business central API, in order to connect with Power BI?

I tried using Standard API, table vendorPayments but it´s empty.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 97,089 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, the source table of vendorPayments is "Gen. Journal Line", so it is the data before posting.

For this data, you can try Detailed Vendor Ledger Entries. There may not be a standard API, you can publish it to the Web Service for testing.

Hopefully other experts can give you better advice

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,167

#2

Dhiren Nagar 1,184

#3

YUN ZHU 1,161 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans