Are you looking for an easy and inexpensive way to exchange electronic purchase orders and invoices with your small suppliers? Supplier portals are widely used to meet this requirement. But suppliers don’t like to use portals because they don’t like to rekey data into the different portal sites.
Our Microsoft Excel adapter offers an alternative to the traditional supplier portal approach. Suppliers can work directly in Excel to create, send and receive electronic purchase orders and invoices. There is no need to tab between different websites. There are no passwords or challenge questions to remember. And there is no rekeying of data.
The Excel adapter is easy to install and run. After registering online, your suppliers can download a lightweight plug-in. The plug-in installs additional tabs onto the Dynamic Ribbon Bar within the actual Microsoft Excel application. Then you are ready to start exchanging purchase orders and electronic invoices. Your suppliers already know how to use it, because it is the same familiar spreadsheet application that they use every day. It’s that easy.
Electronic Purchase Orders
Buyers create a purchase order in their ERP or e-procurement system. They send it to OpenText GXS in EDI, XML or the native ERP format. We convert it into an Excel file, then store it in our cloud-based file system. When the supplier clicks on the “Receive POs” button within Excel, the file is downloaded to their machine.
Suppliers can create an invoice from scratch or auto-populate the fields based upon the original purchase order. Once completed, the supplier simply hits the “Send Invoice” button within Excel and the file is uploaded. We translate the format for transmission into the buyer’s accounts payable application.
Edit, Copy, Paste, Save and Print
Suppliers can edit, copy, cut, paste and format purchase orders and invoices just as they might any other Excel workbook. The files can be saved locally to keep a record of any transactions or exported into a comma-delimited file. And, of course, users can format the workbook for printing if they need a hard copy.