Purchase Order restricted only to suppliers in the same currency as the PO

[Guido Amarilla]

I have this situation

Approved Requirement of products to purchase.
Try to generate a purchase order
Select USD as currency for the PO
Go to Requirements select the product to include into the PO but get this error:

*SupplierProduct not found

I found that it is because I don´t have any supplier with prices in USD.

If I make the PO in the same currency as that supplier's price it
works OK ( ARS = Argentina Peso)

The problem is that I have products from the same Supplier that are in
ARS and others that are in USD (products made in Argentina vs imported
products).
To solve this problem I should make two PO, one in USD and other in
ARS. But I have no currency information in the requirements view.

I found that when you select a product to include in the PO from the
requirement screen, it  looks up the Suppliers that have the same
currencyUomId than the PO (getSupplierProduct in the file
ShoppingCart.java)

If I disable the restriction removing currencyUomId from the Map
params inside getSupplierProduct all the prices are inserted in the PO
as if they were in the same currency without performing any
conversion.

Which would be the recommended way to solve this without affecting
other parts of OFBiz?
I see two options:
a) Adding the Suppliers currency in the requirement view or filtering
the products according to the suppliers's price currency, to allow the
creation of a PO for each currency.
b) Performing the currency conversion when you select the products to
include in the PO from the requirements view.

Is this an issue for someone else?


Guido Amarilla
Córdoba, Argentina

[Si Chen-2]

I would say (a) is the right way to do it, since the relationship  
between supplier prices in different currencies is not necessarily  
governed by their exchange rates.  For example, a vendor might sell  
something for 100 euros and US$150, even though the conversion rate  
is about 1.275.

I think adding a currency to Requirement should be fairly  
straightforward.

On Nov 7, 2006, at 10:53 PM, Guido Amarilla wrote:

> I have this situation
>
> Approved Requirement of products to purchase.
> Try to generate a purchase order
> Select USD as currency for the PO
> Go to Requirements select the product to include into the PO but  
> get this error:
>
> *SupplierProduct not found
>
> I found that it is because I don´t have any supplier with prices in  
> USD.
>
> If I make the PO in the same currency as that supplier's price it
> works OK ( ARS = Argentina Peso)
>
> The problem is that I have products from the same Supplier that are in
> ARS and others that are in USD (products made in Argentina vs imported
> products).
> To solve this problem I should make two PO, one in USD and other in
> ARS. But I have no currency information in the requirements view.
>
> I found that when you select a product to include in the PO from the
> requirement screen, it  looks up the Suppliers that have the same
> currencyUomId than the PO (getSupplierProduct in the file
> ShoppingCart.java)
>
> If I disable the restriction removing currencyUomId from the Map
> params inside getSupplierProduct all the prices are inserted in the PO
> as if they were in the same currency without performing any
> conversion.
>
> Which would be the recommended way to solve this without affecting
> other parts of OFBiz?
> I see two options:
> a) Adding the Suppliers currency in the requirement view or filtering
> the products according to the suppliers's price currency, to allow the
> creation of a PO for each currency.
> b) Performing the currency conversion when you select the products to
> include in the PO from the requirements view.
>
> Is this an issue for someone else?
>
>
> Guido Amarilla
> Córdoba, Argentina

Best Regards,

Si
[hidden email]

[Si Chen-2]

Wait....Now thinking about it further--

a Requirement is fundamentally currency-less.  It is just a  
Requirement for something and can be filled by ordering in any  
currency or manufacturing in house.

The right answer might be to modify that screen which adds items from  
requirements during order entry to check that the quantity of the  
item is available in the currency of the purchase order.  This is  
just a user interface issue, not something which should require  
changing the data model either way.

On Nov 8, 2006, at 9:40 AM, Si Chen wrote:

