web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... ER - Vendor Payment Ad...

Finance | Project Operations, Human Resources, ...

Unanswered

ER - Vendor Payment Advice - Excel

(0) Share

Report

Report

Posted on by Hetal Gore

102

Hi,

I have derived a payment advice model mapping and added a the VendBankAccount Table to get the AccountNum for each vendor:

i have then added this as a cell within the Format:

The vendor payment advise is generating but is only picking up the first Bank account on the list not the bank account related to the vendor.

can you advise what i could try?

Kind Regards,

Hetal

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Hetal Gore 102 on at

Like (0)

Report
Copy link

Link copied!

I have managed to resolve this.

Rather than adding a new table, find the VendBankAccount as a relation through BankPaymAdviceVendTmpHeader and then bind this to the model.paymentmodel.creditor.identification.number

Once i did this the format retrieve the right bank account associated to the vendor.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 620

#2

André Arnaud de Cal... 521 Super User 2026 Season 1

#3

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans