How to Pass Custom Field Value from "Gen. Journal Line" to "FA Ledger Entry" After Posting

(5) Share

Report

Posted on by Ahsan baig 123

155

I’ve added a custom field named "FA Quantity" to both the "Gen. Journal Line" and "FA Ledger Entry" tables:

This "FA Quantity" field is visible and editable on the "Fixed Asset G/L Journal" page, allowing users to enter a value before posting.

Now, the journal posts successfully, but I need help with the following:

🔹 Goal:

I want the value entered in the "FA Quantity" field on the Gen. Journal Line to be transferred and saved into the "FA Quantity" field in the FA Ledger Entry table after the journal is posted.

❓Question:

How can I achieve this during or after the posting process? Do I need to extend the posting routine, and if so, which event/subscriber would be appropriate?

Any guidance, event suggestions, or examples would be greatly appreciated!

Thanks in advance! 🙌

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

Dynamics 365 Business Central migration

Microsoft Dynamics RMS

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Ahsan baig 123,

You need to use an Event Subscriber:
Look for the event publisher that is called before or during FA Ledger Entry insertion.

You can use the OnAfterCopyLinks event in Codeunit 447 "Record Link Management".

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (1)

Report

I will say try discovering the appropriate events from your side once, it will make you learn 5 different things as well. You can then let us know what all you tried and then all members are here to guide you. :)

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

This will help you to find the correct event subscriber

https://community.dynamics.com/forums/thread/details/?threadid=4756a3be-2c7b-ef11-a671-7c1e521c4bfb

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Verified answer

Ahsan baig 123 155 on at

Like (2)

Report

This worked for me.

[EventSubscriber(ObjectType::Codeunit, Codeunit::"FA Jnl.-Post Line", 'OnBeforePostFixedAssetFromGenJnlLine', '', false, false)]
local procedure OnBeforePostFixedAssetFromGenJnlLine(
GenJournalLine: Record "Gen. Journal Line";
var FALedgerEntry: Record "FA Ledger Entry";
FAAmount: Decimal;
VATAmount: Decimal;
GLRegisterNo: Integer)
begin
FALedgerEntry."FA Quantity" := GenJournalLine."FA Quantity";
end;

Was this reply helpful? Yes No