I would use the lowest common denominator, each, to track inventory on hand, and offer sales of 1, 2, 3, etc. with a few "convenience" quantities, like Dozen, Carton, Case, Pallet, Truck load, etc.

Just use a separate table, like "catalog" or something that has your Apple SKU reference and the quantity names (Dozen, Carton, etc.) and the each quantity that represents.

The purpose of the multiples is for the buyer's convenience (and maybe your warehouse people.)

When storing the actual quantity sold, I would store 1, 2, 3, 24, 48, 96, or whatever quantity was in the catalog table that references the quantity package name.

When printing packing slips or invoices, you can reverse the quantity to the package name from the catalog...if needed.

Mike Copeland

Sytze de Boer wrote:

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.

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:profox-bounces@leafe.com] On Behalf Of Sytze de Boer Sent: 20 December 2016 22:21 To: profox profox@leafe.com 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]

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.

On 20/12/2016 22:20, Sytze de Boer wrote:

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.

We normally sell clothes by the carton, so a carton may contain 25 pieces in different colours and sizes but we sell the whole thing as one item (SKU) with a single barcode and a profile code of "24" so we can calculate the price per piece. Recently we have started to sell these good individually to go as concessions stock. They must be then split by colour and size to make say another 6 new SKU codes which are single pieces and will have new barcodes.

Peter

This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.

www.whisperingsmith.com

Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715

London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960