Re: [WebERP-developers] Stock Categories Properties issues

[Phil D. <ph...@lo...>]

Well I think you are right we probably should have implemented weight 
and volume as category properties as they are not really relevant to 
some items particularly service items. To deal with changing stock 
categories correctly I think the correct way is to copy the category 
properties across if they are not already set up against the new 
category and then the item category properties can come across correctly 
too then to the new category item properties.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 01/11/13 17:23, Pak Ricard wrote:
> Hi all:
>
> We are facing a problem with Stock categories properties and would 
> like to ind a good solution for everybody as now we keep the 
> dimensions of stockid as a property in table stockcatproperties.
>
> Problem comes when an item changes stock category (quite often in our 
> case), as we loose the data stored in stockcatproperties (because the 
> stockcatproperties are linked with categoryid).
>
> A solution comes rewriting all stockcatproperties, so if 
> stockcatproperties.label is equal in the new categoryid assigned to 
> the stockid, then we copy all the values to the new stkcatpropid
>
> Another solution can be adding the field size into stockmaster. All 
> physical items have a size (by definition). Services, software, etc 
> no, but also do not have net weight, volume, etc and we kkep this info 
> in stockmaster anyway.
>
> I think the most logical and universal solution is this second one, as 
> the first one will have problems if label is not written exactly the 
> same way, etc etc.
>
> Does everybody agree or there's any other option I'm missing here?
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Android is increasing in popularity, but the open development platform that
> developers love is also attractive to malware creators. Download this white
> paper to learn more about secure code signing practices that can help keep
> Android apps secure.
> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers