Re: discussion: video rentals

2011-10-05 Thread Jacopo Cappellato
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

Re: discussion: video rentals

2011-10-05 Thread Hans Bakker
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

Re: discussion: video rentals

2011-10-04 Thread Hans Bakker
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

Re: discussion: video rentals

2011-10-03 Thread Jacopo Cappellato
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

Re: discussion: video rentals

2011-09-26 Thread 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

Re: discussion: video rentals

2011-09-23 Thread Hans Bakker
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

Re: discussion: video rentals

2011-09-23 Thread Adrian Crum
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,

Re: discussion: video rentals

2011-09-23 Thread Paul Foxworthy
this message in context: http://ofbiz.135035.n4.nabble.com/discussion-video-rentals-tp3835766p3835962.html Sent from the OFBiz - Dev mailing list archive at Nabble.com.

discussion: video rentals

2011-09-22 Thread Hans Bakker
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

Re: discussion: video rentals

2011-09-22 Thread Adrian Crum
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

Re: discussion: video rentals

2011-09-22 Thread Hans Bakker
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

Re: discussion: video rentals

2011-09-22 Thread Adrian Crum
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,

Re: discussion: video rentals

2011-09-22 Thread Hans Bakker
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.

Re: discussion: video rentals

2011-09-22 Thread Adrian Crum
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

Re: discussion: video rentals

2011-09-22 Thread Hans Bakker
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

Re: discussion: video rentals

2011-09-22 Thread Adrian Crum
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