Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bulk upload of serial ...
Small and medium business | Business Central, N...
Suggested answer

Bulk upload of serial numbers at warehouse receiving

(1) ShareShare
ReportReport
Posted on by October Sky 123
Is there a way to bulk upload a long list of serial numbers associated with an Item (up to 900) at warehouse receiving stage. Item tracking lines does not have an Edit in excel feature and we want it to be part of a routine receiving process so config package is not an option.
Categories:
Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,296 Super User 2024 Season 2 on at
    Bulk upload of serial numbers at warehouse receiving
    I think if the vendor is providing you with the serial numbers outside of the system, it seems like you already have data that needs to be maintained separately, regardless of how you choose to import it. If you're using Excel, you’d really only need two columns: the serial number and quantity. But at the end of the day, these are just suggestions to consider. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 72,202 Super User 2024 Season 2 on at
    Bulk upload of serial numbers at warehouse receiving
    However, this requires maintaining Excel data outside the system and then importing it.
    Every time, you need to modify the "Source ID", "Source Ref. No." and other fields according to the current warehouse receiving number. I personally think this is easy to make mistakes.
    If it is master data, there is no problem, but this is transaction data. . . .
    If you use power automate, you need to customize at least two or three APIs because there is no standard API.
     
    Hope this helps.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 11,478 Most Valuable Professional on at
    Bulk upload of serial numbers at warehouse receiving
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,296 Super User 2024 Season 2 on at
    Bulk upload of serial numbers at warehouse receiving
    You can also copy and paste serial numbers from Excel, provided your Excel data is organized with the same columns as the Item Tracking page or the page where you're entering the serial numbers. Otherwise, customization or a power automate flow works. If you frequently purchase from this vendor, it might be worth creating a custom import on the Item Tracking page to directly import the vendor's Excel file. 

  • October Sky Profile Picture
    October Sky 123 on at
    Bulk upload of serial numbers at warehouse receiving
    Thanks @Yun Zhu
    Your post got me thinking that since it is the Reservation Entry table (ID = 337) that gets populated, I could generate a power automate flow to upload a long list of serial numbers from sharepoint/spreadsheet to that table.. 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 72,202 Super User 2024 Season 2 on at
    Bulk upload of serial numbers at warehouse receiving
    Unfortunately, this cannot be done as standard and can only be customized. . .This is also the most troublesome part of BC/NAV's Item Tracking management, and there has been no improvement.
    For example:
    Dynamics 365 Business Central: How to create Item Tracking Lines automatically during an inbound transaction (Customization)
     
     
    Thanks
    ZHU
  • October Sky Profile Picture
    October Sky 123 on at
    Bulk upload of serial numbers at warehouse receiving
    Hi Valetin
    Not in this case, no barcode scanners. It is usually an irregular batch from 1 vendor but they do provide us the list of serial numbers upfront.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,296 Super User 2024 Season 2 on at
    Bulk upload of serial numbers at warehouse receiving
    Are you using barcode scanners? If you have that many serial numbers, it's common to use barcode scanners
     

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,420 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans