> I would like to know how YOU handle the Quantity management.
We store quantities as units everywhere, no decimals.
The stock items have a profile associated with them. The profile can be
factored or non-factored. It also holds a 'quantity decimals' value and
a 'factor quantity' value.
If non-factored, the 'quantity decimals' is used in the UI, reports and
calculations involving the quantity as:
qty / (10^qty decimals)
If factored, the 'factor quantity' is used in the UI, reports. So for
something that comes in packs of 1000 it is displayed everywhere in
0/000 form. So if I have 20 packs of 1000 in stock my in-stock figure
looks like 20/000 on screen and in reports. If split packs are allowed
by the profile, it might look like 20/500 which is 20.5 packs of 1000.
The actual in-stock figure held in the table there would be 20000 or
20500 respectively.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/1482316307.1053347.825763169.29bf3...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
