Payment Reference on Payment Advice

(0) Share

Report

Posted on by Hetal Gore

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

All responses (5)

Answers (1)

Hetal Gore 47 on at

Like (0)

Report

RE: Payment Reference on Payment Advice

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
Hetal Gore 47 on at

Like (1)

Report

RE: Payment Reference on Payment Advice

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.
Verified answer

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

Like (0)

Report

RE: Payment Reference on Payment Advice

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?
Hetal Gore 47 on at

Like (0)

Report

RE: Payment Reference on Payment Advice

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.
Suggested answer

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

Like (0)

Report

RE: Payment Reference on Payment Advice

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: