web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to Pass Custom Fie...
Small and medium business | Business Central, N...
Suggested Answer

How to Pass Custom Field Value from "Fixed Asset Journals" to "FA Ledger Entry" After Posting

(6) ShareShare
ReportReport
Posted on by Ahsan baig 123 155
I’ve added a custom field named "FA Quantity" to both the "FA Journal line" and "FA Ledger Entry" tables:
 
 
This "FA Quantity" field is visible and editable on the "Fixed Asset Journals" 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 FA 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! 🙌

fyi, i had perviously asked similar question for Gen. Journal Line 

https://community.dynamics.com/forums/thread/details/?threadid=0bcac2a1-f84c-f011-877a-7c1e52027a5f

however, for this one i am unable to find correct event subscriber.

 

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central migration
Microsoft Dynamics RMS
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,538 Super User 2025 Season 2 on at
    Good morning, afternoon, or evening depending on your location :)
    Hope you are well today!
     
    You're on the right track by adding the custom "FA Quantity" field to both the FA Journal Line and FA Ledger Entry tables. To ensure the value entered in the journal line is transferred to the ledger entry during posting, you’ll need to extend the posting routine using the appropriate event subscriber.
    Recommended Approach
    1. Use the OnAfterInsertFAEntry Event
    This event is triggered after a fixed asset ledger entry is created during posting. You can use it to transfer your custom field value.
    2. Sample AL Code for the Event Subscriber
    [EventSubscriber(ObjectType::Codeunit, Codeunit::"FA Journal Post-Line", 'OnAfterInsertFAEntry', '', false, false)]
    local procedure OnAfterInsertFAEntry(
        var FALedgerEntry: Record "FA Ledger Entry";
        FAJnlLine: Record "FA Journal Line";
        var GenJnlLine: Record "Gen. Journal Line")
    begin
        FALedgerEntry."FA Quantity" := FAJnlLine."FA Quantity";
        FALedgerEntry.Modify();
    end;

    Make sure both tables have the "FA Quantity" field defined with the same data type (e.g., Decimal).
    Additional Tips
    • If you're using a custom posting routine, ensure your event subscriber is registered in the correct codeunit (FA Journal Post-Line).
    • Always test in a sandbox environment before deploying to production.
    • If the OnAfterInsertFAEntry event doesn’t meet your needs, you can also explore OnBeforeInsertFAEntry or OnAfterPostFAJnlLine.
     
    Note: I collaborated with Copilot to help craft this response for clarity and completeness.
    Hope this helps some!
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 8,760 on at

    Hi Ahsan,

    You're asking how to pass a custom field "FA Quantity" from the FA Journal Line to the FA Ledger Entry table after posting. You've already added the field to both tables and made it editable on the journal page, which is a great start.

    To complete the flow, yes—you’ll need to extend the posting routine using an event subscriber. The right place to hook into is the codeunit that handles FA journal posting.


    Here's what we need

    1. Use OnAfterInitFALedgEntry in Codeunit FA Jnl.-Post Line
    This event is triggered when the FA Ledger Entry is initialized during posting. You can use it to transfer your custom field value.

    al
    [EventSubscriber(ObjectType::Codeunit, Codeunit::"FA Jnl.-Post Line", 'OnAfterInitFALedgEntry', '', true, true)]
local procedure OnAfterInitFALedgEntry(var FALedgerEntry: Record "FA Ledger Entry"; FAJnlLine: Record "FA Journal Line")
begin
    FALedgerEntry."FA Quantity" := FAJnlLine."FA Quantity";
end;
     

    Make sure:

    • The field exists in both tables with the same data type and field number (optional but recommended for TransferFields compatibility).
    • You’ve published the extension and restarted the service tier if needed.
     

    2. Optional: Use TransferFields for broader field mapping
    If you have multiple fields to pass, you can use TransferFields instead of assigning each manually. Just ensure field numbers and types match.

     

    Here’s a helpful link showing how to configure custom field flows between journal and ledger tables:

    Dynamics 365 Lab – How to flow/pass custom field values
    Directions for Partners – Field Transfer Techniques
    Microsoft Learn – Fixed Asset Journal Setup

    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

  • Suggested answer
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 1,282 on at
    Hii There as per requirement You can use event Form Codeunit 5604 > "Make FA Ledger Entry" > OnAfterCopyFAJnlLine . This is correct event through Assign Value In FA Ledger entry From JA Journal Line,
     
    As per using this event you can assign value.
    If You Found answer Mark It answered.
     
    Thank You .
    Kamal Khakhkhar
     
     
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans