Diamond Sales Solution

Key Features

• Complete tracking of sales along with estimate & stock list preparation with RFID (radio frequency identification) integration
• Prepare lists & jangads
• RFID implementation for estimates & other activities — place tagged stones on the RFID reader and the software identifies them automatically to build the list, instead of one-by-one selection; option to blink selected stones on the reader to locate/remove a particular stone
• Stock report with RFID implementation — scans stones placed on the reader and matches them against the stock list as found/not found in a single stroke
• Each & every stone wise sales & stock keeping
• Flexible pricing & discount system for sales
• Multiple screen/window at a time can be opened, kept open & switched from one to other unlike Tally
• Buyer/party master with Excel import option
• Agent & broker master
• Masters for assorter, shape group, shape, color, sub color, certification, clarity, sub clarity, combo size, culet, diamond group, parent group, discount size, fluorescence, girdle, group, inclusion pattern, open inclusion, table inclusion, lot no, luster, natts location, natts, cut, polish, rate profile, size, shade, symmetry, party wise payment terms
• Additional +/- terms mapping for cash, COD, 60 days fix, 90 days fix, 90/120/150/180 days DA
• Ready polish single-stone-wise packet preparation with diagram & technical details on each fold (diameter, length, width, total depth, pavilion %, pavilion angle, crown height, crown angle, table size, min/max girdle, open, milky, make, proportion, luster, fluorescence, culet, polish, symmetry)

Activity Modules

• Import stones from Excel (received from factory or bought elsewhere), and bulk update stone details from Excel
• Assorting, estimate, offer, jangad & sales modules
• Work-out module to calculate actual rate & discount by changing base rate/discount
• Transfer a group of stones to another group
• Send stones to agencies (GIA, HRD, IGI, RAPAPORT) and receive/record results & certification
• Upgrade/downgrade analysis comparing parameters (color, clarity, fluorescence, cut, polish, symmetry) before & after agency results

Reports

• Jangad preparation as per GST requirements
• Reports by shape, clarity, color, size, cut with detail & summary views
• ABC analysis tracking each stone’s movement between processes (factory receipt, assorting, estimate, sales, sales return)
• Stock statements & stone aging report
• Additional reports: stone details, sales analyses, in/out analyses, sales register, sales & current stock, matching pairs, periodical sales analysis, result analysis, GIA for pricing, weekly sales details, stone’s lab age calculation, and cost reports segmented by carat/certification status (Certified +35, Non Certified +35, Unassorted +35, Certified +20/+25, Unassorted +20/+25)

Technical Details

• Front End: Vb.Net
• Back End: SQL