Sending sales to 3e requires connecting to their software via an ODBC connection.

First of all we install the ODBC driver, following the instructions here.

*Attention there is a case that it does not run in 32bit and must be set to 64bit
Next we need to create the following views in the database:

Sales documents


Lines of sales receipts






The results consist of documents that include items that in custom field 1 have the phrase “3E”.


To check that it works correctly, we can download libre office and see if it connects to libre base. Below are the settings in libre base.

Codes for the EMDI database.

Enable Password required.