Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

how does applied vendor entries work?

(0) ShareShare
ReportReport
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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans