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... / Copy Items and Add an ...
Small and medium business | Business Central, N...
Suggested Answer

Copy Items and Add an Alpha Character

(0) ShareShare
ReportReport
Posted on by JE-20081519-0 3,933
Hi:
 
In Business Central, I need to copy multiple inventory items into new items.  The number of new items is 221!
 
The new items will be the same, except for one thing.  There needs to be an "I", at the beginning of the "new" item numbers.
 
Normally, I would simply export the items, replicate the data in Excel, and import through a Configuration Package.
 
But, with an import, there's no guarantee that newly imported items would contain such data as converted units of measure.
 
How can this copying be accomplished, without importing new items altogether?
 
Thanks!
 
John
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    Teagen Boll 2,340 Super User 2026 Season 1 on at
    You can use configuration packages but you will need to look at copying multiple tables. You mentioned converted units of measure as one thing you need. Here are some of the tables i'd include in a configuration package for new item creation.
    • Item (27) - this one is obvious
    • Item Variant (5401) - if you have variants
    • Item Unit of Measure (5404) - you will need this one based on your post
    • Item Substitution (5715) - if you have substitutes
    • Stockkeeping Units (5700) - if you have locations and SKUs used for items
    If you have price lists you will also need to look at those tables too.
     
    It won't be just a simple copy and paste for new items as there are plenty of differently tables connected to the Item table. As long as you make sure those are included you should be good to go.
     
    Best,
    Teagen Boll
    Social: LinkedIn

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,036 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,179 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 828

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans