Import sales invoices in to BC

(0) Share

Report

Posted on by MCadd

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:

Business Central

All responses (5)

Answers (1)

keoma 32,675 on at

Like (0)

Report

RE: Import sales invoices in to BC

when importing set field "docuemt type" in table sales header to "invoice".
MCadd 5 on at

Like (0)

Report

RE: Import sales invoices in to BC

Thank you, that makes sense
Verified answer

keoma 32,675 on at

Like (1)

Report

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 95 on at

Like (1)

Report

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 75 on at

Like (0)

Report

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.