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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Update Bulk Item Traci...
Small and medium business | Business Central, N...
Suggested Answer

Update Bulk Item Tracing Data

(0) ShareShare
ReportReport
Posted on by DinoDavis 30

Hello,

I have been looking for information on how to import/update bulk item tracing data (Expiry/Lot) from excel on Retail Item Card. I have found lot of information on editing or adding attributes to existing items, but have been unable to find anything on updating items in bulk.

My situation: I have an excel file with item code, item tracking code, Serial Number series code, and expiration calculation formula. Adding them manually would take days.

Please let me know if you need more information to be able to assist.

Thank you!

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,165 Moderator on at

    If you are in Nav 2016 you either have to use configuration packages for this or have it customized.

    If you are unfamiliar with the configuration packages I will recommend you seek assistance from your partner.

    It is easy to mess up the item table if you are not confident in the procedures.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at

    Hi, The following information contains instructions for importing tables, hoping to help you.

    Configuration Packages - Item Journal with Lot Numbers - Dynamics 365 Business Central Forum Community Forum

    If you are considering customization, I hope the information below can give you some hints.

    How to create Item Tracking Lines automatically during an inbound transaction (Customization)

    https://yzhums.com/7943/

    Thanks

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,794 Moderator on at

    Hi,

    If the configuration package is working to achieve your requirement, then you have to go with the customization to pull the excel or CSV data .

  • DinoDavis Profile Picture
    DinoDavis 30 on at

    Hi All,

    Thanks for the support!. My system has configuration packages enabled and seeing some entries. Attaching the screenshot. If anyone could give me idea on  configuring packages or any links, I would be grateful.  I also do have a test environment for test scenarios.

    pastedimage1675760176717v1.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,165 Moderator on at

    Maybe this can be a good starting point for you:

    learn.microsoft.com/.../set-up-standard-company-configuration-packages

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at

    Hi, hope the following helps.

    NAV:

    https://stoneridgesoftware.com/how-to-harness-the-power-of-rapidstart-in-microsoft-dynamics-nav/

    BC:

    https://yzhums.com/4286/

    BC Docs:

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

    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!

Congratulations to the February Top 10 Community Leaders

These are the community rock 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