Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Import sales invoices in to BC

(0) ShareShare
ReportReport
Posted on by 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

  • keoma Profile Picture
    32,717 on at
    RE: Import sales invoices in to BC

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

  • MCadd Profile Picture
    5 on at
    RE: Import sales invoices in to BC

    Thank you, that makes sense

  • Verified answer
    keoma Profile Picture
    32,717 on at
    RE: Import sales invoices in to BC

    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. 

  • Suggested answer
    Ramesh G Profile Picture
    97 on at
    RE: Import sales invoices in to BC

    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.

  • Suggested answer
    Phil-RGS Profile Picture
    75 on at
    RE: Import sales invoices in to BC

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

    pastedimage1587146746391v1.png

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,207 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans