Payment Reference on Payment Advice

(0) Share

Report

Posted on by Hetal Gore

102

On the BDM templates there is Payment Reference label and value, the mapping is to Payment Identification > Payment reference.

I thought this information was coming from the supplier payment journal under the bank tab:

however when i populated this field nothing appeared on the output document:

Can you advise where else the payment reference could be coming from?

Thanks

Hetal

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hetal,

I have just test to run "Payment advice" report via vendor payment journal i 10.0.29 PU53 and I get data for Payment Reference:

On Form setup, please check if you use "BankPaymAdviceVendV2.Report" as standard report format:

Was this reply helpful? Yes No
Hetal Gore 102 on at

Like (0)

Report

Thanks Alireza.

I am looking at the Business Document templates - Vendor payment advice (Excel), rather than the SSRS reports.

I have been doing more testing and found out the payment reference does display but only when you settling transactions, if you complete a manual payment line no information appears.

still more testing to complete but do find this very odd.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hetal,

I have checked the Excel config model mapping on ER and it seems that the mapping is correct:

- DocumentDetails_PaymentRef_Value = '$FirstPayment'.PaymentIdentifications.PaymentReference

I have tested and it works fine:

Can you check if the vendor payment journal line is associated to a vendor invoice?

Was this reply helpful? Yes No
Hetal Gore 102 on at

Like (1)

Report

Thanks Alireza.

Yes the payment reference does display when i use the settle transactions and associate it with a vendor invoice.

However if i just complete a manual line without settling the transactions nothing appears on the report it is all blank.

I think i have to use settle transaction and associate to a open vendor invoice otherwise the system can't recognise the details.

Was this reply helpful? Yes No
Hetal Gore 102 on at

Like (0)

Report

Hi Alireza,

I was wondering if you knew an easy way to identify where the vendor bank details are within the Vendor Payment Advice model?

If you have any easy way to identify data model fields to fields in Dynamics forms it would be really useful.

Kind Regards,

Hetal

Was this reply helpful? Yes No