Microsoft Dynamics NAV (Archived)

Vendor Ledger Applied Entries don't show correct amount applied

(0) Share

Report

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

All responses (9)

Answers (0)

Andri Wianto 385 on at

Like (0)

Report

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 6,092 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 6,092 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 385 on at

Like (0)

Report

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 6,092 on at

Like (0)

Report

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 385 on at

Like (0)

Report

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 190 on at

Like (0)

Report

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