Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Vendor payment date
Small and medium business | Business Central, N...
Suggested answer

Vendor payment date

(3) ShareShare
ReportReport
Posted on by SS-13030844-0 9
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
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 2,699 on at
    Vendor payment date
    Hello,
     
    Yes i Agree with Teddy Herryanto, You should use the Vendor Ledger Entries instead of General Ledger Entries.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 11,539 Super User 2025 Season 1 on at
    Vendor payment date
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,219 Moderator on at
    Vendor payment date
    You should use Vendor Ledger Entries, instead of General Ledger Entries.
    From there, you can look through the invoices and payments.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,602 Super User 2025 Season 1 on at
    Vendor payment date
    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)
     
     
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 16,226 Most Valuable Professional on at
    Vendor payment date

    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

  • Martin Dráb Profile Picture
    Martin Dráb 232,160 Most Valuable Professional on at
    Vendor payment date
    Moved from Integration, Dataverse, and general topics forum.
  • SS-13030844-0 Profile Picture
    SS-13030844-0 9 on at
    Vendor payment date
    Hi Jonas,

    It would be business central.
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 3,122 Super User 2025 Season 1 on at
    Vendor payment date
     
    Which Dynamics product are you working with? Finance and Operations, Business Central, GP etc.
  • Holly Huffman Profile Picture
    Holly Huffman 3,768 on at
    Vendor payment date
    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.
     
    1. 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.
    2. 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.
    3. 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.
    4. 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.
    5. Dynamics 365 Documentation:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,309 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,160 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=inventory+control+2022++version+3%2C3%2C0%2C9" - Nested quantifier +.