Re: [WebERP-developers] Stock Categories Properties issues

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

No I don't think so we will have to check for the same label as you 
suggest... unless anyone else has any smart ideas?

Phil

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

On 01/11/13 19:09, Pak Ricard wrote:
> Hi Phil:
>
> The detail t solve then is: How we detect if a category property "is 
> the same" as another category property in another category? The table 
> definition has a stkcatpropid but it's auto_incrment, so we can't use 
> it as key. Label is the best candidate if it's used as a code, so in 
> all categories, label should be exactly the same.
>
> is there any other way to solve it?
>
> Regards,
> Ricard
>
>
> 2013/11/1 Phil Daintree <ph...@lo... 
> <mailto: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  <tel:%2B64%20%280%29275%20567890>
>     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...  <mailto:Web...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>     ------------------------------------------------------------------------------
>     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...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> 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