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

Notifications

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... / Receive/Importing mult...
Small and medium business | Business Central, N...
Suggested Answer

Receive/Importing multiple Serial #'s via excel to a PO

(0) ShareShare
ReportReport
Posted on by Roy Myers 5

How can I Receive/Import multiple serial numbers/quantities to a PO for a given item from excel field containing these serial #?

TIA for any help!

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    I’ve seen this handled in the past by having an XMLPORT implemented so a CSV file can be selected and the content added to the tracking lines

    Previously discussed here: www.navug.com/.../viewthread

  • Suggested answer
    Roy Myers Profile Picture
    Roy Myers 5 on at

    Someone internally found the answer thought I'd share

    Using the Line/Item tracking/create custom SN # of lines, Highlight/copy/export to excel - add the grouping of ser # to the column with the line values, highlight and go back to already highlighted area and right click & paste...

    Walla! (-:

  • abazh Profile Picture
    abazh 10 on at

    Can you please a bit elaborate on the second part of your solution?

    I figured how to add as many lines with Create custom SN, and highlight it all.

    But when I export to excel and change 1,2,3,4,5,6.... serials to my real serials and try to past back it never lets me - either because of validation errors or just does nothing.

  • abazh Profile Picture
    abazh 10 on at

    Nevermind, I followed the description closely and everything worked. Thank you so much!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans