DataExchange with EDI-OpenTrans

[eugenh]

Hi Community

is there anybody who uses OpenTRANS and iDempiere (ADempiere)?

• http://de.wikipedia.org/wiki/OpenTRANS
• http://www.opentrans.de/en/2.0detail

is there any interest on implementig an interface?

Regards
EUGen

[eugenh]

opentrans defines the following xml-documents

• RFQ (Request For Quotation, Angebotsanforderung)
• QUOTATION (Angebot)
• ORDER (Auftrag)
• ORDERCHANGE (Auftragsänderung)
• ORDERRESPONSE (Auftragsbestätigung)
• DISPATCHNOTIFICATION (Lieferavis)
• RECEIPTACKNOWLEDGEMENT (Wareneingangsbestätigung)
• INVOICE (Rechnung)
• INVOICELIST (Rechnungsliste)
• REMITTANCEADVICE (Zahlungsavis)

My idea is to marshal(unmarshal) iDempiere documents-net (eg. Order) to openTRANS-xml:

iDempiere-Order ---marshal---> openTRANS-ORDER.xml

and

openTRANS-ORDER.xml ---unmarshal---> iDempiere-Order with OrderLines, Products, ...

To do this we need a mapping to/from openTRANS-pojo and the standard JAXB-(un)marshaller:

iDempiere-Order ---map---> openTRANS-ORDER pojo's ---marshal---> openTRANS-ORDER.xml

[Jan Thielemann]

Shouldn't be so hard to implement this i guess. The more interesting thing is when you want to create these xml files? On a button press? With a process? Scheduled or on creation/completion?

[eugenh]

Hi Jan, thanks for interesr.

My first approach is only the unmarshal direction, because the business-workflow is a drop-shipment (see picture).
The customer (swimlane at the bottom) do an web-order. The processing and the delivery is done by a drop-ship-partner, who runs openTRANS (top-swimlane).
Our iDempiere/ADempiere-client gets the oT-order and a ot-dispatchNotification when the delivery is done.
We have to produce the AD-Order and finaly the AD-invoce.

So the AD-startpoint would be a process (periodically and/or button), Ithink.

regards EUGen

[Jan Thielemann]

I would suggest to run a process via scheduler every now and then. I would store the files in a special directory and after processing each file i would copy it to another directory. If your dropship partner could implement it, i would try to run the process via webservice instead of scheduler so you can process theses files directly.

[eugenh]

now we are productiv!

we have two Adempiere processes:

and 3 directories:

The first dir is filled with opentrans-Order via ftp-util.

• "CreateProducts" reads each-Order and creates new products if necessary and other related objects (price, uom, etc). We needs this objects fo create order-lines. The xml is moved to the next dir.
• "CreateOrder" does the main part. The opentrans-Items are mapped to Adempiere-order-lines. We have to archive the files from the "processed"-dir since they are documents.

What was the challenge?

• we have to find th right byuer (BP) - the information for this was the id or the seach-key or the name either. In same cases the information (only name) was ambiguous, so we send a message to the salesRep and put a BP-placeholder.
• we habe to find the corresponding price-list and tax for the product
• by the was we do an update on product descriptions and prices
• unfortunately we do not have the cost price in the opentrans-order (only the sales price), so we cannot calculate the actual marge

Regards to all
EUGen