[WebERP-developers] Stock Categories Properties issues

[Pak R. <pak...@gm...>]

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