Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / create item opening ba...
Business Central forum
Suggested answer

create item opening balances with item tracking information

(0) ShareShare
ReportReport
Posted on by Aspen 115
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:
Inventory and warehouse management
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,660 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 68,341 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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans