Example of a Report in Detail vs. Summary Format

Detail reports will show information at the level of each product in a store.  If you choose to run a Detail report on all the stores in a chain, then the report will have a page break when a new store’s products are reached.

The picture below is an example of the information you will see on a Detail report. 


                                                       Carton   Suggested   Order    Monthly   Product
                                            Batch         Qty    Cartons    up to    Average    Annual
Chain Store  Product                        Birth     On hand    to ship    Balance              Sales

TBS  001222  081716 MARLBORO LIGHT BOX      F 2007-05-30     5       26       31        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-06-07    18       13       31        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-06-14     7       24       31        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-06-21    13       18       31        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-06-28    13       18       31        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-07-04    21       13       34        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-07-11    40        0       40        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-07-18     0       37       37        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-07-23    29        5       34        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-08-02     7       28       35        80.68   968.1
             081716 MARLBORO LIGHT BOX      F 2007-08-09    16       19       35        80.68   968.1
TBS  001222  139879 MARLBORO BOX            F 2007-05-30     0       23       23        47.28   567.3
             139879 MARLBORO BOX            F 2007-06-07    22        0       22        47.28   567.3
             139879 MARLBORO BOX            F 2007-06-14    12        9       21        47.28   567.3
             139879 MARLBORO BOX            F 2007-06-21    11       10       21        47.28   567.3
             139879 MARLBORO BOX            F 2007-06-28    11       10       21        47.28   567.3
             139879 MARLBORO BOX            F 2007-07-04     0       23       23        47.28   567.3
             139879 MARLBORO BOX            F 2007-07-11    27        0       27        47.28   567.3
             139879 MARLBORO BOX            F 2007-07-18    12        9       21        47.28   567.3
             139879 MARLBORO BOX            F 2007-07-23    22        0       22        47.28   567.3
             139879 MARLBORO BOX            F 2007-08-02    15        6       21        47.28   567.3
             139879 MARLBORO BOX            F 2007-08-09     5       16       21        47.28   567.3


Summary reports will show information at the level of the store.  The picture below is an example of the information you will see on a Summary report. 


  Chain  Store    Batch        Carton     On hand  Suggested     Ship     Order up   Order up   
  group  xxx-xxx  Birth        qty        value $  cartons to    value $  to balance to value $ 
                               on hand    at cost  ship          at cost             at cost    
 
  TBS    1340090   2007-09-15       231   6,696.91         104   3,014.97         335   9,711.88
  TBS    1340090   2007-09-23       241   6,960.31         102   2,979.02         343   9,939.33
  TBS    1340090   2007-09-29       317   9,098.82          80   2,362.24         397  11,461.06
  TBS    1340090   2007-10-06       315   9,045.66          66   1,933.78         381  10,979.44
  TBS    1340090   2007-10-13       309   8,913.60          80   2,302.81         389  11,216.41
  TBS    1340090   2007-10-20       290   8,259.95          93   2,746.25         383  11,006.20
  TBS    1340090   2007-10-27       284   8,082.60          87   2,537.76         371  10,620.36
  TBS    1340090   2007-11-03       284   8,061.37          85   2,491.41         369  10,552.78
  TBS    1340090   2007-11-10       304   8,682.77          72   2,108.19         376  10,790.96
  TBS    1340090   2007-11-17       307   8,743.08          71   2,084.51         378  10,827.59
  TBS    1340090   2007-11-24       309   8,794.02          68   2,007.80         377  10,801.82
  TBS    1340090   2007-12-01       275   7,792.41          83   2,441.21         358  10,233.62
  TBS    1340090   2007-12-08       297   8,468.50          63   1,842.13         360  10,310.63