Where is the Invoice Date??

Business Central/NAV Developers Forum
1

I’m working on modifying report 10085 the Aged A/P report and our A/P clerk wants the Invoice date on the report. I’m looking at the Vendor Ledger Table # 25 and it’s not there. The Invoice number is there but not the Invoice Date. Does anyone know what table has the Invoice Date???

Any help would be aprreciated.

Greg

2

You have the posting date reflecting when “you” posted it, and the document date when the invoice is dated, so the invoice date, it depends where on the purchase invoice screen they are recording the invoice date!

3

Thanks Adam.

I’ll check into it.

4

Hi lovejazz,

the invoice date is in VendInvoiceJour Table.select it based on InvoiceId value.

5

There is no such thing as a ‘VendInvoiceJour’ table in NAV, and there is no field called ‘InvoiceID’.

6

I believe the date you are looking for is the “Document Date” in the “Vendor Ledger Entry” table.