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 / Business Central forum / Data Import into Purch...
Business Central forum

Data Import into Purchase Line

(0) ShareShare
ReportReport
Posted on by opticshrew 145

Hi folks,

We've just adopted business central but are having some issues with data import. We've imported Purchase Headers but the actual Purchase Line entity appears to be read only.

Am I taking this the wrong way or am I missing something?

Thanks,

J

Categories:
Purchasing
Other
I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Have you try to import data with a RapidStart package? You can do that.

  • opticshrew Profile Picture
    opticshrew 145 on at

    Hi Stefano,

    Are these also referred to as configuration packages? We've tried this but for some reason the columns map incorrectly, even when using a template.

    Thanks,

    Jay

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Yes Configuration Packages. Have you try to create a package with Purchase Line table (39), export some data (just in order to have the template as model), then fill this template and re-import the data?

    Do you have errors?

  • opticshrew Profile Picture
    opticshrew 145 on at

    Hi Stefano,

    I've just created a template, package and imported by data. There doesn't appear to be any issues. I'm going to apply the package to ensure the data has been imported correctly.

    Thanks,

    J

  • opticshrew Profile Picture
    opticshrew 145 on at

    Hi,

    I've imported by data with no package errors. When trying to apply the data I get an error saying "Type must not be in Purchase Line".

    Any ideas?

    J

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Have you set the Type field with a correct value?

  • opticshrew Profile Picture
    opticshrew 145 on at

    Hi Stefano,

    Yes. I've tried editing the fields using Excel but it appears the publish button is greyed out/disabled etc.

    Thanks,

    J

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Can you post a screenshot please?

  • Community Member Profile Picture
    Community Member on at

    In order to import the purchase line you need to know the number of the purchase order that is store in the purchase header.

    My advise, create empty purchase orders (one for each vendor), note the PO number for each vendor.  Then add this PO number in the appropriate field in the purchase line.  At that point you can import the purchase line using Config Package

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans