How to quickly list all products carried by a supplier?

[jonwimp]

How do I quickly list products by supplier? I can only do the reverse, ie find all suppliers for a
product.

Jonathon

[Ray Barlow]

You can list the products related to a supplier by facility but not by
supplier on it's own with any of the default screens.

screen: facility/control/ViewFacilityInventoryByProduct
i.e.
https://demo.dejc.com:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse

If you only have and run one facility then you are OK otherwise you'll
need to add a simple screen or reporting mechanism for that.

Ray


Jonathon -- Improov wrote:
> How do I quickly list products by supplier? I can only do the reverse,
> ie find all suppliers for a product.
>
> Jonathon
>

[jonwimp]

In other words, it's not possible to easily create a PO without knowing who the suppliers for a
particular product are. Right?

So, if a purchasing officer had hundreds of products to buy for the company, he/she would have to
keep a separate (not in OFBiz) list matching products to suppliers?

Jonathon

Ray Barlow wrote:

> You can list the products related to a supplier by facility but not by
> supplier on it's own with any of the default screens.
>
> screen: facility/control/ViewFacilityInventoryByProduct
> i.e.
> https://demo.dejc.com:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>
> If you only have and run one facility then you are OK otherwise you'll
> need to add a simple screen or reporting mechanism for that.
>
> Ray
>
>
> Jonathon -- Improov wrote:
>> How do I quickly list products by supplier? I can only do the reverse,
>> ie find all suppliers for a product.
>>
>> Jonathon
>>
>
>

[Jacopo Cappellato]

Jonathon,

please read carefully what Ray has suggested.

Jacopo

Jonathon -- Improov wrote:

> In other words, it's not possible to easily create a PO without knowing
> who the suppliers for a particular product are. Right?
>
> So, if a purchasing officer had hundreds of products to buy for the
> company, he/she would have to keep a separate (not in OFBiz) list
> matching products to suppliers?
>
> Jonathon
>
> Ray Barlow wrote:
>> You can list the products related to a supplier by facility but not by
>> supplier on it's own with any of the default screens.
>>
>> screen: facility/control/ViewFacilityInventoryByProduct
>> i.e.
>> https://demo.dejc.com:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse 
>>
>>
>> If you only have and run one facility then you are OK otherwise you'll
>> need to add a simple screen or reporting mechanism for that.
>>
>> Ray
>>
>>
>> Jonathon -- Improov wrote:
>>> How do I quickly list products by supplier? I can only do the reverse,
>>> ie find all suppliers for a product.
>>>
>>> Jonathon
>>>
>>
>>

[Ray Barlow]

In fairness you didn't mention POs screens first time round, so I didn't
have any idea that was in your mind.

Having had a quick look at the PO entry screen I think you could adjust
the lookup product feature to allow the filtering against a supplier, I
doesn't look like it would be a difficult job, and a lot easier than
managing separate lists!

In general there are other features related to requirements generation
based on sales orders and reorder values that can help generate POs for
you, but I've not used that myself so can only suggest you dig deeper in
that area and use a demo site to get a better feeling for it.

Ray



Jonathon -- Improov wrote:

> In other words, it's not possible to easily create a PO without
> knowing who the suppliers for a particular product are. Right?
>
> So, if a purchasing officer had hundreds of products to buy for the
> company, he/she would have to keep a separate (not in OFBiz) list
> matching products to suppliers?
>
> Jonathon
>
> Ray Barlow wrote:
>> You can list the products related to a supplier by facility but not by
>> supplier on it's own with any of the default screens.
>>
>> screen: facility/control/ViewFacilityInventoryByProduct
>> i.e.
>> https://demo.dejc.com:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>>
>>
>> If you only have and run one facility then you are OK otherwise you'll
>> need to add a simple screen or reporting mechanism for that.
>>
>> Ray
>>
>>
>> Jonathon -- Improov wrote:
>>> How do I quickly list products by supplier? I can only do the reverse,
>>> ie find all suppliers for a product.
>>>
>>> Jonathon
>>>
>>
>>
>
>

[David E Jones-2]

