web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Upload initial stock i...
Small and medium business | Business Central, N...
Answered

Upload initial stock in bulk

(5) ShareShare
ReportReport
Posted on by xmp 153
Hi all,
 
We are implementing Business Central and came across the need to upload the stock of our items. All our items have a lot number. I have seen that with the Item Journal I can make a positive adjustment for every product. This is fine! The problem is that I have to manually go line by line entering all the lots. I tried editing it in Excel and specifying the lot number, but it gives me an error as it's a read-only field.
Configuration package is not an option as the lots for each line have to be entered in a temporary table.
 
Does anyone know a way in which I can upload the stock of our 2k+ items with lots? I'm 100% sure someone else had to face this problem in the past.
 
Thanks so much in advance!!
Kind regards,
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    KP - Solution Architect Technical Profile Picture
    KP - Solution Archi... 652 on at
    Upload initial stock in bulk
    Hi 
     
    A new action can be added on the Item List page to allow users to upload an Excel file containing Lot Numbers.
    Since the Lot Numbers are custom-defined (i.e., not auto-generated), using a Configuration Package will result in an error — "Lot No. does not exist."
    This customization will:
    Read the Excel file
    Create the Lot Numbers in Business Central if they do not already exist
    Assign the Lot Numbers to the corresponding items as per the file
     
     
    Hope this might help.
     
     
    Thanks,
    KP
  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,335 Super User 2025 Season 2 on at
    Upload initial stock in bulk
    Normally I prefer writing my process only code for this and that's the best way out with no error scope.
     
     
  • Verified answer
    Earl98 Profile Picture
    Earl98 154 on at
    Upload initial stock in bulk
    You can do this in standard BC by enabling the 'item tracking on lines' checkbox on the item journal batch.
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 7,511 Super User 2025 Season 2 on at
    Upload initial stock in bulk
    Method Lot Support Scalable Recommended For
    Web Service + Journal + Page 6510 ✅ ✅ Business teams with Power Automate or dev
     AL Code ✅ ✅✅ Partners/developers
    Config Package ❌ 🚫 Doesn’t support temp table for lots
    Manual Entry ✅ ❌ Small datasets only
     
    I would suggest  Item Journal + Item Tracking Lines via Web Services or AL Code
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    Andrés Arias Profile Picture
    Andrés Arias 4,164 Super User 2025 Season 2 on at
    Upload initial stock in bulk
    Hello,

    You can do it using the business central standard.

    In addition to the product loading by the Product configuration package, you must load the Mov. reservation - 307.
    This will add the corresponding batch code for each product in the lot tracking of the journal.

    I hope I can help.

    Best regards,

    Andres
  • xmp Profile Picture
    xmp 153 on at
    Upload initial stock in bulk
    Hi all
     
    Thanks for your responses. The easiest and most straight forward way was enabling the item tracking on lines in the journal batch. I had no idea this option existed, so much appreciated. With this option and editing in excel it gets super easy to get it done.
     
    Once again thank you all so much.
    Kind regards,

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,232

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,863

#3
Sumit Singh Profile Picture

Sumit Singh 2,819

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans