Retrieving some info related to invoice

manonav

Hello guys and girls,
First of all I don't know if I'm posting this in the right place, so my apologies if it's not.

Now, I should say I'm relatively new to Navision (under 2 years) and I struggle with many things stilll.

I need some help with something. I need to create a report that will show the percentage of invoices from vendors that have been paid under the time the user specifies when running the report, the percentage of invoices that were paid over that time, and then some more info.

My question is the next:
How can I know if an Invoice has been paid completely (I think there's a field in the Vendor Ledger Entry table named "Open" that says exactly that) and when it was paid (this I don't know)?

I need that so I can compare the date the invoice was issued and the day it was paid so I can compare both and classify them for my report.

Thanks in advance guys and I hope it's not too much trouble!

MarkHamblin

You'll want to have a look at the detailed vendor ledger entries - this will list the detailed transactions that affect the main vendor ledger entry, including any applications (payments, credits, etc.) made. They're linked by the Vendor Ledger Entry No. field (hit Ctrl+F5 on the vendor ledger entries to see).