Can any one suggest me

ismailthesacrificer1@gmail.com

how to import data to Purchase Invoice from excel in nav

logger

Hi @ismailthesacrificer1@gmail.com,
The most widely used way is to use Excel Buffer table.

ismailthesacrificer1@gmail.com

Thanks logger

I tried and it shows error message as

sorenhinrup

Are you a super user? This message indicates that the user trying to load the excel sheet has rights limitations.

logger

@ismailthesacrificer1@gmail.com,
Why do you import data to tables with POSTED documents? All you need is to import your purchase invoice to purchase header (38)/purchase line (39) tables with appropriate document type (Invoice, I guess).

Also, please, do us a favour. When you create a new topic, please, shortly describe what you need in topic subjects but not "Can any one suggest me". For this topic you could write smth. like "Import Purchase Invoice to NAV". Doing this you save our time.

ismailthesacrificer1@gmail.com

Sorry Logger

Yes i need import Purchase Invoice to NAV

logger

@ismailthesacrificer1@gmail.com,
Then just use Excel Buffer to import to Purchase Header/Purchase Lines tables. That's quite easy.

ismailthesacrificer1@gmail.com

But I had written the code then i can able to print only header

lubost

1. Import to posted documents is generally wrong because you will lost integrity (Ledger Entries, dimensions)
2. Import to posted document, ledger entries requires extra permissions (SUPER is not enough) and requires developer's license to do that.

ismailthesacrificer1@gmail.com

Hi logger

i had taken two variables for insert data in the table but only one is inserting ....

ismailthesacrificer1@gmail.com

i had follow this https://community.dynamics.com/nav/b/dynamicsnavcloudfronts/archive/2017/04/17/importing-excel-file-in-microsoft-dynamics-nav-using-excel-buffer
but now for me data should move in two tables when i select import excel.