Shipping sales to 3e requires a connection to their software via an ODBC connection. First of all we install the ODBC driver, following the instructions here. Next we need to create the following views in the database:

Sales documents

Sales document lines

Items

Customers

The results consist of documents containing items having the phrase “3E” in the custom field 1.