Skip to main content
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... / create item opening ba...
Small and medium business | Business Central, N...
Suggested answer

create item opening balances with item tracking information

(0) ShareShare
ReportReport
Posted on by Aspen 368
Hi Experts,
 
I want to know if it is possible for user to create item opening balances with item tracking information via config package. In NAV, it seems user needs to populate the tracking info manually on the item journal line. Even user populates the tracking information in the excel template, it doesn't come through. I tried a few methods found online, but none seems to work for NAV. 
 
Could someone advise? 
 
MS has information on a newly released feature at below link, but I couldn't test without access to BC. 
 
 
Thanks! 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,446 Super User 2025 Season 1 on at
    create item opening balances with item tracking information
    It is possible to import opening balances with Lot/ExpirationDate/Serio No via configuration packages, through the Item Journal by using tables 83 and 336. 

    I would suggest You to create some 3 lines as examples, then export these tables from configuration package - analyze the data in table 336 and then You can re-create them for the other entries that You need. 
    It is a bit complex, as there are type fields that has numbers etc that impacts the Reservation entry table. Also You need to link reservation entry to specific Journal line number.

    Of course initially please test this in Sandbox/test environement.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 86,030 Super User 2025 Season 1 on at
    create item opening balances with item tracking information
    Hi, yes, this is a new feature of BC and not available in NAV.
     
    In NAV, you can try the table below.
    "Reservation Entry"
    Here is an example of automatically creating an Item Tracking Line:
     
    Although it is a bit old, the following is a detailed explanation of Item Tracking Line, I hope it can also give you some help.
     
     
    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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans