How to quickly list all products carried by a supplier?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

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
>
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

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
>>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

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
>>>
>>
>>

Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

Ray Barlow
In reply to this post by jonwimp
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
>>>
>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

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
>>>>
>>>
>>>
>>
>>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

jonwimp
In reply to this post by Ray Barlow
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
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

jonwimp
In reply to this post by David E Jones-2
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
Reply | Threaded
Open this post in threaded view
|

Re: How to quickly list all products carried by a supplier?

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/