Re: New (hidden) field on invoice: exchange rate

[Jacopo Cappellato]

Hans,




Jacopo


On Sep 9, 2008, at 10:14 AM, Hans Bakker wrote:

based on the additional information you have provided I don't see the need for the new field. You can just use the date in the payment and then lookup the proper exchange rate by date. Based on your workflow, if you are artificially creating the rate exchange based on a full payment against an invoice, then I'd suggest to create, from a customized service, a new record (with from/thru dates set) in the UomConversionDated entity and then just lookup that value.

Currently the exchange rate is taken from the exchange rate table using

the invoice date.
This new field is just to able to override that.
I would like to set this exchange rate at the moment the payment comes
in.

The payment and the invoice, at that point in time, have different

currency. Because of the exchange rate the invoice will still show the
correct foreign values.

regards,
Hans


On Tue, 2008-09-09 at 09:08 +0200, Jacopo Cappellato wrote:

currencies. The system will see that and will ask if the invoice should be fully applied or a part of it. If it is fully applied, the system can calculate the exchange rate and put that on the invoice so it will match the payment. I intend to convert the actual stored invoice to the 'home'

How is the exchange rate decided/set for a given invoice?
Is there a predefined rule (i.e. the invoice date) or it is a manual
process?

Jacopo

On Sep 9, 2008, at 8:10 AM, Hans Bakker wrote:

We have a requirement from the Thailand government that we have to do

the complete accounting in Thai currency...nothing special most
countries have that.

However the Thai government wants us to use the actual exchange rate
of
the invoice, when the payment comes in, which can vary by invoice.

So my question is, is there any objections if I add an exchange rate
field to the invoice which overrides the value in the exchange rate
table?

In this way the invoice can be shown in the initial foreign currency
and
in local currency with the correct values.

Regards,
Hans

--
Antwebsystems.com: Quality OFBiz services for competitive prices

--
Antwebsystems.com: Quality OFBiz services for competitive prices

smime.p7s
Description: S/MIME cryptographic signature