discussion: video rentals
Locked
 
|
Now we can have rental products where the asset can be rented....
In this product type the product is a group of video rentals of the same rental price referring to many video assets. However now we also want to categorize these assets in order to display them on the e-commerce website. Is adding a fixedAssetid field to the ProductCategoryMember entity a solution? -- http://www.antwebsystems.com : Quality OFBiz support for competitive rates.... |
|
|
A fixed asset is an instance of a product, much like an inventory item
is an instance of a product. So, no - you do not want to connect a fixed asset to a product category. Product: Die Hard DVD Product Categories: DVD, Action, Drama, Bruce Willis Fixed Assets: 10010, 10011, 1012 -Adrian On 9/23/2011 6:20 AM, Hans Bakker wrote: > Now we can have rental products where the asset can be rented.... > > In this product type the product is a group of video rentals of the same > rental price referring to many video assets. > > However now we also want to categorize these assets in order to display > them on the e-commerce website. > > Is adding a fixedAssetid field to the ProductCategoryMember entity a > solution? > > |
|
but if you want a particular instance of a product?
I have products (as i described): > In this product type the product is a group of video rentals of the > same rental price referring to many video assets. Hans On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: > A fixed asset is an instance of a product, much like an inventory item > is an instance of a product. So, no - you do not want to connect a fixed > asset to a product category. > > Product: Die Hard DVD > Product Categories: DVD, Action, Drama, Bruce Willis > Fixed Assets: 10010, 10011, 1012 > > -Adrian > > On 9/23/2011 6:20 AM, Hans Bakker wrote: > > Now we can have rental products where the asset can be rented.... > > > > In this product type the product is a group of video rentals of the same > > rental price referring to many video assets. > > > > However now we also want to categorize these assets in order to display > > them on the e-commerce website. > > > > Is adding a fixedAssetid field to the ProductCategoryMember entity a > > solution? > > > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
|
|
Use FixedAssetProduct.
-Adrian On 9/23/2011 6:37 AM, Hans Bakker wrote: > but if you want a particular instance of a product? > > I have products (as i described): >> In this product type the product is a group of video rentals of the >> same rental price referring to many video assets. > Hans > > On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: >> A fixed asset is an instance of a product, much like an inventory item >> is an instance of a product. So, no - you do not want to connect a fixed >> asset to a product category. >> >> Product: Die Hard DVD >> Product Categories: DVD, Action, Drama, Bruce Willis >> Fixed Assets: 10010, 10011, 1012 >> >> -Adrian >> >> On 9/23/2011 6:20 AM, Hans Bakker wrote: >>> Now we can have rental products where the asset can be rented.... >>> >>> In this product type the product is a group of video rentals of the same >>> rental price referring to many video assets. >>> >>> However now we also want to categorize these assets in order to display >>> them on the e-commerce website. >>> >>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>> solution? >>> >>> |
|
|
sure can do that, but i want a specific instance showing in one category
and another instance showing in a different category...... Adrian, before you answer can you please think about it a bit? Regards, Hans On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: > Use FixedAssetProduct. > > -Adrian > > On 9/23/2011 6:37 AM, Hans Bakker wrote: > > but if you want a particular instance of a product? > > > > I have products (as i described): > >> In this product type the product is a group of video rentals of the > >> same rental price referring to many video assets. > > Hans > > > > On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: > >> A fixed asset is an instance of a product, much like an inventory item > >> is an instance of a product. So, no - you do not want to connect a fixed > >> asset to a product category. > >> > >> Product: Die Hard DVD > >> Product Categories: DVD, Action, Drama, Bruce Willis > >> Fixed Assets: 10010, 10011, 1012 > >> > >> -Adrian > >> > >> On 9/23/2011 6:20 AM, Hans Bakker wrote: > >>> Now we can have rental products where the asset can be rented.... > >>> > >>> In this product type the product is a group of video rentals of the same > >>> rental price referring to many video assets. > >>> > >>> However now we also want to categorize these assets in order to display > >>> them on the e-commerce website. > >>> > >>> Is adding a fixedAssetid field to the ProductCategoryMember entity a > >>> solution? > >>> > >>> -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
|
|
Hans,
The data model supports what you are trying to do if YOU think about it. There is no need to connect a fixed asset to a product category. -Adrian On 9/23/2011 6:44 AM, Hans Bakker wrote: > sure can do that, but i want a specific instance showing in one category > and another instance showing in a different category...... > > Adrian, before you answer can you please think about it a bit? > > Regards, > Hans > > On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: >> Use FixedAssetProduct. >> >> -Adrian >> >> On 9/23/2011 6:37 AM, Hans Bakker wrote: >>> but if you want a particular instance of a product? >>> >>> I have products (as i described): >>>> In this product type the product is a group of video rentals of the >>>> same rental price referring to many video assets. >>> Hans >>> >>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: >>>> A fixed asset is an instance of a product, much like an inventory item >>>> is an instance of a product. So, no - you do not want to connect a fixed >>>> asset to a product category. >>>> >>>> Product: Die Hard DVD >>>> Product Categories: DVD, Action, Drama, Bruce Willis >>>> Fixed Assets: 10010, 10011, 1012 >>>> >>>> -Adrian >>>> >>>> On 9/23/2011 6:20 AM, Hans Bakker wrote: >>>>> Now we can have rental products where the asset can be rented.... >>>>> >>>>> In this product type the product is a group of video rentals of the same >>>>> rental price referring to many video assets. >>>>> >>>>> However now we also want to categorize these assets in order to display >>>>> them on the e-commerce website. >>>>> >>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>>>> solution? >>>>> >>>>> |
|
|
Can you help me think in the right direction?
how can i show some fixedassets of the same product in one category and some of the assets in another category? Thank you in advance for your help. Regards,m= Hans On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote: > Hans, > > The data model supports what you are trying to do if YOU think about it. > There is no need to connect a fixed asset to a product category. > > -Adrian > > On 9/23/2011 6:44 AM, Hans Bakker wrote: > > sure can do that, but i want a specific instance showing in one category > > and another instance showing in a different category...... > > > > Adrian, before you answer can you please think about it a bit? > > > > Regards, > > Hans > > > > On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: > >> Use FixedAssetProduct. > >> > >> -Adrian > >> > >> On 9/23/2011 6:37 AM, Hans Bakker wrote: > >>> but if you want a particular instance of a product? > >>> > >>> I have products (as i described): > >>>> In this product type the product is a group of video rentals of the > >>>> same rental price referring to many video assets. > >>> Hans > >>> > >>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: > >>>> A fixed asset is an instance of a product, much like an inventory item > >>>> is an instance of a product. So, no - you do not want to connect a fixed > >>>> asset to a product category. > >>>> > >>>> Product: Die Hard DVD > >>>> Product Categories: DVD, Action, Drama, Bruce Willis > >>>> Fixed Assets: 10010, 10011, 1012 > >>>> > >>>> -Adrian > >>>> > >>>> On 9/23/2011 6:20 AM, Hans Bakker wrote: > >>>>> Now we can have rental products where the asset can be rented.... > >>>>> > >>>>> In this product type the product is a group of video rentals of the same > >>>>> rental price referring to many video assets. > >>>>> > >>>>> However now we also want to categorize these assets in order to display > >>>>> them on the e-commerce website. > >>>>> > >>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a > >>>>> solution? > >>>>> > >>>>> -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
|
|
If they are the same product, then they are in the same product categories.
I have three copies of the Die Hard DVD. Why would I want to put each one in a different product category? What you are suggesting doesn't make sense. It might help if you gave some specific examples of what you are trying to do. -Adrian On 9/23/2011 6:51 AM, Hans Bakker wrote: > Can you help me think in the right direction? > > how can i show some fixedassets of the same product in one category and > some of the assets in another category? > > Thank you in advance for your help. > > Regards,m= > Hans > > On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote: >> Hans, >> >> The data model supports what you are trying to do if YOU think about it. >> There is no need to connect a fixed asset to a product category. >> >> -Adrian >> >> On 9/23/2011 6:44 AM, Hans Bakker wrote: >>> sure can do that, but i want a specific instance showing in one category >>> and another instance showing in a different category...... >>> >>> Adrian, before you answer can you please think about it a bit? >>> >>> Regards, >>> Hans >>> >>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: >>>> Use FixedAssetProduct. >>>> >>>> -Adrian >>>> >>>> On 9/23/2011 6:37 AM, Hans Bakker wrote: >>>>> but if you want a particular instance of a product? >>>>> >>>>> I have products (as i described): >>>>>> In this product type the product is a group of video rentals of the >>>>>> same rental price referring to many video assets. >>>>> Hans >>>>> >>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: >>>>>> A fixed asset is an instance of a product, much like an inventory item >>>>>> is an instance of a product. So, no - you do not want to connect a fixed >>>>>> asset to a product category. >>>>>> >>>>>> Product: Die Hard DVD >>>>>> Product Categories: DVD, Action, Drama, Bruce Willis >>>>>> Fixed Assets: 10010, 10011, 1012 >>>>>> >>>>>> -Adrian >>>>>> >>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote: >>>>>>> Now we can have rental products where the asset can be rented.... >>>>>>> >>>>>>> In this product type the product is a group of video rentals of the same >>>>>>> rental price referring to many video assets. >>>>>>> >>>>>>> However now we also want to categorize these assets in order to display >>>>>>> them on the e-commerce website. >>>>>>> >>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>>>>>> solution? >>>>>>> >>>>>>> |
|
|
On Fri, 2011-09-23 at 06:56 +0100, Adrian Crum wrote:
> If they are the same product, then they are in the same product categories. > so that is limitation of the current datamodel?......looks like i have to create for every asset a product and a single inventory item of which many have the same price and other data, only the picture is different because i cannot store that on the fixed asset. Then i also better use the 'instanceOfProduct field on the fixed asset and do not need the fixedassetProduct entity and the recently added fixedAssetId field on the inventoryitem.. > I have three copies of the Die Hard DVD. Why would I want to put each > one in a different product category? What you are suggesting doesn't > make sense. > It might help if you gave some specific examples of what you are trying > to do. I have a single product : "DVD midlevel price" relating to 10,000 dvd's with different fixed asset titles in different genre's but the same rental price > > -Adrian > > On 9/23/2011 6:51 AM, Hans Bakker wrote: > > Can you help me think in the right direction? > > > > how can i show some fixedassets of the same product in one category and > > some of the assets in another category? > > > > Thank you in advance for your help. > > > > Regards,m= > > Hans > > > > On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote: > >> Hans, > >> > >> The data model supports what you are trying to do if YOU think about it. > >> There is no need to connect a fixed asset to a product category. > >> > >> -Adrian > >> > >> On 9/23/2011 6:44 AM, Hans Bakker wrote: > >>> sure can do that, but i want a specific instance showing in one category > >>> and another instance showing in a different category...... > >>> > >>> Adrian, before you answer can you please think about it a bit? > >>> > >>> Regards, > >>> Hans > >>> > >>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: > >>>> Use FixedAssetProduct. > >>>> > >>>> -Adrian > >>>> > >>>> On 9/23/2011 6:37 AM, Hans Bakker wrote: > >>>>> but if you want a particular instance of a product? > >>>>> > >>>>> I have products (as i described): > >>>>>> In this product type the product is a group of video rentals of the > >>>>>> same rental price referring to many video assets. > >>>>> Hans > >>>>> > >>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: > >>>>>> A fixed asset is an instance of a product, much like an inventory item > >>>>>> is an instance of a product. So, no - you do not want to connect a fixed > >>>>>> asset to a product category. > >>>>>> > >>>>>> Product: Die Hard DVD > >>>>>> Product Categories: DVD, Action, Drama, Bruce Willis > >>>>>> Fixed Assets: 10010, 10011, 1012 > >>>>>> > >>>>>> -Adrian > >>>>>> > >>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote: > >>>>>>> Now we can have rental products where the asset can be rented.... > >>>>>>> > >>>>>>> In this product type the product is a group of video rentals of the same > >>>>>>> rental price referring to many video assets. > >>>>>>> > >>>>>>> However now we also want to categorize these assets in order to display > >>>>>>> them on the e-commerce website. > >>>>>>> > >>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a > >>>>>>> solution? > >>>>>>> > >>>>>>> -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
|
|
The problem is, you are trying to mix the pricing model with the
product/fixed asset model. That will not work. Here is how I would set things up based on my understanding of video rentals: [Products / Fixed Assets] Product: Die Hard VHS Cassette Product Categories: VHS, Action, Drama, Bruce Willis Fixed Assets: 10009 Product: Die Hard DVD Product Categories: DVD, Action, Drama, Bruce Willis Fixed Assets: 10010, 10011, 1012 Product: Die Hard IIV DVD Product Categories: New Releases, DVD, Action, Drama, Bruce Willis Fixed Assets: 20020, 20021, 20022 [Pricing] Product Category: VHS Price: $1.00 per day Product Category: DVD Price: $1.50 per day Product Category: New Releases Price: $0.50 per day -Adrian On 9/23/2011 7:16 AM, Hans Bakker wrote: > On Fri, 2011-09-23 at 06:56 +0100, Adrian Crum wrote: >> If they are the same product, then they are in the same product categories. >> > so that is limitation of the current datamodel?......looks like i have > to create for every asset a product and a single inventory item of which > many have the same price and other data, only the picture is different > because i cannot store that on the fixed asset. > > Then i also better use the 'instanceOfProduct field on the fixed asset > and do not need the fixedassetProduct entity and the recently added > fixedAssetId field on the inventoryitem.. > >> I have three copies of the Die Hard DVD. Why would I want to put each >> one in a different product category? What you are suggesting doesn't >> make sense. >> It might help if you gave some specific examples of what you are trying >> to do. > I have a single product : "DVD midlevel price" relating to 10,000 dvd's > with different fixed asset titles in different genre's but the same > rental price > >> -Adrian >> >> On 9/23/2011 6:51 AM, Hans Bakker wrote: >>> Can you help me think in the right direction? >>> >>> how can i show some fixedassets of the same product in one category and >>> some of the assets in another category? >>> >>> Thank you in advance for your help. >>> >>> Regards,m= >>> Hans >>> >>> On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote: >>>> Hans, >>>> >>>> The data model supports what you are trying to do if YOU think about it. >>>> There is no need to connect a fixed asset to a product category. >>>> >>>> -Adrian >>>> >>>> On 9/23/2011 6:44 AM, Hans Bakker wrote: >>>>> sure can do that, but i want a specific instance showing in one category >>>>> and another instance showing in a different category...... >>>>> >>>>> Adrian, before you answer can you please think about it a bit? >>>>> >>>>> Regards, >>>>> Hans >>>>> >>>>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote: >>>>>> Use FixedAssetProduct. >>>>>> >>>>>> -Adrian >>>>>> >>>>>> On 9/23/2011 6:37 AM, Hans Bakker wrote: >>>>>>> but if you want a particular instance of a product? >>>>>>> >>>>>>> I have products (as i described): >>>>>>>> In this product type the product is a group of video rentals of the >>>>>>>> same rental price referring to many video assets. >>>>>>> Hans >>>>>>> >>>>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote: >>>>>>>> A fixed asset is an instance of a product, much like an inventory item >>>>>>>> is an instance of a product. So, no - you do not want to connect a fixed >>>>>>>> asset to a product category. >>>>>>>> >>>>>>>> Product: Die Hard DVD >>>>>>>> Product Categories: DVD, Action, Drama, Bruce Willis >>>>>>>> Fixed Assets: 10010, 10011, 1012 >>>>>>>> >>>>>>>> -Adrian >>>>>>>> >>>>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote: >>>>>>>>> Now we can have rental products where the asset can be rented.... >>>>>>>>> >>>>>>>>> In this product type the product is a group of video rentals of the same >>>>>>>>> rental price referring to many video assets. >>>>>>>>> >>>>>>>>> However now we also want to categorize these assets in order to display >>>>>>>>> them on the e-commerce website. >>>>>>>>> >>>>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>>>>>>>> solution? >>>>>>>>> >>>>>>>>> |
|
In reply to this post by hans_bakker
Hi Hans,
Of course you know the business problem better than anyone else does, but even so I tend to agree with Adrian. It seems to me "DVD midlevel price" is a pricing rule, not a product. I may well rent two instances of "DVD midlevel price" if they were different DVD titles (e.g. Die Hard 1 and 2). It would be most unlikely that I'd want to rent two instances of the same title. There are many business opportunities when you know what title a customer has rented. For example: "we can see that you have recently rented The Lord Of The Rings 1 and 2, here's a special offer for number 3", 'We can see you've rented several titles starring Bruce Willis, would you like to rent these others?". You might want to vary the pricing for some titles compared to others: have a Bruce Willis festival, or "the Star Wars Blu-Ray set is now out, time to increase/decrease the price of our DVDs". So while for the moment there are thousands of titles at the same price, there's no guarantee that will continue forever. You might want to track how popular a title is: "Die Hard 1 is very popular and never in stock, we should acquire a few more copies". There's a problem getting the products defined in Ofbiz in the first place, but one of the online DVD catalogues might help, and you have to put the fixed assets into Ofbiz in any case. Cheers Paul Foxworthy
--
Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ |
|
|
In reply to this post by Hans Bakker
Thanks Adrian and Paul for the valuable comments.
Taking all comments into account, we will do the following: (most is already done) 1. a single product can refer to one or more assets. (as is now) 2. An asset can refer to a single inventory item. (is added) 3. With this product type, the assetid will be shown on the orderitem, picklist and shipping slip which also will show the RA# (return auth #) 4. the item can be received in the facility -> receive return option. more info at: http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 Regards, Hans On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: > Now we can have rental products where the asset can be rented.... > > In this product type the product is a group of video rentals of the same > rental price referring to many video assets. > > However now we also want to categorize these assets in order to display > them on the e-commerce website. > > Is adding a fixedAssetid field to the ProductCategoryMember entity a > solution? > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
Re: discussion: video rentals
|
|
Hi Hans,
I have read the threads and the blog posts, and considering the requirements: * the need to maintain (serialized) inventory items and ship/receive them * the need to depreciate the items as assets I am wondering if you have considered the design of: * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item) * using fixed assets only for the depreciation Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code. Kind regards, Jacopo On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote: > Thanks Adrian and Paul for the valuable comments. > > Taking all comments into account, we will do the following: (most is > already done) > > 1. a single product can refer to one or more assets. (as is now) > 2. An asset can refer to a single inventory item. (is added) > 3. With this product type, the assetid will be shown on the orderitem, > picklist and shipping slip which also will show the RA# (return auth #) > 4. the item can be received in the facility -> receive return option. > > more info at: > http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 > > Regards, > Hans > > > On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: >> Now we can have rental products where the asset can be rented.... >> >> In this product type the product is a group of video rentals of the same >> rental price referring to many video assets. >> >> However now we also want to categorize these assets in order to display >> them on the e-commerce website. >> >> Is adding a fixedAssetid field to the ProductCategoryMember entity a >> solution? >> >> > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Alternative ofbiz website: http://www.ofbiz.info > http://www.antwebsystems.com : Quality services for competitive rates. > |
|
|
Hi Jacopo,
thanks for you comment. I did look into this but decided to not duplicate data in the system. In the case where assets for maintenance and depreciation is not connected with a serialized inventory item we will have a number of fields duplicated (cost, serial number etc) and we do not know where the asset is stored in inventory when not in use. Regards, Hans On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote: > Hi Hans, > > I have read the threads and the blog posts, and considering the requirements: > > * the need to maintain (serialized) inventory items and ship/receive them > * the need to depreciate the items as assets > > I am wondering if you have considered the design of: > > * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item) > * using fixed assets only for the depreciation > > Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code. > > Kind regards, > > Jacopo > > On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote: > > > Thanks Adrian and Paul for the valuable comments. > > > > Taking all comments into account, we will do the following: (most is > > already done) > > > > 1. a single product can refer to one or more assets. (as is now) > > 2. An asset can refer to a single inventory item. (is added) > > 3. With this product type, the assetid will be shown on the orderitem, > > picklist and shipping slip which also will show the RA# (return auth #) > > 4. the item can be received in the facility -> receive return option. > > > > more info at: > > http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 > > > > Regards, > > Hans > > > > > > On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: > >> Now we can have rental products where the asset can be rented.... > >> > >> In this product type the product is a group of video rentals of the same > >> rental price referring to many video assets. > >> > >> However now we also want to categorize these assets in order to display > >> them on the e-commerce website. > >> > >> Is adding a fixedAssetid field to the ProductCategoryMember entity a > >> solution? > >> > >> > > > > -- > > Ofbiz on twitter: http://twitter.com/apache_ofbiz > > Alternative ofbiz website: http://www.ofbiz.info > > http://www.antwebsystems.com : Quality services for competitive rates. > > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
Re: discussion: video rentals
|
|
Hi Hans,
I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)? Regards, Jacopo On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote: > Hi Jacopo, > > thanks for you comment. I did look into this but decided to not > duplicate data in the system. > > In the case where assets for maintenance and depreciation is not > connected with a serialized inventory item we will have a number of > fields duplicated (cost, serial number etc) and we do not know where the > asset is stored in inventory when not in use. > > Regards, > Hans > > On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote: >> Hi Hans, >> >> I have read the threads and the blog posts, and considering the requirements: >> >> * the need to maintain (serialized) inventory items and ship/receive them >> * the need to depreciate the items as assets >> >> I am wondering if you have considered the design of: >> >> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item) >> * using fixed assets only for the depreciation >> >> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code. >> >> Kind regards, >> >> Jacopo >> >> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote: >> >>> Thanks Adrian and Paul for the valuable comments. >>> >>> Taking all comments into account, we will do the following: (most is >>> already done) >>> >>> 1. a single product can refer to one or more assets. (as is now) >>> 2. An asset can refer to a single inventory item. (is added) >>> 3. With this product type, the assetid will be shown on the orderitem, >>> picklist and shipping slip which also will show the RA# (return auth #) >>> 4. the item can be received in the facility -> receive return option. >>> >>> more info at: >>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 >>> >>> Regards, >>> Hans >>> >>> >>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: >>>> Now we can have rental products where the asset can be rented.... >>>> >>>> In this product type the product is a group of video rentals of the same >>>> rental price referring to many video assets. >>>> >>>> However now we also want to categorize these assets in order to display >>>> them on the e-commerce website. >>>> >>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>>> solution? >>>> >>>> >>> >>> -- >>> Ofbiz on twitter: http://twitter.com/apache_ofbiz >>> Alternative ofbiz website: http://www.ofbiz.info >>> http://www.antwebsystems.com : Quality services for competitive rates. >>> >> > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Alternative ofbiz website: http://www.ofbiz.info > http://www.antwebsystems.com : Quality services for competitive rates. > |
|
|
Jacopo,
i do not know what to say, we already finished implemented it and what you propose we actually did however without the serialized inventory because we already have a serial number on the asset.... Regards, Hans On Wed, 2011-10-05 at 08:19 +0200, Jacopo Cappellato wrote: > Hi Hans, > > I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)? > > Regards, > > Jacopo > > On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote: > > > Hi Jacopo, > > > > thanks for you comment. I did look into this but decided to not > > duplicate data in the system. > > > > In the case where assets for maintenance and depreciation is not > > connected with a serialized inventory item we will have a number of > > fields duplicated (cost, serial number etc) and we do not know where the > > asset is stored in inventory when not in use. > > > > Regards, > > Hans > > > > On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote: > >> Hi Hans, > >> > >> I have read the threads and the blog posts, and considering the requirements: > >> > >> * the need to maintain (serialized) inventory items and ship/receive them > >> * the need to depreciate the items as assets > >> > >> I am wondering if you have considered the design of: > >> > >> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item) > >> * using fixed assets only for the depreciation > >> > >> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code. > >> > >> Kind regards, > >> > >> Jacopo > >> > >> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote: > >> > >>> Thanks Adrian and Paul for the valuable comments. > >>> > >>> Taking all comments into account, we will do the following: (most is > >>> already done) > >>> > >>> 1. a single product can refer to one or more assets. (as is now) > >>> 2. An asset can refer to a single inventory item. (is added) > >>> 3. With this product type, the assetid will be shown on the orderitem, > >>> picklist and shipping slip which also will show the RA# (return auth #) > >>> 4. the item can be received in the facility -> receive return option. > >>> > >>> more info at: > >>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 > >>> > >>> Regards, > >>> Hans > >>> > >>> > >>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: > >>>> Now we can have rental products where the asset can be rented.... > >>>> > >>>> In this product type the product is a group of video rentals of the same > >>>> rental price referring to many video assets. > >>>> > >>>> However now we also want to categorize these assets in order to display > >>>> them on the e-commerce website. > >>>> > >>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a > >>>> solution? > >>>> > >>>> > >>> > >>> -- > >>> Ofbiz on twitter: http://twitter.com/apache_ofbiz > >>> Alternative ofbiz website: http://www.ofbiz.info > >>> http://www.antwebsystems.com : Quality services for competitive rates. > >>> > >> > > > > -- > > Ofbiz on twitter: http://twitter.com/apache_ofbiz > > Alternative ofbiz website: http://www.ofbiz.info > > http://www.antwebsystems.com : Quality services for competitive rates. > > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Alternative ofbiz website: http://www.ofbiz.info http://www.antwebsystems.com : Quality services for competitive rates. |
Re: discussion: video rentals
|
|
I know that you have already implemented it, but I still don't understand your response to my original comment... but it is ok.
As regards the serialized/non-serialized item decision, the fact that you have decided to store the serial number in the FixedAsset entity and not in the InventoryItem entity is fine but I still think that the InventoryItem should be "serialized" (I am under the assumption that your InventoryItem cannot have a QOH greater than 1, if they are associated to FixedAsset with serial numbers in them). Regards, Jacopo On Oct 5, 2011, at 10:25 AM, Hans Bakker wrote: > Jacopo, > > i do not know what to say, we already finished implemented it and what > you propose we actually did however without the serialized inventory > because we already have a serial number on the asset.... > > Regards, > Hans > > On Wed, 2011-10-05 at 08:19 +0200, Jacopo Cappellato wrote: >> Hi Hans, >> >> I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)? >> >> Regards, >> >> Jacopo >> >> On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote: >> >>> Hi Jacopo, >>> >>> thanks for you comment. I did look into this but decided to not >>> duplicate data in the system. >>> >>> In the case where assets for maintenance and depreciation is not >>> connected with a serialized inventory item we will have a number of >>> fields duplicated (cost, serial number etc) and we do not know where the >>> asset is stored in inventory when not in use. >>> >>> Regards, >>> Hans >>> >>> On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote: >>>> Hi Hans, >>>> >>>> I have read the threads and the blog posts, and considering the requirements: >>>> >>>> * the need to maintain (serialized) inventory items and ship/receive them >>>> * the need to depreciate the items as assets >>>> >>>> I am wondering if you have considered the design of: >>>> >>>> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item) >>>> * using fixed assets only for the depreciation >>>> >>>> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code. >>>> >>>> Kind regards, >>>> >>>> Jacopo >>>> >>>> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote: >>>> >>>>> Thanks Adrian and Paul for the valuable comments. >>>>> >>>>> Taking all comments into account, we will do the following: (most is >>>>> already done) >>>>> >>>>> 1. a single product can refer to one or more assets. (as is now) >>>>> 2. An asset can refer to a single inventory item. (is added) >>>>> 3. With this product type, the assetid will be shown on the orderitem, >>>>> picklist and shipping slip which also will show the RA# (return auth #) >>>>> 4. the item can be received in the facility -> receive return option. >>>>> >>>>> more info at: >>>>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048 >>>>> >>>>> Regards, >>>>> Hans >>>>> >>>>> >>>>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote: >>>>>> Now we can have rental products where the asset can be rented.... >>>>>> >>>>>> In this product type the product is a group of video rentals of the same >>>>>> rental price referring to many video assets. >>>>>> >>>>>> However now we also want to categorize these assets in order to display >>>>>> them on the e-commerce website. >>>>>> >>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a >>>>>> solution? >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Ofbiz on twitter: http://twitter.com/apache_ofbiz >>>>> Alternative ofbiz website: http://www.ofbiz.info >>>>> http://www.antwebsystems.com : Quality services for competitive rates. >>>>> >>>> >>> >>> -- >>> Ofbiz on twitter: http://twitter.com/apache_ofbiz >>> Alternative ofbiz website: http://www.ofbiz.info >>> http://www.antwebsystems.com : Quality services for competitive rates. >>> >> > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Alternative ofbiz website: http://www.ofbiz.info > http://www.antwebsystems.com : Quality services for competitive rates. > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |