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 694
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
    694 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,586 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
    694 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

News and Announcements

Season of Giving Solutions is Here!

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,798

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 812 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 717 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans