Use of Incoming Documents and Data Exchange Definitions to create Purchase Invoice from a CSV file

MBClarke

Hi, I have a client that is using the OCR Service without issue to create new Purchase Invoices from PDF files received. They would now like to use the Incoming document function to create Purchase Invoices from a CSV file received from the vendor in the format they supply.

Basically what they want is almost similar to the Configuration Package, but to send a CSV file to the Vendor with the columns required, then when they receive that back from the Vendors, use the incoming document function to create the invoice. The CSV file used could contain multiple lines from multiple vendors, and they would then like to have it create a new invoice for each vendor.

Is this possible?

Thanks,
Malcolm

SanderDk

Depending on you version you might need to code a bit but yes this is possible.
If the both have a pdf and the CSV (Or XML) file you can attach both to the incoming document

MBClarke

Thanks SanderDk. We are using Dynamics NAV 2017. DO you have any form of examples on how to do this, or in what direction I should go? A video or step by step guide?

I have searched the internet and cannot find anything out there to assist me in how to do this.

Thanks

SanderDk

Hi @MBClarke,
No sorry I have not a clear example of how to do it.
But you can have a look at how Microsoft have implemented Currency exchange.