Payment Journal - automatically populate external document number

(6) Share

Report

Posted on by JG-14070206-0

Hi All,

I asked a question previously regarding having the External Document number auto populated in the payment journal. It is understood that Business Central does not automatically populate the external document no, but it is possible through automated customization or an extension.

Can anyone point me in the direction of how I can automate this customisation or what the extension is that I am looking for so that I can get this actioned.

The previous answer I received explained " However, this can be automated through a small customization or extension. The customization would copy the External Document No. from the applied invoice to the Payment Journal Line’s External Document No. field during the application process"

Sorry to bring up the same topic, but I actually need further information so I can take the appropriate steps to implement this customization / extension.

Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

JUBEL THOMAS JOY 279 on at

Like (1)

Report
Copy link

Link copied!

Hi,

To implement this, you’ll need to create a Business Central extension using AL language. Here's a simplified outline of what the extension should do:

1. Event Subscriber
Create an event subscriber to hook into the logic when a payment journal line is created or modified during the application of vendor entries.

2. Fetch External Document No.
From the applied vendor ledger entry (invoice), retrieve the External Document No..

3. Update Payment Journal Line
Set the External Document No. field on the payment journal line with the value retrieved.

Kindly review and test using following code. If you are not aware about coding always recommended to take guidance from any technical.

sample code as follows

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnBeforePostGenJnlLine', '', true, true)]
procedure OnBeforePostGenJnlLine(var GenJournalLine: Record "Gen. Journal Line"; var IsHandled: Boolean)
var
VendorLedgerEntry: Record "Vendor Ledger Entry";
begin
if GenJournalLine."Document Type" = GenJournalLine."Document Type"::Payment then begin
VendorLedgerEntry.SetRange("Applies-to ID", GenJournalLine."Applies-to ID");
if VendorLedgerEntry.FindFirst() then begin
GenJournalLine."External Document No." := VendorLedgerEntry."External Document No.";
end;
end;
end;

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,052 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

You can use development to obtain this value and copy it to the journal, but be careful when applying multiple invoices to a single payment line; you must define what you want (for example, use the number of the first invoice, concatenate them, or leave the field empty).

Best

Gr

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 16,773 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

The System does not automatically populate the External Document No. in the Payment Journal when applying vendor entries, but this can be automated through a small customization or extension.

https://learn.microsoft.com/en-us/dynamics365/business-central/purchasing-ext-doc-no

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,177 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

To automate the population of the External Document No. in the Payment Journal, you'd need a small AL extension that copies this value from the applied invoice when you apply it in the journal. Here's a short overview of how you can implement it:

---

🔧 Basic Customization Steps (AL Extension):

1. Event Subscriber: Create a subscriber to the OnAfterApplyCustLedgEntry event (or similar event depending on where you apply the invoice in the Payment Journal).

2. Logic: In the subscriber, fetch the External Document No. from the applied Customer Ledger Entry (usually type = Invoice), and update the current Gen. Journal Line.External Document No. with that value.

3. Deployment: Package this as a .app file using Ctrl+Shift+B in Visual Studio Code and publish it to your environment.

---

Example Snippet:

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnAfterApplyCustLedgEntry', '', true, true)]

local procedure CopyExternalDocNo(GenJournalLine: Record "Gen. Journal Line"; CustLedgEntry: Record "Cust. Ledger Entry")

var

GenJnlLine: Record "Gen. Journal Line";

begin

if GenJournalLine."External Document No." = '' then begin

GenJnlLine.Get(GenJournalLine."Journal Template Name", GenJournalLine."Journal Batch Name", GenJournalLine."Line No.");

GenJnlLine."External Document No." := CustLedgEntry."External Document No.";

GenJnlLine.Modify();

end;

end;

---

You can share this requirement with your developer or partner if you're not writing the code yourself.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No