> I would say (a) is the right way to do it, since the relationship  
> between supplier prices in different currencies is not necessarily  
> governed by their exchange rates.  For example, a vendor might sell  
> something for 100 euros and US$150, even though the conversion rate  
> is about 1.275.
>
> I think adding a currency to Requirement should be fairly  
> straightforward.
>
> On Nov 7, 2006, at 10:53 PM, Guido Amarilla wrote:
>
>> I have this situation
>>
>> Approved Requirement of products to purchase.
>> Try to generate a purchase order
>> Select USD as currency for the PO
>> Go to Requirements select the product to include into the PO but  
>> get this error:
>>
>> *SupplierProduct not found
>>
>> I found that it is because I don´t have any supplier with prices  
>> in USD.
>>
>> If I make the PO in the same currency as that supplier's price it
>> works OK ( ARS = Argentina Peso)
>>
>> The problem is that I have products from the same Supplier that  
>> are in
>> ARS and others that are in USD (products made in Argentina vs  
>> imported
>> products).
>> To solve this problem I should make two PO, one in USD and other in
>> ARS. But I have no currency information in the requirements view.
>>
>> I found that when you select a product to include in the PO from the
>> requirement screen, it  looks up the Suppliers that have the same
>> currencyUomId than the PO (getSupplierProduct in the file
>> ShoppingCart.java)
>>
>> If I disable the restriction removing currencyUomId from the Map
>> params inside getSupplierProduct all the prices are inserted in  
>> the PO
>> as if they were in the same currency without performing any
>> conversion.
>>
>> Which would be the recommended way to solve this without affecting
>> other parts of OFBiz?
>> I see two options:
>> a) Adding the Suppliers currency in the requirement view or filtering
>> the products according to the suppliers's price currency, to allow  
>> the
>> creation of a PO for each currency.
>> b) Performing the currency conversion when you select the products to
>> include in the PO from the requirements view.
>>
>> Is this an issue for someone else?
>>
>>
>> Guido Amarilla
>> Córdoba, Argentina
>
> Best Regards,
>
> Si
> [hidden email]
>
>
>

Best Regards,

Si
[hidden email]

[Guido Amarilla]

Thanks Si.

One more question (excuse me if I´m asking something obvious)

When I run the MRP a supplier is choosed for each product in the
requirement. If there are suppliers with different currencies for the
same product (or the same supplier), which one is selected for the
requirement?
Are the prices being compared by the same base currency, using the
exchange rates?

A requirement is a currency-less entity, but it has a suggested
supplier. That supplier was chosen because he can provide the lowest
price for that product. It doesn´t matter in which currency it is. Or
in case it matters, it should be possible to specify it at the MRP
process instance.

- I make electronic products. They use tens or hundreds of different
parts. In my case I have several suppiers and some products are
provided in ARS and others in USD. I can pay in any currency. A MRP
could easily generate hundreds of requirements for different suppliers
and different currencies for the same supplier. -

Regards

Guido Amarilla

2006/11/8, Si Chen <[hidden email]>:

> Wait....Now thinking about it further--
>
> a Requirement is fundamentally currency-less.  It is just a
> Requirement for something and can be filled by ordering in any
> currency or manufacturing in house.
>
> The right answer might be to modify that screen which adds items from
> requirements during order entry to check that the quantity of the
> item is available in the currency of the purchase order.  This is
> just a user interface issue, not something which should require
> changing the data model either way.
>
> On Nov 8, 2006, at 9:40 AM, Si Chen wrote:
>
> > I would say (a) is the right way to do it, since the relationship
> > between supplier prices in different currencies is not necessarily
> > governed by their exchange rates.  For example, a vendor might sell
> > something for 100 euros and US$150, even though the conversion rate
> > is about 1.275.
> >
> > I think adding a currency to Requirement should be fairly
> > straightforward.
> >
> > On Nov 7, 2006, at 10:53 PM, Guido Amarilla wrote:
> >
> >> I have this situation
> >>
> >> Approved Requirement of products to purchase.
> >> Try to generate a purchase order
> >> Select USD as currency for the PO
> >> Go to Requirements select the product to include into the PO but
> >> get this error:
> >>
> >> *SupplierProduct not found
> >>
> >> I found that it is because I don´t have any supplier with prices
> >> in USD.
> >>
> >> If I make the PO in the same currency as that supplier's price it
> >> works OK ( ARS = Argentina Peso)
> >>
> >> The problem is that I have products from the same Supplier that
> >> are in
> >> ARS and others that are in USD (products made in Argentina vs
> >> imported
> >> products).
> >> To solve this problem I should make two PO, one in USD and other in
> >> ARS. But I have no currency information in the requirements view.
> >>
> >> I found that when you select a product to include in the PO from the
> >> requirement screen, it  looks up the Suppliers that have the same
> >> currencyUomId than the PO (getSupplierProduct in the file
> >> ShoppingCart.java)
> >>
> >> If I disable the restriction removing currencyUomId from the Map
> >> params inside getSupplierProduct all the prices are inserted in
> >> the PO
> >> as if they were in the same currency without performing any
> >> conversion.
> >>
> >> Which would be the recommended way to solve this without affecting
> >> other parts of OFBiz?
> >> I see two options:
> >> a) Adding the Suppliers currency in the requirement view or filtering
> >> the products according to the suppliers's price currency, to allow
> >> the
> >> creation of a PO for each currency.
> >> b) Performing the currency conversion when you select the products to
> >> include in the PO from the requirements view.
> >>
> >> Is this an issue for someone else?
> >>
> >>
> >> Guido Amarilla
> >> Córdoba, Argentina
> >
> > Best Regards,
> >
> > Si
> > [hidden email]
> >
> >
> >
>
> Best Regards,
>
> Si
> [hidden email]
>
>
>
>
>

--