Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

how does applied vendor entries work?

Posted on by Microsoft Employee

Hello guys,

I'm just going to ask on how is the

Applied vendor entries work.

 because i'm making a report that's just similar to the vendor ledger entries and the applied vendor entries.

Scenario:  I have a line rec. of Payment in vendor ledger entries .

in which this line of payment has more 3 invoices applied.

now for the report

it shoudl display both the Payment line.

and the Applied line.

*This post is locked for comments

  • Verified answer
    Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: how does applied vendor entries work?

    Hi,

    Start your report with a loop on the Vendor Ledger Entry and add an integer Loop on the Detailed Vendor Ledger Entry.

    Like this:

    Groupping.jpg

    On the PreDataItem of the Integer Loop add the following filters to filter out the record itself and to filter to the records applied:

    DetailedVendorLedgEntry.SETFILTER("Vendor Ledger Entry No.", '<>%1', "Vendor Ledger Entry"."Entry No.");
    DetailedVendorLedgEntry.SETRANGE("Applied Vend. Ledger Entry No.", "Vendor Ledger Entry"."Entry No.");

    In the RDLC Report you will need to create a group for the Vendor Ledger Entries on the Entry No. field and add a child group to it grouped on the Applied Vend. Ledger Entry No. field then filter the Group like this:

    Groupping.jpg

    I hope this helps.


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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans