Custom Field addition to Item Journal Line Table

(1) Share

Report

Posted on by Zafar LIT

UPDATE [2024-11-08]
It seems my code now works. So, the onbeforeInsertItemLedgerEntry event seems to work properly when flowing the field from the Item Journal Line to the Item ledger Entry table. I can also confirm that all three answers to this question are ways to allow the item to flow to the Item ledger entry. Thank you for the splendid responses. I learned so much more by just asking this question.

Hi All,

I was wondering is any of you have experience already with the following scenario:
I have added a custom field to the Item journal Line table and the Item Ledger Entry table.

I am now trying to get this field to be posted with the Item ledger Entry table when I use Post or Preview Posting.
I cannot seem to find the right subscription event.

Basically, what I am trying to do is when I fill in my custom field and preview the post I would expect to see the field copied over to the Item Ledger Preview postings. But it just does nto do that. Any help would be greatly appreciated.

Right now, I have tried the following event to get this done:

[EventSubscriber(ObjectType::Codeunit, CodeUnit::"Item Jnl.-Post Line", 'OnBeforeInsertItemLedgEntry', '', false, false)]
 

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps - Dynamics 365 Business Central: How to flow/pass custom field values | Dynamics 365 Lab

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

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

Like (1)

Report

Hi

If you are also working with item tracking, this could help you. Business Central - Add Custom Fields to Item Tracking Lines and flow the values to Item Ledger Entries | LinkedIn

Best

GR

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (1)

Report
Hi, try the following

codeunit 50122 EventHandler { [EventSubscriber(ObjectType::Codeunit, Codeunit::"Item Jnl.-Post Line", OnAfterInitItemLedgEntry, '', false, false)] local procedure OnAfterInitItemLedgEntry(var NewItemLedgEntry: Record "Item Ledger Entry"; var ItemJournalLine: Record "Item Journal Line"; var ItemLedgEntryNo: Integer); begin NewItemLedgEntry."ZY Test" := ItemJournalLine."ZY Test"; end; } tableextension 50122 ItemJournalLineExt extends "Item Journal Line" { fields { field(50000; "ZY Test"; Text[100]) { Caption = 'ZY Test'; DataClassification = CustomerContent; } } } pageextension 50122 ItemJournalExt extends "Item Journal" { layout { addafter(Description) { field("ZY Test"; Rec."ZY Test") { ApplicationArea = All; } } } } tableextension 50113 ItemLedgerEntryExt extends "Item Ledger Entry" { fields { field(50000; "ZY Test"; Text[100]) { Caption = 'ZY Test'; DataClassification = CustomerContent; } } } pageextension 50113 ItemLedgerEntriesExt extends "Item Ledger Entries" { layout { addafter("Document No.") { field("ZY Test"; Rec."ZY Test") { ApplicationArea = All; } } } }

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

Custom Field addition to Item Journal Line Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Custom Field addition to Item Journal Line Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates