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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Flow DateCode Field To Lot No. Information List

(7) ShareShare
ReportReport
Posted on by 41
Hello,  
I hope this message finds you well.  
I am currently working on a request to add a DateCode field to the purchase line in our business system. The DateCode represents the manufacturing date of a lot, formatted as WWYY. My goal is to ensure that the values from the DateCode field on the purchase line flow through to the Lot No. Information Card, which is automatically created upon PO Posting. This feature is enabled through the Item Tracking Codes under the Lot section, specifically the "Create Lot No. Info on Posting" option.  
From my research, I understand that the Lot No Creation Method exists in Codeunit 6500, and I need to subscribe to it. However, for this subscription to work, the "Item Tracking Specification" record must include the DateCode field. Since the Item Tracking Specification is created through the Reservation Entry table, I realize that I need to add the DateCode to that table as well.  
Unfortunately, this approach does not seem to be working. I have spent over a week on this task without making significant progress. I have added the DateCode field to several tables, including the Tracking Specification, Reservation Entry, Lot No Information, Item Ledger Entry, Item Journal Line, and the Purchase Order Subform. Below, you will find a portion of the code I have written for the event subscription.  
I would greatly appreciate any assistance or clarification if I have misunderstood anything.  
Thank you for your help!
 
I hope you are doing well while reading this question.
 
In our business, I have got a request to add a DateCode field to the purchase line, DateCode is a code that symbols when was this lot manufactured in the format WWYY, however, I need to flow this DateCode field values from the purchase line, to the Lot No. Information Card, which is automatically created on PO Posting (This option was enabled from Item Tracking Codes -> Lot -> Create Lot No. Info on Posting. As per my research, I have understood the following: The Lot No Creation Method exist in Codeunit 6500, which you need to subscribe to. However, to subscribe, the record "Item Tracking Specification" Must have the DateCode Field in it, while the Item Tracking Specification gets created through Reservation Entry Table, this means that I need to add the Datecode to the Reservation Entry table. However, this approach does not seem to work, I have been working on this task for over a week, and still not reaching to any point, I have added the date code field to the following tables: Tracking Specification, Reservation Entry, Lot No Information, Item Ledger Entry, Item Journal Line, Purchase Order Subform below you can find a portion of the code that I have created for events subscription.
 
I appreciate any help in this, or any clarification if there's something that I misunderstood.
 
 
DateCode Code.png

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,679 Super User 2026 Season 1 on at
    Moved the question from the Dynamics 365 general to the Business Central forum as the details indicate it is about Dynamics 365 BC.
  • Verified answer
    YUN ZHU Profile Picture
    99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Dynamics 365 Business Central: How to create Item Tracking Lines automatically during an inbound transaction (Customization)
     
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans