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 / Small and medium business | Business Central, N... / Import sales invoices ...
Small and medium business | Business Central, N...
Answered

Import sales invoices in to BC

(0) ShareShare
ReportReport
Posted on by MCadd 5

Hi

I want to import sales invoices into BC.  I created and ran a config package and all appears to have gone well except when applying and it brings up the error, 'you do not have the following permission on TableData Sales Invoice Header: Modify

this relates to table ID 112 and 113.

I looked at permissions and see that 112 and 113 and see that the system permissions cannot be changed.

Can Sales invoices be imported, should I be approaching it another way?  I am not importing as a Sales Journal as I want to import items not just GL's.  

Any input would be appreciated

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Phil-RGS Profile Picture
    Phil-RGS 75 on at

    Sounds like a permission issue - try first editing your user permissions to add "SUPER"  under your user permission set.  

    pastedimage1587146746391v1.png

  • Suggested answer
    Ramesh G Profile Picture
    Ramesh G 97 on at

    It seems you are importing data in the "Sales Invoice Header " table this table is not for direct data entry.

    You should import the data into the Sales Header and Sales line tables as document type Invoice then post them.

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    if you want to import open sales invoices, then target tables are 36 and 37.

    table sales invoice header is used for the posted sales invoices. 

  • MCadd Profile Picture
    MCadd 5 on at

    Thank you, that makes sense

  • keoma Profile Picture
    keoma 32,729 on at

    when importing set field "docuemt type" in table sales header to "invoice".

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans