Creating a report to link bank payments transaction to the accounts payable entry D365 F&O

(3) Share

Report

Posted on by ARivera

We need to provide auditors with a report showing the details of a bank transaction, including the G/L account number/name for the Accounts payable entry.

We ran the "Payment summary by date report." This report provides the bank transaction date, vendor account, vendor name, and aggregated total amount transferred to the bank. We are trying to create this report in Datalake, but we are having trouble figuring out which table/fields to link the data from the bank transactions to the accounts payable that will bring in the G/L account.

We would appreciate it if anyone could share their expertise.

Thank you for your attention.

Categories:

Dynamics 365 Finance

All responses (3)

Answers (1)

ARivera 33 on at

Like (0)

Report

Creating a report to link bank payments transaction to the accounts payable entry D365 F&O

Thank you for the suggestions. It was very helpful.
Verified answer

Alireza Eshaghzadeh 13,503 Super User 2024 Season 2 on at

Like (0)

Report

Creating a report to link bank payments transaction to the accounts payable entry D365 F&O

Hi,

In addition to Andre's feedback, you could consider using either the Transactions Origin Report or the Ledger Transaction List Report in General Ledger.
André Arnaud de Cal... 291,948 Super User 2024 Season 2 on at

Like (0)

Report

Creating a report to link bank payments transaction to the accounts payable entry D365 F&O

Hi ARivera,

Depending on the exact requirement, I think you can find the information in the tables VendTrans, BankAccountTrans, GeneralJournalEntry, and GeneralJournalAccountEntry. Usually there is an option to link these tables using the Voucher number and a Posting/Transaction date.