Inventory Control Specs

Inventory Master

  • Diamonds, Gemstones, Jewelry and Manufactured items tracked and controlled in one form
  • Incorporates TJS Zeroshrink mass scanning technology to control and count inventory in minutes
  • Advanced Searches, Sorts, Locates, Filters and Grouping on all Diamond, Gemstone, Jewelry and Manufactured goods attributes
  • Diamond and Gemstone lookups include the following: Shape, Color, Clarity, Fluorescence, Polish, Symmetry, Laboratory, Cut Grade, Girdle, GIA Mappings, Gemstone Color, Line Maintenance
  • Jewelry lookups include the following: SKU, Sub Categories, Shape, Metal Type, Metal Color, Findings, Style, Collections, Line Maintenance
  • RAP pricing
  • Location tracking
  • Each piece of inventory can have it's own lot number, or belong to a parcel
  • Complete Transaction History of each Inventory Item
  • View GIA certifications directly from GIA website
  • Automatically fill in GIA certified stones attributes from GIA web site
  • Print and preview PDF format certificates from all laboratories
  • Multi sized images for screen and internet viewing
  • View Open Memos pertaining to active inventory
  • Export data to Excel Spreadsheet
  • 4 custom self designable Price List reports
  • Print and design Diamond Paper labels
  • Print and design Jewelry Tags
  • 3 dimensional Locations and Ownership information

Inventory Transfers

  • Transfer lots into and out of parcels of goods
  • Complete history of transfers shown in Inventory Master, including by whom and when the transfer was made

Inventory Adjustments

  • Adjust physical location and ownership (ours or on consignment from Vendor) of inventory items
  • Complete history of adjustments shown in Inventory Master, including by whom and when the transfer was made

Exports and Imports

  • Export inventory data to RAP, Polygon, and GemAccountant Trading floor web site
  • Import inventory data from partners so that their inventory can be shown on your inventory, RAP, Polygon and GemAccountant Trading floor
  • RAP subscribers may import RAP prices directly into the system, where RAP percentages are displayed based on these RAP prices

Reporting

  • Reports can be Printed on Paper, Exported to Excel for further analysis, EMailed, or saved as a PDF where appropriate
  • Some reports are designable by users
  • Jewelry labels
  • Diamond Paper labels
  • Sales analysis Data Mining shows views of inventory sales summary and detail, margins and net profit - Grouped by and sortable by LotID, LineID, Shape, CustomerID, SalesRep, SKU and VendorID
  • Manufactured Loose Goods sales analysis shows Loose goods content of sale and consumption of Manufactured goods - Grouped and sortable by Shape, Color, Clarity, SKU, Customer and Vendor. Exportable to Excel for further analysis
  • Manufacturing Outwork sales analysis shows Outwork content of sale and consumption of Manufactured goods - Grouped and sortable by Shape, LineID and Vendor
  • Manufacturing Component sales analysis shows Outwork content and percentages of Loose Goods, Finished Goods, Outwork and Metal of Manufactured goods - Grouped and sortable by Shape, LineID and Vendor
  • Inventory Aged Report shows inventory on hand or memo aged according to multiple criteria, such as Shape, Color, SKU, LineID, Category (Diamonds, Gemstones, Jewelry, Manufactured Goods, WIP)
  • Inventory Transaction History shows each inventory transaction filterable by dates and transactions types and
  • User Designable Price Lists
  • Inventory Ownership and Possession report gives you an analysis of where your inventory is located (memo or on hand) and who owns that inventory (on consignment from Vendors or owned by oneself)
  • Inventory Count worksheets facilitate physical inventory counts
  • Scanner reports are aimed at inventory control, and assisting of management of TJS Zeroshrink scanner tags
  • Scanner - On Hand vs Scanner report compares items just scanned from a location to where the Inventory Master "thinks" they are
  • Scanner - Inventory my Location report gives lists of locations of inventory per the Inventory Master
  • Scanner - Inventory Location History gives a complete history of items scanned