Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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 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.

  • Zigi Profile Picture
    20 on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    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

  • Zigi Profile Picture
    20 on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    Capture44.PNG

    This is the result that I keep getting. 

    Capture66.PNG

  • Suggested answer
    YUN ZHU Profile Picture
    84,274 Super User 2025 Season 1 on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,029 Moderator on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    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?

  • Zigi Profile Picture
    20 on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    Can you suggest a solution pls?

  • Amit_Sharma Profile Picture
    2,547 on at
    RE: Adding Vendor Ledger Entry Table's External Document No. to Inventory - Vendor Purchase Report

    Hi,

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

    Regards

    Amit Sharma

    www.erpconsultors.com

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans