upload an excel spreadsheet and generate invoices through smartconnect

(0) Share

Report

Posted on by Community Member Microsoft Employee

Is it possible to use an excel spreadsheet to upload or import invoices into GP through Smartconnect? Currently we are using smart connect to upload general journals. Is there a specific template that can be used?

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (1)

Report

RE: upload an excel spreadsheet and generate invoices through smartconnect

Yes, SmartConnect can import invoices to GP with an Excel file as your data source. You don't specify which type of invoice (Payables, Receivables or Sales Order Processing) you wish to import but SmartConnect can do any of them. If you go to the eOne site http://www.eonesolutions.com/smartconnect/downloads/#templates, there are templates available to download for any of these.

If you weren't already using SmartConnect (it is a great tool), Integration Manager could also be used to import invoices into GP. Good Luck with your project.
mm123 2,535 on at

Like (0)

Report

RE: upload an excel spreadsheet and generate invoices through smartconnect

Buddhi,

if you are interested we could offer this solution, already we have a product to create Sales orders in GP from Excel or email attachments , this

solution could be extended to invoices. Please let me know.

samr@expsoltech.com