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

Payment Journal -- External Document Number and Document Date

(0) Share

Report

Posted on by john.ellis

3,530

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)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

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

YUN ZHU 103,103 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
Billie C 10 on at

Like (0)

Report
Copy link

Link copied!

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

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Regards

Amit Sharma

www.erpconsultors.com