Small and medium business | Business Central, N...

create item opening balances with item tracking information

(0) Share

Report

Posted on by Aspen

382

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.

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/easier-create-opening-balances-item-tracked-inventory

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

Hi, yes, this is a new feature of BC and not available in NAV.

https://yzhums.com/36087/

In NAV, you can try the table below.

"Reservation Entry"

Here is an example of automatically creating an Item Tracking Line:

https://yzhums.com/7943/

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.

https://yzhums.com/wp-content/uploads/2023/10/ms-dynamics-nav-2013-item-tracking-wp-ap.pdf

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

create item opening balances with item tracking information

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

create item opening balances with item tracking information

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates