Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 188
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,032 Super User 2024 Season 2 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 76,221 Super User 2024 Season 2 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans