Importing invoices from Excel into Navision

glens73
glens73 Member Posts: 4
edited 2008-10-12 in NAV/Navision Classic Client
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.

Comments

  • garak
    garak Member Posts: 3,263
    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
    Do you make it right, it works too!
  • glens73
    glens73 Member Posts: 4
    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
    garak Member Posts: 3,263
    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 :|
    Do you make it right, it works too!
  • glens73
    glens73 Member Posts: 4
    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
    garak Member Posts: 3,263
    Contact MS the get the nearest NAV partner

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

    Regards
    Do you make it right, it works too!

Categories