Hi Jonatan,
From: "Jonatan Soto" <[email protected]>
Hello list,
I'm trying to implement the following scenario into Ofbiz but i prefer to
consult here firstly just in case it's possible to do it OOTB:
- Actors: Destination company, Source company, International Carrier,
Suppliers, Tax authorities
- In most cases a purchase order will be send by sea, but sometimes could
be send by air, it will depends of the urgency. The international carrier
will be the same using both methods.
- Money exchange commission and fees should be charged in some way to the
products. Whislist: I will develop a gateway to the ECB (European Central
Bank) to get the currency rate automatically updated every day. They provide
the mechanism to integrate this into any application through XML so I don't
think it will be very difficult.
If it's open (I hope so) it would be good to have this in OFBiz
- I have different suppliers in the source country and I often will make
orders grouping them. I usually use FCA incoterm but in some cases could be
EXW for different suppliers. EXW represents that my international carrier
picks up the order items and I will be charged for that.
1. Everytime a purchase order is generated and received by the supplier,
the items will be send to the international carrier warehouse located in the
source country. I also have control of a company, settled in the source
country, who will be the responsible of get the different invoices from the
suppliers, unify them and make one invoice using the source company details.
At this point port/airport charges of the source country will be applied.
2. So, when the purchase orders reaches the destination port/airport
charges of the will be applied. Once the orders successful passes the
pertinent controls, the purchase order will be stored in the warehouse of
the international carrier for a while. At this time some some taxes from the
destination country will be applied (VAT, duty tax).
3. Finally, the international carrier sends me the purchase order to my
destination warehouse and give me the invoice including all the expenses
mentioned before plus the freight expenses and the invoice previously
generated by my company of the source country. The freight expenses are
calculated in a different way depending on the service has been chosen, eg:
LCL (Groupage), FCL (Full container...)
By now, I've created all the parties but don't know how to relate each other
in order to get this things sorted. I would like to get the total cost for
each product automatically calculated considering the volume and weight of
the purchase order and all taxes, commissions, etc.
It is not my intention to get a free-consulting session. I merely want to
know what is possible to do OOTB and what is not, so any kind of answers
that provide me a guidance (even those require customization) are fine and I
will appreciate a lot. In fact I would like to include my experience about
this in the wiki (extracting this to a generic procedure). Perharps in HEMP
as a story for import/export?
I did not check but if not it would be good to have one, seems like you have
some elements...
Jacques
Thank you very much in advance.
