95
Hello,
We are trying yo import Posted Invoices in tabel "Sales Invoice Header" during migration of data in to Business Central. When we validatie the data we get an error telling us we don't have the permissions for Adding or modifying this table. We have tried everthing we know (Tenant Admin, BC Essential license, BC Premium license, SUPER permissions,...) but we still get this error. How can we fix this ?
Thanks,
Peter
Hi,
From what system are you trying to import the data?
If you want to import the invoices for the financial transactions, you should rather import the financial transactions related to the invoices as G/L Lines.
Is what your choosing to do a good plan? You will have to handle VAT doing it this way. Something I am currently having to deal with for a client migrating many years of history. Most data migrations I’ve ever done for invoices involve only a journal so no document number problems as the posting change is optional. Also VAT not a problem as the invoice is for the gross amount as that’s what is payable by the customer.
If you’re concerned about having or producing copy invoices you can attach documents to journal lines and export those files later.
Hi Suresh,
Thanks for your answer. I now do understand that it is not possible to imput posted tables.
We need to import history invoice in BC but the Invoicenumbers should be the same as the originale invoice. We did succeed to import the the invoices as sales invoices (so not posted) but we still struggle with the invoicenumber. It should be great if we could tell the system to keep the invoice number of the imported sales invoice, but we can't achieve this.
Regards,
Peter
You cannot insert data into posted tables, those tables are protected. As others mentioned you need to create a sales invoice and then post and you can populate manual no.'s by setting the manual on the No. Series line.
https://www.inecta.com/working-with-the-number-series-in-microsoft-dynamics-nav-2015
Why are you trying to create posted invoices? are you planning to bring the history from another version or product?
Hi Duilio,
Thanks for your answer. I was afraid that this would be the answer.... If we first import them as Sales invoices and we post them we loose the original invoicenumber. So how is this usually solved when customers want to import their historic invoices ?
Kind regards,
Peter
You cannot import data in that tables. These can only be populated through postings procedure or you have to import sales invoices first and then post them.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (