Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Payment Journal -- Ext...
Business Central forum
Suggested answer

Payment Journal -- External Document Number and Document Date

(0) ShareShare
ReportReport
Posted on by john.ellis 3,480

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:
Data Migrations
Financial Management
Purchasing
Reports and Business Intelligence
Other
  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    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 Profile Picture
    Dallefeld 11,423 User Group Leader on at
    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

    pastedimage1665066699096v1.png

    Not sure this resolves your issue but it's worth a try.

  • Billie C Profile Picture
    Billie C 10 on at
    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 Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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 Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    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 Profile Picture
    JAngle 33,155 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans