JAG

James Griffiths Ltd

Inventory report example

Example

Home
Contact
Clients
Downloads
Examples
Search
Links
About

PDA Version

Data Presented in a Report

The data for the has been loaded from the database. The colours are used to aid clarity on screen, they would not appear on the printed version.

See also:
Sales Report
A printable sales report subtotalled by customer.
Spreadsheet
Data loaded into an Excel spreadsheet. (Requires I.E. 4.0 and Excel 2000, or later.)
Tabulated Data
Data loaded into a table.
Adding and Updating Data in a Database
An example of adding an order to the Sales Database, from which this report has been generated.

Stores Inventory Report

Print Version

(Green = OK, Yellow = Low stock - on order, Red = Low stock - needs ordering, Grey = Discontinued)
Click on a supplier to see their details.

 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Beverages Chai Exotic Liquids 10 boxes x 20 bags £18.00 39 0 10 NO
Beverages Chang Exotic Liquids 24 - 12 oz bottles £19.00 17 40 25 NO
Beverages Chartreuse verte Aux joyeux ecclésiastiques 750 cc per bottle £18.00 69 0 5 NO
Beverages Côte de Blaye Aux joyeux ecclésiastiques 12 - 75 cl bottles £263.50 17 0 15 NO
Beverages Guaraná Fantástica Refrescos Americanas LTDA 12 - 355 ml cans £4.50 20 0 0 YES
Beverages Ipoh Coffee Leka Trading 16 - 500 g tins £46.00 17 10 25 NO
Beverages Lakkalikööri Karkki Oy 500 ml £18.00 57 0 20 NO
Beverages Laughing Lumberjack Lager Bigfoot Breweries 24 - 12 oz bottles £14.00 52 0 10 NO
Beverages Outback Lager Pavlova, Ltd. 24 - 355 ml bottles £15.00 15 10 30 NO
Beverages Rhönbräu Klosterbier Plutzer Lebensmittelgroßmärkte AG 24 - 0.5 l bottles £7.75 125 0 25 NO
Beverages Sasquatch Ale Bigfoot Breweries 24 - 12 oz bottles £14.00 111 0 15 NO
Beverages Steeleye Stout Bigfoot Breweries 24 - 12 oz bottles £18.00 20 0 15 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Condiments Aniseed Syrup Exotic Liquids 12 - 550 ml bottles £10.00 13 70 25 NO
Condiments Chef Anton's Cajun Seasoning New Orleans Cajun Delights 48 - 6 oz jars £22.00 53 0 20 NO
Condiments Chef Anton's Gumbo Mix New Orleans Cajun Delights 36 boxes £21.35 0 0 0 YES
Condiments Genen Shouyu Mayumi's 24 - 250 ml bottles £15.50 39 0 5 NO
Condiments Grandma's Boysenberry Spread Grandma Kelly's Homestead 12 - 8 oz jars £25.00 120 0 25 NO
Condiments Gula Malacca Leka Trading 20 - 2 kg bags £19.45 27 0 15 NO
Condiments Louisiana Fiery Hot Pepper Sauce New Orleans Cajun Delights 32 - 8 oz bottles £21.05 76 0 25 NO
Condiments Louisiana Hot Spiced Okra New Orleans Cajun Delights 24 - 8 oz jars £17.00 4 100 20 NO
Condiments Northwoods Cranberry Sauce Grandma Kelly's Homestead 12 - 12 oz jars £40.00 6 0 5 NO
Condiments Original Frankfurter grüne Soße Plutzer Lebensmittelgroßmärkte AG 12 boxes £13.00 32 0 15 NO
Condiments Sirop d'érable Forêts d'érables 24 - 500 ml bottles £28.50 113 0 25 NO
Condiments Vegie-spread Pavlova, Ltd. 15 - 625 g jars £43.90 24 0 5 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Confections Chocolade Zaanse Snoepfabriek 10 pkgs. £12.75 15 70 25 NO
Confections Gumbär Gummibärchen Heli Süßwaren GmbH & Co. KG 100 - 250 g bags £31.23 15 0 10 NO
Confections Maxilaku Karkki Oy 24 - 50 g pkgs. £20.00 10 60 15 NO
Confections NuNuCa Nuß-Nougat-Creme Heli Süßwaren GmbH & Co. KG 20 - 450 g glasses £14.00 76 0 30 NO
Confections Pavlova Pavlova, Ltd. 32 - 500 g boxes £17.45 29 0 10 NO
Confections Schoggi Schokolade Heli Süßwaren GmbH & Co. KG 100 - 100 g pieces £43.90 49 0 30 NO
Confections Scottish Longbreads Specialty Biscuits, Ltd. 10 boxes x 8 pieces £12.50 6 10 15 NO
Confections Sir Rodney's Marmalade Specialty Biscuits, Ltd. 30 gift boxes £81.00 40 0 20 NO
Confections Sir Rodney's Scones Specialty Biscuits, Ltd. 24 pkgs. x 4 pieces £10.00 3 40 5 NO
Confections Tarte au sucre Forêts d'érables 48 pies £49.30 17 0 10 NO
Confections Teatime Chocolate Biscuits Specialty Biscuits, Ltd. 10 boxes x 12 pieces £9.20 25 0 5 NO
Confections Valkoinen suklaa Karkki Oy 12 - 100 g bars £16.25 65 0 30 NO
Confections Zaanse koeken Zaanse Snoepfabriek 10 - 4 oz boxes £9.50 36 0 30 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Dairy Products Camembert Pierrot Gai pâturage 15 - 300 g rounds £34.00 19 20 20 NO
Dairy Products Fløtemysost Norske Meierier 10 - 500 g pkgs. £21.50 26 0 10 NO
Dairy Products Geitost Norske Meierier 500 g £2.50 112 0 20 NO
Dairy Products Gorgonzola Telino Formaggi Fortini s.r.l. 12 - 100 g pkgs £12.50 0 70 20 NO
Dairy Products Gudbrandsdalsost Norske Meierier 10 kg pkg. £36.00 26 0 15 NO
Dairy Products Mascarpone Fabioli Formaggi Fortini s.r.l. 24 - 200 g pkgs. £32.00 9 40 25 NO
Dairy Products Mozzarella di Giovanni Formaggi Fortini s.r.l. 24 - 200 g pkgs. £34.80 14 0 5 NO
Dairy Products Queso Cabrales Cooperativa de Quesos 'Las Cabras' 1 kg pkg. £21.00 22 30 30 NO
Dairy Products Queso Manchego La Pastora Cooperativa de Quesos 'Las Cabras' 10 - 500 g pkgs. £38.00 86 0 25 NO
Dairy Products Raclette Courdavault Gai pâturage 5 kg pkg. £55.00 79 0 50 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Grains/Cereals Filo Mix G'day, Mate 16 - 2 kg boxes £7.00 38 0 25 NO
Grains/Cereals Gnocchi di nonna Alice Pasta Buttini s.r.l. 24 - 250 g pkgs. £38.00 21 10 30 NO
Grains/Cereals Gustaf's Knäckebröd PB Knäckebröd AB 24 - 500 g pkgs. £21.00 104 0 25 NO
Grains/Cereals Ravioli Angelo Pasta Buttini s.r.l. 24 - 250 g pkgs. £19.50 36 0 20 NO
Grains/Cereals Singaporean Hokkien Fried Mee Leka Trading 32 - 1 kg pkgs. £14.00 26 0 0 YES
Grains/Cereals Tunnbröd PB Knäckebröd AB 12 - 250 g pkgs. £9.00 61 0 25 NO
Grains/Cereals Wimmers gute Semmelknödel Plutzer Lebensmittelgroßmärkte AG 20 bags x 4 pieces £33.25 22 80 30 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Meat/Poultry Alice Mutton Pavlova, Ltd. 20 - 1 kg tins £39.00 13 0 20 NO
Meat/Poultry Mishi Kobe Niku Tokyo Traders 18 - 500 g pkgs. £97.00 29 0 20 NO
Meat/Poultry Pâté chinois Ma Maison 24 boxes x 2 pies £24.00 115 0 20 NO
Meat/Poultry Perth Pasties G'day, Mate 48 pieces £32.80 0 0 0 YES
Meat/Poultry Thüringer Rostbratwurst Plutzer Lebensmittelgroßmärkte AG 50 bags x 30 sausgs. £123.79 34 0 25 NO
Meat/Poultry Tourtière Ma Maison 16 pies £7.45 21 0 10 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Produce Longlife Tofu Tokyo Traders 5 kg pkg. £10.00 4 20 5 NO
Produce Manjimup Dried Apples G'day, Mate 50 - 300 g pkgs. £53.00 20 0 10 NO
Produce Rössle Sauerkraut Plutzer Lebensmittelgroßmärkte AG 25 - 825 g cans £45.60 26 0 15 YES
Produce Tofu Mayumi's 40 - 100 g pkgs. £23.25 35 0 10 NO
Produce Uncle Bob's Organic Dried Pears Grandma Kelly's Homestead 12 - 1 lb pkgs. £30.00 15 0 10 NO
 Category  Product  Supplier Qty per Unit Unit Price Units in Stock On Order Reorder Level Disc'd
Seafood Boston Crab Meat New England Seafood Cannery 24 - 4 oz tins £18.40 123 0 30 NO
Seafood Carnarvon Tigers Pavlova, Ltd. 16 kg pkg. £62.50 42 0 10 NO
Seafood Escargots de Bourgogne Escargots Nouveaux 24 pieces £13.25 62 0 20 NO
Seafood Gravad lax Svensk Sjöföda AB 12 - 500 g pkgs. £26.00 11 50 25 NO
Seafood Ikura Tokyo Traders 12 - 200 ml jars £31.00 31 0 25 NO
Seafood Inlagd Sill Svensk Sjöföda AB 24 - 250 g jars £19.00 112 0 20 NO
Seafood Jack's New England Clam Chowder New England Seafood Cannery 12 - 12 oz cans £9.65 85 0 10 NO
Seafood Konbu Mayumi's 2 kg box £6.00 24 0 5 NO
Seafood Nord-Ost Matjeshering Nord-Ost-Fisch Handelsgesellschaft mbH 10 - 200 g glasses £25.89 10 0 15 NO
Seafood Röd Kaviar Svensk Sjöföda AB 24 - 150 g jars £15.00 101 0 5 NO
Seafood Røgede sild Lyngbysild 1k pkg. £9.50 5 70 15 NO
Seafood Spegesild Lyngbysild 4 - 450 g glasses £12.00 95 0 25 NO

More Examples