Stock

Finding, filtering and exporting your stock

The Stock screen: every stone and piece you hold, with what it cost and what it is worth — filter it, choose columns, total it and export it.

The Stock screen in Avirat: filters, totals and every stone with its cost and selling price
From the demo company — sample data. Click to see it full size.

How to

  1. Open Stock. Use the filters at the top — status, department, supplier, dates — and press Apply filters. Search finds a refno, lot, certificate number or supplier.
  2. Click a refno to open the stone: its details, photos, videos and certificates, and Trace — everything that ever happened to it.
  3. Columns chooses what you see; drag a column heading to move it. Group by adds subtotals per department, shape, supplier and more.
  4. Keep a layout you like with View → Save this layout as a new view.
  5. Export ▾ downloads everything the filters show — Excel or PDF, with or without prices. A PDF can carry a small photo per stone, to send a buyer.
  6. Tick stones, then Edit details to set the same grading — cut, polish, symmetry, fluorescence, lab, measurements — on all of them at once. Only the fields you fill in change; tick clear beside a field to blank it. Certificate numbers stay one stone’s own.
  7. Tick stones, then Hold to reserve them for a party; when every ticked stone is on hold the button reads Release hold.
  8. For a different value per stone — a lab’s certificate numbers, a new price list — tick them and press Update from Excel (see Item Master).

Good to know

  • Status In stock hides sold and returned stones; choose Any status to see everything.
  • Rates (cost and selling) are shown in each stone’s own currency — the one it was bought in — with a Currency column when your stones are in more than one. Stock at Cost and Stock at Selling, and the totals, are in your main currency.
  • Update Rap prices sets the Rap price of diamonds from your Rap price list; it never changes cost or selling price.
  • The global search at the top (Ctrl K) finds a stone, document or party from any screen — a piece by its HUID too.
  • A piece of jewellery’s HUID and Hallmark centre can be added any time under Hallmark & certificate. Unmake breaks a piece back into its stones and metal.

Open this screen in Avirat →

Related

Still stuck? WhatsApp or call us on +91 97262 88072, or use Help & support inside Avirat — we’ll see the screen you’re on.

Try it with your own stock

14 days free, everything switched on, no card needed.

WhatsApp us