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
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
Can you post a screenshot please?
Hi Stefano,
Yes. I've tried editing the fields using Excel but it appears the publish button is greyed out/disabled etc.
Thanks,
J
Have you set the Type field with a correct value?
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
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
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?
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
Have you try to import data with a RapidStart package? You can do that.
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
231,998
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