Yeah, there is stuff for this. Check out:

https://demo.dejc.com:8443/catalog/control/advancedsearch

There is also the same sort of thing (searching by supplier) in the  
order manager.

I'm really confused about what your process might look like though...  
How do you (or how does your client) normally do purchase orders? I  
guess I should be more specific: what data do you start with that  
feeds into the PO creation process?

-David


On Jan 5, 2007, at 1:01 PM, Ray Barlow wrote:

> In fairness you didn't mention POs screens first time round, so I  
> didn't
> have any idea that was in your mind.
>
> Having had a quick look at the PO entry screen I think you could  
> adjust
> the lookup product feature to allow the filtering against a  
> supplier, I
> doesn't look like it would be a difficult job, and a lot easier than
> managing separate lists!
>
> In general there are other features related to requirements generation
> based on sales orders and reorder values that can help generate POs  
> for
> you, but I've not used that myself so can only suggest you dig  
> deeper in
> that area and use a demo site to get a better feeling for it.
>
> Ray
>
>
>
> Jonathon -- Improov wrote:
>> In other words, it's not possible to easily create a PO without
>> knowing who the suppliers for a particular product are. Right?
>>
>> So, if a purchasing officer had hundreds of products to buy for the
>> company, he/she would have to keep a separate (not in OFBiz) list
>> matching products to suppliers?
>>
>> Jonathon
>>
>> Ray Barlow wrote:
>>> You can list the products related to a supplier by facility but  
>>> not by
>>> supplier on it's own with any of the default screens.
>>>
>>> screen: facility/control/ViewFacilityInventoryByProduct
>>> i.e.
>>> https://demo.dejc.com:8443/facility/control/ 
>>> ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>>>
>>>
>>> If you only have and run one facility then you are OK otherwise  
>>> you'll
>>> need to add a simple screen or reporting mechanism for that.
>>>
>>> Ray
>>>
>>>
>>> Jonathon -- Improov wrote:
>>>> How do I quickly list products by supplier? I can only do the  
>>>> reverse,
>>>> ie find all suppliers for a product.
>>>>
>>>> Jonathon
>>>>
>>>
>>>
>>
>>

[jonwimp]

Ray,

 > you could adjust the lookup product feature to allow the filtering against a
 > supplier, I doesn't look like it would be a difficult job, and a lot easier
 > than managing separate lists!

Hmm. Great suggestion. Will do that. Thanks!

> In general there are other features related to requirements generation
> based on sales orders and reorder values that can help generate POs for
> you, but I've not used that myself so can only suggest you dig deeper in
> that area and use a demo site to get a better feeling for it.

Doesn't look like this is working (OpenTaps 0.9.3, not OFBiz). Can't create a new Requirement. No
error messages either.

Jonathon

[jonwimp]

Well, I didn't use it in normal way. For testing, I tried to create a PO, hoped to key in a
product that has a supplier so I can complete a PO. Normally, a purchasing officer would know what
product he/she is purchasing, go to the product page, and find the suppliers, compare prices at a
glance, then create the PO.

The advanced search in Catalog module lets me search products by supplier. Thanks!

Jonathon

David E Jones wrote:

>
> Yeah, there is stuff for this. Check out:
>
> https://demo.dejc.com:8443/catalog/control/advancedsearch
>
> There is also the same sort of thing (searching by supplier) in the
> order manager.
>
> I'm really confused about what your process might look like though...
> How do you (or how does your client) normally do purchase orders? I
> guess I should be more specific: what data do you start with that feeds
> into the PO creation process?
>
> -David

[davidnwelton]

> Well, I didn't use it in normal way. For testing, I tried to create a PO, hoped to key in a
> product that has a supplier so I can complete a PO. Normally, a purchasing officer would know what
> product he/she is purchasing, go to the product page, and find the suppliers, compare prices at a
> glance, then create the PO.

Yuck, I hope not.  The system should help automate all that - that's
why we use computers after all:-)

--
David N. Welton
 - http://www.dedasys.com/davidw/

Linux, Open Source Consulting
 - http://www.dedasys.com/