Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Vendor Ledger Applied ...
Microsoft Dynamics NAV (Archived)
Suggested answer

Vendor Ledger Applied Entries don't show correct amount applied

(0) ShareShare
ReportReport
Posted on by rabsocket 190

Hi All,

First time on here, so please bear with me.

NAV 2009 R2, GB Dynamics NAV 6.0 SP1

What we want is to be able to click on any payment on the Vendor Ledger, then go to applied entries and for it to show all the entries the payment adds up to, i.e a list of all the invoice(s) and credit note(s), individually listed, along with the amount allocated/applied for each of the aforementioned transactions, and the applied/allocated amounts to add up the payment we are getting the detail for. 

The problem is that if any invoice has previously been part paid, it won't show the correct amount that has been applied to the payment we are trying to find out the detail for.  We have access to the data in the tables, but I can fathom an easy way to work out how to find out what we need.

Any help would be gratefully appreciated.

 

Kind regards,

 

rabsocket

 

*This post is locked for comments

  • Andri Wianto Profile Picture
    Andri Wianto 385 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    I think I agree with Jens.

    I ever had a time, facing this issue.

    But, I could not remember the exact scenario.

    What I could only remember, is that the Closed by Amount is not the answer to the question.

    However, once I got the scenario, I will share here.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    Hi Harry,

    how about three rates, or you distribute your payment among several invoices and also do a partial application on these? The accountants I've talked to were most of the time not satisfied with the "closed by" fields. They wanted what rabsocket describes, a list with a distribution of the payment.

    with best regards

    Jens

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    That has been my experience.  We half pay invoices all the time when we have invoices with terms

    1/2 30 - 1/2 60

    when I click on each check -> applied entries the closed by amount on each check show the amount that was on the check.

    Since this is the only way we do it there might be another way when it is not true.

    I would be interested in an example when it doesn't hold true.

  • Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    Hi Harry,

    I'm afraid that's not always true. The closed by amount / currency fields are only filled in when the entry is closed, not if it's a partial application.

    with best regards

    Jens

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    When you click on "Applied Entries" of the check you are probably seeing fields "Amount" or "original Amount"

    Have you tried showing the field "Closed By Amount"?  That will give you the number you are looking for.

  • Andri Wianto Profile Picture
    Andri Wianto 385 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    Hi rabsocket,

    There are 2 ways to view the Detailed Vendor Ledger Entries:

    1. Related Information | Detailed Vendor Ledger Entries,

    2. Drilldown the Remaining Amount in Vendor Ledger Entries

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    Hi rabsocket,

    that sounds easier than it is. What Andri says is true, the detailed application entries of the payment are the key to it, but it's only part of the way. You require (naturally) to see the other side of the application and the documents behind it. The chain to follow is:

    for each application entry -> same transaction -> all entries except your origin -> mark the vendor ledger entry it's belonging to

    The change needs to be done in Form/Page 62, function FindApplnEntriesDtldtLedgEntry(). It will give you most of your requirement. For the complete picture you would also need data from the application entries itself (the amount applied). Either you have to add a flowfield to the vendor ledger entries, or you need to rebuild the whole form/page for detailed ledger entries, and need at least one flowfield there.

    with best regards

    Jens

  • Andri Wianto Profile Picture
    Andri Wianto 385 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    You can check the Detailed Vendor Ledger Entries, from the Payment Entry.

  • Suggested answer
    rabsocket Profile Picture
    rabsocket 190 on at
    RE: Vendor Ledger Applied Entries don't show correct amount applied

    Hi All,

    Sorry, I meant can't fathom a way to work out...

    Kind regards,

    rabsocket

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans