title: calculation of units in dozen
body: <p>there are some Product whose quantity vary from one product to other in one carton<br>
  like in the quantity of three products in one carton given below</p>
  
  <pre><code>SKU     QUANTIT_SPECIFICATION (IN ONE CARTON)
  4545     7 DOZENS
  3455     9 DOZENS
  7856     2 DOZENS
  </code></pre>
  
  <p>GIVEN BELOW THE INTERFACE THROUGH STOCK KEEPER WILL ENTER STOCK QUANTITY</p>
  
  <pre><code>SKU      NAME            U1 - U2 - U3      
  4545     DISPRINE         2 -  3 - 4
  3455     strepsils        0 -  4 - 5
  7856     Detoll           9 -  4 - 0
  </code></pre>
  
  <p>WHERE</p>
  
  <pre><code>u1 is the number of carton 
  u2 is the number of dozens
  u3 is the number of pisces
  </code></pre>
  
  <p><strong>note</strong> user can enter quantity in any format <br>
  for example user enter quantity for 4545 like this </p>
  
  <pre><code>SKU      NAME            U1 - U2 - U3      
  4545     DISPRINE         0 -  0 - 84
  </code></pre>
  
  <p>or user can enter quantiy as </p>
  
  <pre><code>SKU      NAME            U1 - U2 - U3      
  4545     DISPRINE         0 -  7 - 0
  </code></pre>
  
  <p>or user can enter as </p>
  
  <pre><code>SKU      NAME            U1 - U2 - U3      
  4545     DISPRINE         1 -  0 - 0
  </code></pre>
  
  <p>in all cases user want to enter the one carton of 4545
  <strong>BUTT</strong> when audit officer wants to audit he just generate report of how much stock available the report must follow same quantity format like u1 u2 u3 but in report order always follow from u1 to u3 <br></p>
  
  <p>in stock available items of 4545 sku are 99 then report must be like this</p>
  
  <pre><code>SKU      NAME            U1 - U2 - U3      
  4545     DISPRINE         1 -  1 - 3
  </code></pre>
  
  <p><strong>HOW TO IMPLEMENT THIS IN DATABASE</strong></p>
  
  <p>is in sku table specification of how much dozens a carton can contain mention like this </p>
  
  <pre><code>sku(id, name , quantity_specification)
  </code></pre>
  
  <p>so that when stock keeper enter quantity software logic should be like this </p>
  
  <pre><code>first get the specification then match it with u1 u2 u3 multiply/ subtract and commit it to warehouse table 
  </code></pre>
  
  <p><br></p>
  
  <p><strong>any other shortcut to implement this</strong></p>
  
  <p><strong>give mechanism for this</strong></p>