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

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

All responses (4)

Answers (1)

Verified answer

Ahsan baig 123 85 on at

Like (2)

Report

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

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

Sohail Ahmed 4,844 on at

Like (2)

Report

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

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

RockwithNav 7,265 on at

Like (1)

Report

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

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

Mohamed Amine Mahmoudi 24,592 Super User 2025 Season 1 on at

Like (1)

Report

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

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