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

Payment Journal -- External Document Number and Document Date

(0) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Billie C 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

Hi,

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

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No