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

All responses (3)

Answers (1)

Verified answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report
Custom Field addition to Item Journal Line Table

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
gdrenteria 12,546 Most Valuable Professional on at

Like (1)

Report

Custom Field addition to Item Journal Line Table

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

Valentin Castravet 24,961 Super User 2024 Season 2 on at

Like (2)

Report

Custom Field addition to Item Journal Line Table

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/