Small and medium business | Business Central, N...

Payment Journal -- External Document Number and Document Date

(0) Share

Report

Posted on by john.ellis

3,482

Hi:

On the A/P check stub generated from the Payment Journal, the "External Document No." does not display.

That's unfortunate, because this is the field that holds the actual invoice number of the vendor. The "Document No." field contains, instead, a system generated number. "Document No." appears on the check stub but is unhelpful for our vendors upon receiving their checks from us.

Ultimately, in the Payment Journal, "Document Date" should be the invoice date and "Document No." should be the vendor invoice number. Is it possible to make any of this "happen" for our needs?

Thanks!

John

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

Hi,

Add these fields by using report extension. this is missing in the standard report

Regards

Amit Sharma

www.erpconsultors.com
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

Did you try the setting in Purchases & Payables Setup, This is copy invoice no to payment reference

Not sure this resolves your issue but it's worth a try.
Billie C 10 on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

John,

Did you ever reach a solution? We are also struggling with getting External Document No on the ACH remittance advices. We had the Vendor Payment Receipts updated to include that information but I can't set that report as the ACH remittance advice. I've sent the error message to our MS partner but was hoping to find a solution in the forums.
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

If you choose to do so there is nothing in the system that will keep you from using the vendor invoice number as the document no.

It is not common but it is completely doable. The unique identification for the transaction will be the Entry no. in the ledger tables.

Using the document date as the date of the invoice from the vendor is pretty common. And in that case i use the posting date to control the accounting period the invoice will be posted to.
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

Hi, If you're talking about a standard report missing a field you need, you can use ReportExtension to add it.

More details:

https://yzhums.com/10723/

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-ext-object

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: Payment Journal -- External Document Number and Document Date

Is the value not in the message to recipient field? Extract it from there with a custom layout? I expect it is a modification if standard isn’t working for you