Re: discussion: video rentals

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

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

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 k

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

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 assetid

Re: discussion: video rentals

2011-09-22 Thread Paul Foxworthy
>>>> 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 Cat

Re: discussion: video rentals

2011-09-22 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, Bruce

Re: discussion: video rentals

2011-09-22 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-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 t

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 sup

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 showi

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

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

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 instan

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 9

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 addin