Sytze, The normal approach with all the systems I have ever dealt with and written is to have a UOM field (Unit of measure) which can be set up in a separate table to identify the physical number of items used. i.e DOZ => 12, PAIR => 2 etc.
Whether you use the UOM attached to an item and treat it as fixed or you allocate it at the time of entry doesn't matter as your stock holding should be in discrete physical units to allow for UOM tags to be assigned at will even to the same product. Either that or you actually assign a UOM tag to the physical stock as well as any assemblies. You have to use a UOM if you are dealing with BOM (Bill of Materials) in any way as the small items in assemblies are normally dispensed/allocated in packs, pairs etc... Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: 20 December 2016 22:21 To: profox <[email protected]> Subject: Unit quantities In my accounting/invoicing system, clients create product items. Let's say you sell Apples You can sell single apples apples in a carton (e.g. 25 apples per carton) cartons of apples on a pallet (e.g. 50 cartons per pallets) I would like to know how YOU handle the Quantity management. Do you create 3 different stock items or do you force people to enter 2 factors at invoice time. Qty and Factor, where factor can be (say) Single, Carton or Pallet. When you *see* your product profile, do you see 1125 apples, X cartons and Y pallets and Z singles? I hope I've explained this satisfactorily. If its NF, please forgive me. -- Kind regards, Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
