web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Adding Vendor Ledger E...
Small and medium business | Business Central, N...
Suggested Answer

Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

(0) ShareShare
ReportReport
Posted on by Zigi 20

Hello,

I'm new to Dynamics Business Central Dev2845.Vscode.PNGelopment. I tried adding Vendor Ledger Entry Table's External Document No. to the Inventory - Vendor Purchase Report. I added some code to the report. But it's not generating the result I need. Pls I need help with this.

I have the same question (0)
  • Amit Profile Picture
    Amit 2,563 on at

    Hi,

    You have written wrong code. Pls consult your developer or partner for doing the same.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Zigi Profile Picture
    Zigi 20 on at

    Can you suggest a solution pls?

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,177 Moderator on at

    First of all i think you have selected the incorrect data item for your report.

    And you never retrieve any vendor ledger entry records so that is why your values are empty.

    Can you please try to make a clearer specification on what exactly you try to report on?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,212 Super User 2026 Season 1 on at

    Hi, Although not exactly the same, you can refer to the method below to obtain Company information.

    pastedimage1666310681051v1.png

    pastedimage1666310717812v2.png

    Also, If it is set DataItem to Vendor, you can add a child DataItem (Vendor Ledger Entry) below, which can easily obtain data.

    For example

    pastedimage1666310754940v3.png

    Hope this can give you some hints.

    Thanks

    ZHU

  • Zigi Profile Picture
    Zigi 20 on at

    Capture44.PNG

    This is the result that I keep getting. 

    Capture66.PNG

  • Zigi Profile Picture
    Zigi 20 on at

    I'm trying to modify the Inventory -Vendor Purchase Report. I want to add the External Document No. in Vendor Ledger Entry on the Report.

    Capture234.PNG

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,948 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 936 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 616 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans