Small and medium business | Business Central, N...

Vendor payment date

(5) Share

Report

Posted on by SS-13030844-0

Hi all,

I am trying to add the vendor payment date to a report I am currentling building.

I am currenty using the table generalLedgerEntries to get the posting date. We now would like to acchieve to also in alignment with the documentNumber get the vendor payment date.
Do you know which table to use for the payment date and how a relationship can be build to show the posting date and payment date for the same documentNumber?
We have looked through various tables, but don't seem to find a possible connection for some reason.

Looking forward to you help :)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (2)

Report
Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today!

To align the posting date from the generalLedgerEntries table with the vendor payment date, you’ll need to identify the table that stores vendor payment details and establish a relationship based on the documentNumber.

Vendor Payment Table: The vendor payment date is typically stored in the Vendor payment journal or a related table in the Accounts Payable module. You can explore tables like:

VendTrans (Vendor Transactions)

VendSettlement (Vendor Settlements)

CustVendPaym (Customer/Vendor Payments)
These tables often include fields for payment dates and document numbers.

Building the Relationship:

Use the documentNumber as the key to link the generalLedgerEntries table with the vendor payment table.

Ensure that the documentNumber in both tables corresponds to the same transaction.

Query Example:

If you're using SQL or a similar query tool, you can join the tables like this:
sql
SELECT
    gle.PostingDate,
    vp.PaymentDate,
    gle.DocumentNumber
FROM
    generalLedgerEntries gle
INNER JOIN
    VendTrans vp
ON
    gle.DocumentNumber = vp.DocumentNumber

Replace VendTrans with the actual table that contains the payment date.

Data Validation:

Double-check that the documentNumber is consistent across both tables.

If you’re unable to find a direct match, there might be intermediate tables or additional fields (e.g., voucherNumber) that can help establish the connection.

Dynamics 365 Documentation:

For further details, you can refer to Vendor payment overview - Finance | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

Hi @SS-13030844-0,

Which Dynamics product are you working with? Finance and Operations, Business Central, GP etc.

Was this reply helpful? Yes No
SS-13030844-0 19 on at

Like (1)

Report

Hi Jonas,

It would be business central.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

Moved from Integration, Dataverse, and general topics forum.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,367 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

How do i look for the payment date of a Posted Purchase Invoice?

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (1)

Report

Because this may be a one-to-many situation.

For example, an invoice is paid twice or more. Or you pay first, then cancel and reapply.

You can try the following standard feature first.

Business Central 2023 wave 2 (BC23): Large companies to report payment times (Payment Practices feature)

https://yzhums.com/42298/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (2)

Report

You should use Vendor Ledger Entries, instead of General Ledger Entries.

From there, you can look through the invoices and payments.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,629 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as welll: https://learn.microsoft.com/en-us/dynamics365/business-central/payables-how-suggest-vendor-payments

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Yes i Agree with Teddy Herryanto, You should use the Vendor Ledger Entries instead of General Ledger Entries.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,181 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No