You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jonathon -- Improov <jo...@improov.com> on 2007/01/04 04:27:42 UTC
How to quickly list all products carried by a supplier?
How do I quickly list products by supplier? I can only do the reverse, ie find all suppliers for a
product.
Jonathon
Re: How to quickly list all products carried by a supplier?
Posted by Jacopo Cappellato <ti...@sastau.it>.
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
>>>
>>
>>
Re: How to quickly list all products carried by a supplier?
Posted by David Welton <da...@gmail.com>.
> 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/
Re: How to quickly list all products carried by a supplier?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
Re: How to quickly list all products carried by a supplier?
Posted by David E Jones <jo...@undersunconsulting.com>.
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
>>>>
>>>
>>>
>>
>>
Re: How to quickly list all products carried by a supplier?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
Re: How to quickly list all products carried by a supplier?
Posted by Ray Barlow <ra...@makeyour-point.com>.
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
>>>
>>
>>
>
>
Re: How to quickly list all products carried by a supplier?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>>
>
>
Re: How to quickly list all products carried by a supplier?
Posted by Ray Barlow <ra...@makeyour-point.com>.
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
>