Importing invoices from Excel into Navision

glens73

Where I work we get a consolidated invoice from our biggest supplier each week via Excel.

This can list up to 1500 separate invoice lines which all have to be input individually, once each particular invoice agrees to the purchase order of the relevant job number.

Does anyone know of a way of importing the consolidated invoice and posting automatically to the purchase ledger providing the invoice agrees to the purchase order?, it is becoming particularly time consuming for the accounts payable team to input them.

garak

you can import the file (for example as csv) with using a dataport into a separate table (import table).
If the data are imported into these new table with the dataport, you / the customer can check (for example with a report) the datas.

Now to the work with the datas ...
You mean with importing invoices the payment for the invoices or are the "post datas" only a invoice for some orders (to create only posted invoices (not the payment of the invoice)) ?

Regards

glens73

garak wrote:

you can import the file (for example as csv) with using a dataport into a separate table (import table).
If the data are imported into these new table with the dataport, you / the customer can check (for example with a report) the datas.

Now to the work with the datas ...
You mean with importing invoices the payment for the invoices or are the "post datas" only a invoice for some orders (to create only posted invoices (not the payment of the invoice)) ?

Regards

I don't know what a dataport is.

It's just to post the invoice, providing it agrees to the po and ideally any that can't be posted would be on an exception report.

garak

do you (or a employee) have experience in Navision programming?
To import the datas from your file (or get the datas directly from excel without dataport) and post the datas automaticly you must develop some lines of code ...
So if you have no experience in NAV programming it would be a hard work

glens73

Unfortunately not, we have moved the accounts payable function from another location and the staff there were only temps as the company was only bought a year ago, so a severe lack of expertise all round.

I am looking into getting some experts in to look at it.

Do you know of anybody in particular that is good? (we are based in the NW of England)

garak

Contact MS the get the nearest NAV partner

http://www.microsoft.com/dynamics/partn ... rtner.mspx

Regards