Jewelry Inventory Management Software

1. Your Logo Here Jewelry Inventory Management Software Welcome to a demonstration of Del Mar Data Systems Jewelry Inventory Management Software. Use the arrow keys to navigate between slides. (esc) to exit demo

2. Overview • Del mar data systems jewelry inventory management software is a multi-media based tool to assist the wholesale jewelry distributor with all aspects of managing jewelry inventory. Individual pieces are tracked using bar code technology from initial receipt through final sale. Maintain digital photos of your jewelry inventory. Each individual transaction is stored in a transaction history file. The status and location of any jewelry piece is easily identified. Take a physical inventory and the system will report any discrepancies. Comprehensive and flexible reporting allows data to be output in a variety of formats. There is even a report writer where you can construct your own reports or export data to other software packages.

3. Features & Benefits • The software is easy to learn and use. Screens are designed using a ‘point and click’ method. There is no need to memorize keystroke commands. • Pop-up boxes speeds up data entry and ensures data consistency. • Sub database menu gives user the flexibility to define data in pop-up boxes. • On-line tutorial teaches you the basics and gets you up and running in no time. • Print preview allow reports to be viewed to the screen prior to printing Go to the next slide for an overview of the system with sample screens and reports.

4. This is the primary screen used to enter and review data. To enter a new piece, click the NEW button and the system will automatically assign a unique serial number to the piece. Define specific details about the piece such as type, metal, weight, and purity. Define up to 5 stones per piece Click NEW to enter a new record: Use the DUPLICATE button to enter many pieces of the same design:

5. Some fields have pop-up boxes to validate data and speed up data entry. The data in these pop-up boxes is user defined. You only need to enter data that pertains to you and your business. Tab through a field and select from the pop-up

6. Define your own pop-ups in the sub-database menu. You control the data that shows in the pop-up boxes. Click on SUB DATABASE and the menu is displayed Select the sub database to be edited.

7. The system maintains the status of each jewelry piece. A piece is initially assigned the status of NEW. When a piece is sold, the status goes to SALE. When a piece is sent out on memo, the status changes to MEMO. When a piece is returned from memo or a sale, the status becomes RETURN. Each transaction date is logged and reference information is entered. Click on a button to perform a transaction. Click on HISTORY to view transaction history of the piece:

8. All inventory transactions from receipt to sale are tracked and recorded. The Inventory Transaction History screen displays all transactions for a single piece. This information is also available in report format A piece can go between sale, return, or memo(consign) an unlimited number of times IN or OUT of inventory The system logs a separate record record for each transaction

9. The Collection Summary screen displays all available pieces under a specific collection of designs. Click on the IMAGE button to view a photo of the piece Go to the next slide to see an example Click here to go to the inventory database & see detail information about the selected piece

10. Clicking on the IMAGE button on the INVENTORY LIST screen displays the digital photo of the piece. Click on the PRINT button to print the photo

11. System includes extensive reporting The Inventory report prints summary or detail inventory information. Report prints all inventory transactions for each piece from receipt thru final sale Develop your own reports to print or export to other applications Inventory cost report prints cost information and Inventory valuation.

12. Each report has a Report Selection screen to allow maximum flexibility in reporting. Reports have multiple start/end selections Filter out data and print in summary or detail format

13. Reports have a print preview option. Click here to go forward/backwards viewing pages to the screen Click here to output to printer

14. Images can also be printed on reports. Here is an example of the Inventory Detail Report with photo. These reports can optionally be printed in a format where they can be displayed on the Internet.

15. The system produces bar code labels used to tag each individual jewelry piece. Using a bar code reader to scan each piece insures data integrity and accuracy. Bar code readers are extremely accurate and will never scan a number incorrectly, thus reducing mistakes. The use of bar code technology is the most important element of the system. The system uses code 39 bar code format. This is the most common format used.

16. Other features • Physical inventory tool using bar-code. Scan each piece, report identifies missing pieces or piece counted not in inventory. • Ability to track pieces sent out on memo or consignment • Inventory cost report values your inventory. • Reports can be run with or without cost information. • Reports can be run so they can be published on a web-site.

17. Availability & Support • Jewelry Inventory Management software is available directly from Del Mar Data Systems • Del Mar Data Systems will assist with the installation, provide on-line training, and 30 days of technical support. Del Mar Data Systems 1442 Lincoln Ave. Suite 351 Orange, CA 92865 (714) 282-8639 Hit the (esc) key to end the demo