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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import Excel for Purch...
Small and medium business | Business Central, N...
Suggested Answer

Import Excel for Purchase Invoice

(0) ShareShare
ReportReport
Posted on by sweelian 75

I am trying Purchase Invoice with Configuration Package excel import. For one record, click 'import from excel', no error found. When click apply 'apply package', error is displayed. 

Message read as 'you do not have permission on TableData Purch....'. At User function for the id, insert permission and modify permission is 'indirect' for purchase invoice. I believe the error is related to these permission. Is there a way to enable the permission? I am using Trial version of D365 BC. 

Kindly advise. PI-import.jpg 

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Are you the administrator who setup the trial? I believe that user is able to alter permissions. For trial you might consider having SUPER permissions to remove any permission conflicts

  • Suggested answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,268 on at

    You cannot import posted documents through a configuration package.

    The licence error is about creating records in a table that can only be used by the system. I.E., when you post a purchase order.

    If your goal is to import draft purchase invoices that users will post later using BC, you need the different tables:

    Purchase Header (38)

    Purchase Line (39)
    Make sure you select Invoice in the field document type. This will allow you to create purchase invoices and not purchase orders when you apply the 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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 572 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 331 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 330 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans