26.01.201026.01.2010.14 << back
Tips & Tricks – TecLocal 3.0: Save the typing! Excel Import for Orders with TecLocal and TecWeb
All TecLocal and TecWeb users without a connection to their enterprise resource planning (ERP) system can now send their orders quickly and easily with an Excel form. Instead of entering the order positions manually the data can be exported from the ERP system in Excel or CSV format and copied into the TecCom order form. This form can be uploaded in TecWeb or TecLocal. The order positions are transferred automatically to the system so that the order can be sent to the supplier.
Ordering with TecLocal
These steps are necessary to import orders in Excel format with the TecCom form:
- Change the name of the file OrderTransfer.ifd that is normally found in directory C:\TecCom\Client\OrderTransfer.
- After you have renamed the file download the new file “OrderTransfer.ifd” and save it in the same directory TecCom\Client\OrderTransfer. to download…
- Download the Excel order form: to download…
- Copy your order positions into the TecCom order form and save it in the CSV format.
- In TecLocal click on “Load MMS File” and select the order form.

- After successfully reading in the file you will be asked if you want to delete the file. Here you should click on “No.”

- The order positions will be automatically transferred. Just as with a normal order you can determine a number of settings such as the type of order (stock or express order), delivery date or shipment method. You can also enter your own order number.
Ordering with TecWeb
In TecWeb it is also possible to import orders with the TecCom order form. An important difference to TecLocal is that only stock order can be sent. The following steps are necessary:
- Download the file “OrderTransfer.ifd”: to download…
- In TecWeb select under Organisation the function “ERP File.”

- Select the file “OrderTransfer.ifd” and click on “Save.”
- Download the Excel order form: to download…
- Copy your order positions into the TecCom order form and save it in the CSV format.
- In TecWeb click under Market Place on Order Proposals and click on “Load ERP File.”

- Select the CSV order form you saved. Then click on “To Proposals.”

- Your order positions will be transferred and can be sent to the supplier.

Note: The TecCom order form is only suitable for orders up to 350 line items. If you would like to send orders with more positions please contact our Help Desk at support@teccom.eu or +49 (0)1805-65 65 56.
Our Help Desk is also standing ready if you have additional questions or technical difficulties. |