What is the difference between the "Detailed" vendor ledger entry table and the regular one?

(0) Share

Report

Posted on by Community Member

I have a report that was written to pull amounts per vendor, for tax purposes. Apparently, a vendor was missed.

The report pulls from [Duvel USA$Detailed Vendor Ledg_ Entry]

My missing Vendor only shows data when pulling from [Duvel USA$Vendor Ledger Entry] but our report does not use this table.

I am unsure whether there report was designed poorly, or if my lack of understanding between the difference in two the tables is prohibiting me from understanding why the vendor does not show data in the "detailed" table.

Any insight will help. I have read https://msdn.microsoft.com/en-us/library/hh893595(v=nav.90).aspx and noticed that the definition of the table implies only entries that have had some sort of adjustment will appear in the "detailed" table. This only confuses me more because the report uses this table, not the other.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

The best way to illustrate the difference on the following example: When you post a currency invoice from your vendor, it is booked as one record in each of both tables. You will have a local currency amount, recalculated, say, at the posting date of the invoice.

Then in the end of the month you re-valuate your currency payables at the rate, valid in the end of the month. This action does not create a new transaction with your vendor as such (you still have only one invoice), however the payable in your local currency in the end of the month is a different one. This action results in additional transaction in the Detailed Vendor Ledger Entry table (so there will be already two records), that would have zero currency amount, but would have some local currency amount that would adjust the local currency payable to needed total amount. The record in Vendor Ledger Entry table will refer as a flow field to the sum of both transactions in Detailed Vendor Ledger Entry table, so you will see the correct amount of payables in local currency in Vendor card.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Here is the standard def -

The Detailed Vendor Ledg. Entry table contains all posted entries, including adjustments, related to the document and journal line entries in the Vendor Ledger Entry table.

Besides the original entry and the applied entry, the Detailed Vendor Ledg. Entry table includes any adjustments made to the vendor ledger entry. These could be payment discounts, realized and unrealized losses and gains due to changes in the currency exchange rate, application rounding and corrections due to the rounding of different currencies.

Vendor Ledger Entry Table

This table contains posted entries from purchase orders, purchase invoices, purchase credit memos, journal lines, finance charge memos, reminders and refunds.

When you post to a vendor account, the program creates a vendor ledger entry, which you can see in the Vendor Ledger Entry table by clicking Vendor, Ledger Entries from the vendor card.Vendor ledger entries are created by the posting of a purchase order, invoice, credit memo or journal line.

All adjustments made to the vendor ledger entry due to, for example, payment discounts or changes in currency exchange rates, are recorded in the Detailed Vendor Ledg. Entry table.

The only fields on a vendor ledger entry that can be changed are the following: On Hold, Due Date, Pmt. Discount Date, Remaining Pmt. Disc. Possible, Pmt. Disc. Tolerance Date and Payment Tolerance. You cannot change the other fields because the entry has been posted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your answer.

The part that is confusing to me is this:

All adjustments made to the vendor ledger entry due to, for example, payment discounts or changes in currency exchange rates, are recorded in the Detailed Vendor Ledg. Entry table.

This makes it sound like the only way for something to make it to the detailed vendor ledg entry table is with an adjustment. Does this also mean once an adjustment is made, and it is recorded in the detailed table, that the record is removed from the Vendor Ledger Entry table?

In other words, if I pulled records from both tables I shouldn't have duplicate entries (assuming the record is removed from the regular vendor ledger table and moved into the detailed vendor ledger table if an adjustment is made).

This also sounds like, it is entirely possible - and probably more common, that records only remain in the regular vendor ledger entry table and never get to the detailed table.

Unless... could that depend on the standard procedures of a given finance department? Is it common, or even possible, that a finance department uses adjustments or a similiar action as part of their monthly/quarterly/etc cycle?

I ask this because the report I inherited (which is said to have been 100% accurate the previous year) is written in such a way that it ONLY considers the detailed vendor ledger entry table. So, it appears to make the assumption that all vendor ledger entries will make it to the detailed vendor ledger entry table.

But the problem is, there are some missing entries... and I've found them in the regular vendor ledger entries table. The report just doesn't use that table, yet the report was 100% accurate last year (supposedly). The report has also not been changed since then.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

The total amount of each transaction in both tables are equal.

If you male a purchase invoice and then you make a corrective credit-note, you will have two transactions in Vendor Ledger Entry table and two transactions in Detailed Vendor Ledger Entry table.

In simple words, both tables contain the same transactions and amounts, but the Detailed Vendor Ledger Entry table is more... detailed :-), it can contain several records to one initial transaction in Vendor Ledger Entry table.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

"This makes it sound like the only way for something to make it to the detailed vendor ledg entry table is with an adjustment. Does this also mean once an adjustment is made, and it is recorded in the detailed table, that the record is removed from the Vendor Ledger Entry table?"

No. When any purchase transaction gets posted financialy (via any kind of purchase document or general journal) it will result in creation of Vendor Ledger Entry (VLE). One document - one VLE. When VLE gets created, one Detailed Vendor Ledger Entry (DVLE) of Type = Initial Entry gets created also. Any further transactions that are affecting/changing the initialy posted document amounts will result in creation of additional DVLEs, like others mentioned.

You must also be aware of the fact that almost all of the amounts you see on Vendor table and on VLE table are derived from DVLE table. Those are all FlowFields based on the amount fields in DVLE. Those additional DVLE's will affect totals calculated in all of those FlowFields on Vendor and VLE table.

In most cases, there's no deleting or changing of posted data in NAV! And that's great! All you can do is to post new transactions that in some way affect previously posted ones.

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

if simple than:

Vendor Ledger Entry - are vendor invoices and payments.

Detailed Vendor Ledger Entry - are Vendor Ledger Entry + currency adjustments.

But take in mind that Vendor Ledger Entry don't have it's own Amount field. What you see in Amount field (also remaining amount and other amount fields) - is sum of Detailed Vendor Ledger Entries for this entry.

Was this reply helpful? Yes No
DynamicsBoy 520 on at

Like (0)

Report

I have the same problem like this in NAV 2015 version. The exchange rate adjustment has registered on detailed vendor ledger entry but not updating the amount (LCY) field in vendor ledger entry.

Was this reply helpful? Yes No
vijaybaheti16 108 on at

Like (0)

Report

VLE is basically things hitting your vendor like invoice & bank payments... while DVLE comes into picture when you apply/un-apply these invoices and payments...

Was this reply helpful? Yes No