Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Porting in Purchase Orders via Configuration Package

(1) ShareShare
ReportReport
Posted on by 289
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...
  • Greg Kujawa Profile Picture
    Greg Kujawa 289 on at
    Porting in Purchase Orders via Configuration Package
    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!
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,066 Super User 2024 Season 2 on at
    Porting in Purchase Orders via Configuration Package
    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
    Greg Kujawa 289 on at
    Porting in Purchase Orders via Configuration Package
    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?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans