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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Porting in Purchase Orders via Configuration Package

(1) ShareShare
ReportReport
Posted on by 787
Using BC 365 SaaS v23.4. We have a Sandbox environment where we have entered in a large number of Purchase Orders with the lines. The requirement is to import these into our Production company. So logically I thought to create a configuration package to perform the heavy lifting. My question involves the available fields in the Purchase Line table that I'm referencing. Our PO lines in our Sandbox company have defined Shortcut Dimension 3, 4, and 5 Codes that I have replicated over in Production. But when I look at the available fields in the Purchase Line table, I only see Global Dimension 1 Code and Global Dimension 2 Code listed. 
 
How can I also include Shortcut Dimension 3, 4, and 5 Code values when porting in these PO lines? I also see the Dimension Set ID field available, so I'm assuming I'd look to that. Although this isn't a blank slate for our Production company. There are existing Purchase Invoice lines in there and whatnot that already have Dimension Set ID values defined...
I have the same question (0)
  • Greg Kujawa Profile Picture
    787 on at
    I did run across a YouTube video that showed how the Shortcut Dimension 3-8 Codes can be added via Edit in Excel by adding those columns. So I suppose I'd do so in the Sandbox company, save off the results, and then go into Edit in Excel in the Production company to paste them in. Is this line of thinking correct?
  • Verified answer
    Valentin Castravet Profile Picture
    31,836 Super User 2025 Season 2 on at
    In the configuration package lines select the Dimensions as Columns field as true. If you have this checked off you can export/import shortcut dimensions.  
     
     
     
    Valentin Castravet
    Zander ERP Services
  • Greg Kujawa Profile Picture
    787 on at
    Yes that was exactly what I was looking for. Been working with these configuration packages going back to late 2021 and I never paid attention to that tiny column heading...lol. Thanks for the tip!

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,957 Moderator

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,245 Moderator

#3
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans