Reference Manual For Diamond and Stone Inventory
Contents
1. Flag 102 Packet Hl4 DOSS UL arat oc DA o pl 1 05 Carat 0 a 103 Packet DES 10816626 g Lines 2 00 TS DU CH mW Enter the no of Enter quantity pieces accepted rejected 4 6 Generate Orders This feature helps user to generate orders for the diamond and diamond sets A list of the items for which the diamond is required along with their Shortage quantity is shown User can select multiple items for which the purchase orders are to be generated TO prepare purchase order for raw materials navigate to Module gt Production gt Transactions gt Generate Orders Raw Material Click on Generate PO a Generate PO By Vendor SO WO sg M Refresh I Show items in shortage I Select All D GC E SEH BRACELET 121 C S001 100224 4002870000 BRACELE 700 0 165 00 198 SE KR KI GH 198 Ss 5001 2572011 fos UBA 0 10 04 2010 Se or pn po Seeche ae pa EE EE Ca epes feiereg BRACELET1199 C 5001 ee 230 0 165 00 1 320 c A i em IS Ee 0 04 2010 BRACELET1199 C 5001 4003080000 BRACELE1 230 0 165 00 1 320 St 1 320 165 0E001 09 25 2011 100194 10 04 2010 10 04 2010 Ten EE A dE EE EE E E ease BRACELETI199 C S001 100244 4003110000 BRACELE 230 0 165 00 1 320 E001 09 25 2011 A 10 04 2010 10 04 2010 ch Select the diamond set for Enter Order which the orders are to be quantity PO no will be displayed after generated purchase order is generated Similarly purchas2. DIASPARK Reference Manual For Diamond and Stone Inventory Version 2 0 Diaspark Inc 200 Metroplex Drive Suit 401 Edison NJ 08820 Web www diaspark com User Guide Page 1of 20 Creation Date 09 16 11 Diamond and Stone Inventory V 2 0 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory Release Notice Author DeeptiKhurana Reviewed By Purva Telang Jatin Jain This document and the information contained herein are confidential to and the property of Diaspark Inc Unauthorized access copying and replication are prohibited This document must not be copied in whole or part by any means without the written authorization of Diaspark Inc This document should be used only for intended purpose only Diamond and Stone Inventory Page 2of 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory TABLE OF CONTENT 1 OVERVIEW EE 4 1 1 INF AO DAVO N CG 4 2 DIASPARK JEWEL DIAMOND amp STONE INVENTORY MODULE ask kk kk kk Kb Ke 4 3 SEIUPS aaa EE EE EE EE 5 3 1 STONE PARAMETER cccadecancaccncescoateccncaacs a dacde scan dase an aiia 5 3 2 STONE LOT MASTER EE 6 3 3 STONE FACET e dE E GER 6 3 4 STONE PACKET PARAMETER UPDATE cecececececacacacacavavuvavavavavavavavavavavavavavavavavavavanens 7 3 5 LAP oT RI 8 3 6 STONE SET CATEGORY seucncutcenacactusucwesacen dened cauauwsnecoucuustusuacevecuscues gesueceeenesdacatoeud 9 3 7 STONE CN KEE 9 3 8 UPDATE RAPAPORT PRICE
3. 609 23 226 46 RAND CHANNEF E D NA 0 11 5CC6 4 91 320 00 50 4 41 320 00 1 411 20 1411 20 RND INVISIBLF 12 D 1 10 d 1 482 99 274 01 30 74 1 426 26 137 070 29 803 287 22 Total Rows 5626 M Stock Overview gt Transaction This tab will show the details of only queried lots Here you can also have transactional overview of the lot i e inventory receipt transfer issue production stock summary and production sales invoice credit invoice memo memo return and quotation purchase invoice credit invoice memo memo return open memo summary by book weighted cost and by accounting period and Lot master Click on create Select the lot to create Select document type button to create document sales from the drop down the document quotation memo Query Summary Transaction LS zs Refresh Stock v een Customer CH Create Document I Quotation 7 Create Sort oo og oe linda a a a Hand CC6 DIAM RND 6 OOo 491 EEN Sidler 320 00 500 336 00 1000 3 us 411 5CC1 11 5 CCl DU 50 23 50 00 epo 5S2 f 100240 605 00 5 00 635 00 10 00 6 Total Rows 2 55 14 49 50 a II b Le Inventory Sales Purchase Summary Lot Master EEN Transactior 200909 1so2 100024 09 04 2009 320 00 12 80 4000120000 ABI0KG SQWSP 85 Transfer 200909 1502 100030 09 04 2009 320 00 o oo 4000410000 ANNYBND2217H Receipt 201109 emp 100123 09 08 2011 55 320 00 176
4. 63 2 000 oq 0 1800 oq 0 1800 oq i 1109072090 1 oqp gl P i 0 61 2 900 00 0 2700 a0 0 2700 oq 0 1109072119 1 DM W RD 0 55 2 200 oq 0 2000 ag a 2000 oq a 1109074991 1 DO ws2 P D i 0 33 2 700 o 0 2500 oo 0 2500 i i 1109075001 1 DM s2 RD i 0 65 2 200 oq 0 2000 ag 0 2000 oq 0 1109075610 1 DOP 512 RD i 0 61 2 500 00 0 2300 oc U 2300 oq 0 1109075663 1 D v52 RD i 0 ei 2 500 oq 0 2300 ag 0 2300 oq 0 91109075723 1 00 Wel RD i 0 60 2 800 00 0 2600 00 a 2600 00 0 ptal Rows 127 Total Inve ntory Arr Old 355 000 00 Select the packet of On selecting rapaport date which price is to be the new price gets updated displayed 4 Transactions This section helps user to understand different transactions available with Diamond amp Stone Inventory module and guides at entering values at various transaction screens available 4 1 Receipt Receipt is used to record all the purchases that user makes from various vendors and receive all the sales returns Receipt transaction enables to capture several details while receiving items To open receipt window click on Module gt Diamond amp Stone Inventory gt Transactions gt Receipt Diamond and Stone Inventory Page 100f 20 Creation Date 09 16 11 Confidential DIASPARX Diamond and Stone Diaspark Inc Inventory Select receipt type Enter from the drop down reference id Stone R
5. cccececccccuccacncusuavaceeusuavesueusvaresununvanesunuaeanenunuatanennnuags 10 d TRANSACCIONS crre 10 4 1 RECIPI or a E nne eugene ae sweecacaesereeaesueet 10 4 2 ERT 11 4 3 LOT PACKET ASSIGNMENT cceccccecacccucuavaceeueuavareeunuavatesunuaveneeunuatanenunuatanenuneananes 12 4 4 MEMO TO LAP a conetecccucuecsecnwenwwscosemeeyocas poewccneeceieese me ewavee pe eeeene none coeen se oiesneneeeaes 13 4 5 RETORN FROM LAB EN 15 4 6 EREECHEN 16 4 7 IMPORT RAPAPORT gl KEE 17 4 8 SHOW RAPPAPORT DATA EE 17 5 VIEW EE 17 5 1 STONE Ber wn ele 17 5 2 STONE PACKET STOCK EE 19 Diamond and Stone Inventory Page 30f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory 1 Overview This document aims at providing a functional overview and the usage of the Routing Process in Jewel ERP Software The document provides user with the specific instructions that will be needed to use Diamond amp Stone Inventory module This guide introduces the basic features of Diamond amp Stone Inventory module and describes each menu option in detail 1 1 Intended Audience This document is intended for the users of Jewel ERP 2 Diaspark Jewel Diamond amp Stone Inventory Module Inventory module keeps track of the diamonds and stone that are received and issued by user For efficiently managing the processes involved in Inventory Management diamonds and stones can be categorized so as the common attributes can be group
6. Header Tab 1 Lab 2 Copy From Enter Select Lab id Lab Memo Return 1 of 1 New by ADMIN on Sep 25 2011 00 00 00 L 1 Ie zel Add Edit Lab G O01 Return H Date i O0005 09 25 2011 ETHOG ical meie of ameca A C Pernod 201109 H ewt ork NY Ship Tos Po GO Rapaport Date Discount 00 00 0000 UU Header Detail Multiple Detail Single Footer Status Active Open Unposted Contact Name GEMOLOGICAL SCIENCE INTERNATIO Copy From Memo 7 DOC Addes PO Date Offer 200 _ _ _ Order Date or 27 2008 fity State Zip Country Receipt Wia 0972572011 Phone Fax racking H Received By OO Type Group Credit Limt Curert D Location Commission d Total Amt ESO Print Format A1 Price Level Discount 0000000 GoldDtPrice 0722972008 00 Message Id NA Enter memo no through which memo return is to be prepared Lab details are displayed Diamond and Stone Inventory Page 150f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory Detail Single tab 1 Accept pieces 2 Reject Pieces On entering the memo no Header tab the details get copied D iz Query List Add Edit Lab IG 001 Retum H Date M00004 09708 2011 Gemological Institute of America A C Period 201 109 Ship To Po G00 Rapaport Date Discount 0070070000 DU IN ew ork NY Header Detail Multiple Detail Single je Foot
7. purpose this issue type is used 4 3 Lot Packet Assignment Lot packet assignment is used to record receipt and issue transfers of lot packet To navigate to this link click on Module gt Diamond amp Stone Inventory gt Transactions gt Lot Packet Assignment Diamond and Stone Inventory Page 120f 20 Creation Date 09 16 11 Confidential DIASPARX Diamond and Stone Diaspark Inc Inventory Select transfer type from the drop down Lot Packet Assignment 62 of 62 New by ADMIN on Sep 26 2011 00 00 00 a Rog ex Add Edit Transfer Type From one lot to many lot Transfer Date TROS f 09 26 2011 Referance Id A C Period 201109 Location INA Referance 09 26 2011 Status Active Open Unposted Remark Transfer From Issue ltem Type Lot Size Packet Location Iss Issue Issue Issue Issue Remark i Pes Wi Price Amt Diamond 14CCEX 15 NA NA Caral Go 1 20 850 00 f 020 00 1 Format Type Type ile Fath Browse Upload J ltem Type Lot Size Packet Location Rec o text ln Diamond Mi DC 11 5 NA NA Carat Price Amt 850 00 1020 0 Rec Rec D ark 20 1020 00 Select format type Enter Select Enter Issue pcs issue wt receive pieces Click on upload button from the drop down lot id and receive wt at their respective columns to upload the file Issue pieces should be equal to receive pices 4 4 Memo to Lab Lab memo is prepared when di
8. the tets uaderthat packet This helps user to update consolidated details of Packets User can update the details by uploading an excel sheet containing the parameters To update packet parameter details click on Module gt Diamond amp Stone Inventory gt Setup gt Stone Packet Parameter Update Page 7of 20 Creation Date 09 16 11 Confidential lt DIASPARX Diamond and Stone Diaspark Inc Inventory 3 5 Parameters kal File Path Browse Copy Validate Lot Humber Status Remarks Shape Lab Setup Lab setup allows user to enter modify and view information of various laboratories at which stones are sent for testing purpose To open Lab setup window click on Module gt Diamond amp Stone Inventory gt Setup gt Lab Setup Enter lab code Once lab code is saved it cannot be edited Query List Add Edit Code AGS Vendor Status lActive Name AMERICAN GEM SOCIETY Contact Person IMR LENIN Address 250 Wrest S4rth Street City State Zip Newyork Mr foots Phone Fax 212 542 7078 Email fenn agscom Comments Enter Lab details here Diamond and Stone Inventory Page 80f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory 3 6 Stone Set Category With the help of this setup screen user can define categories for stone sets Stone sets of similar properties can be categorized To open Stone Se
9. 00 Sale D 00 Transfer 00 00 Unit Carat 3 3 Stone Packet Average Wt 000 Stone Size mm SievePlate Of D Size group Wt Group Group 1 PO Group 2 0 Group 3 Ir Group 4 0 ate rar Location INA Group 5 In this option packets are created containing certified stones Stone packet contains details about the characteristics of each unique packet like clarity color shape cut polish symmetry fluorescence lot and sub lots used along with details of certificates issue from the laboratory We can have a maximum of 2 Labs amp Certificate for a Packet We can also attach the Certificate File here amp can view it at any point of time If there is only one Packet against the Lot assigned to the Packet then that Lot will get updated with the changes on the Packet Master like Price color clarity Diamond and Stone Inventory Page 6o0f 20 Creation Date 09 16 11 Confidential DIASPARX Diamond and Stone Diaspark Inc Inventory Here we can define 10 Price levels for a Packet amp these Price will come on the Diamond Transaction Sales Purchase accordingly We can view all the transaction relating to the Lot at one place amp can navigate to the desired transaction through drilldown Also we can define 3 Web prices with web discounts To open Stone Packet setup click on Module gt Diamond amp Stone Inventory gt Setup gt Stone Packet Enter a unique packet id E
10. 00 4007760000 123 Issue 201109 502 100124 09 08 2011 N INA II 055 32000 176 00 4007760100 123 Productio 201109 em 100125 09 08 2011 A N noo 320 00 0 4007760200 123 201109 DE 100002 09 08 2011 0 320 00 176 00 4007760000 123 E E det Sub tabs Lot details can be Details of the selected lot viewed on the basis of is displayed on the basis these tabs of tab and sub tab Diamond and Stone Inventory Page 180f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory 5 2 Stone Packet Stock This screen helps user to view packet stock Through this screen user can not only view stock but can also track packet stages You can also create sales quotation and sales memo through the same screen just by selecting the packet and clicking the button With the drilldown facility you can have a detailed view of the packet This screen consists of the following tabs gt Summary This tab shows the stock summary consisting of packets weight quantity onhand memo in memo out stock average cost and total amount Filter Options E Stone Packet Info I N Lesch x Query Summary Transaction 10316959 GIA DOSS H S 640 46 46 4 33 10782813 i 0782813 Gis DOSS R E 1261 64 5 e 10989867 0989867 DAD oss D 639 3 452 pos fi109071540 mg SCH Sege 1109071847 mo mmer E e LL EEN 1109071847 mmomgr mom PF D s 3 19 15 EEN LE LZ 5
11. 2011 1 010 00 Message Id Enter ship Select Tans Type Shipping address of date from the drop down lab is displayed Detail Multiple Tab 1 Packet 2 Lot 3 Barcode 4 Pieces On entering packet id the lot id against that packet Enter no of packets gets populated to be sent La tab iviemo 19 OF 10 VIEW lr DY AUIVUIN OM Sep Vo ULL LOU 2 90 lo amp x Query List Add Edit Lab GO01 Memol Date i 00016 0970872011 Gemological Institute of Anjerica AIC Period 201109 Neaftork Ship Jo Po aon Discount 00700 0000 D Rapaport Date Kai e SE S ELE al a a Flag 101 Packe e ue ew 0816626 1 00 1 05Carat DOUV lL Q A VS1 Cert 10816626 Packet 5633 Gl D0SS 2637155 1 00 0 Carat DU OOJRD F W51 Cert 12637155 d N Line DU Barcode scanning can also be done Enter Select Packet id Diamond and Stone Inventory Page 140f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory 4 5 Return From Lab When goods sent on memo are returned from lab lab memo return is prepared Lab memo return can be prepared from lab memo directly by entering memo number at Copy From field Header tab and copying its all details To prepare lab memo return click on Module gt Diamond amp Stone Inventory gt Transactions gt Return from lab User has to enter values at the following important fields at the
12. 43 5 41 Pl J 1109072090 1109072090 1109072090 I 2088 D Si 5 52 5 48 we 81 64 1 21 Rows 129 a Packet stock details Packet details gt Transaction This tab will show the details of only queried packets Here you can also have transactional overview of the packet i e inventory receipt transfer issue production stock summary and production sales invoice credit invoice memo memo return and quotation purchase invoice credit invoice memo memo return open memo summary by book weighted cost and by accounting period and packet master Diamond and Stone Inventory Page Loof 20 Creation Date 09 16 11 Confidential DIASPARX Diaspark Inc Select the packet to create document sales quotation memo Refresh Stock v Customer H D Diamond and Stone Inventory Click on create button to Select document type create the document from the drop down reate Document sl Create Sort oa hela ll ll A eg GIA Gl4 DOS E E PE a EL E 1109072090 1109072090 1109072090 RD 331109074991 1109074991 1109074991 P 1109072119 1109072119 1109072119 R i 52 None 5 Thick Non Good Good ae i i m aa e A SL SC RW Wem w a pn pon pwo va l PD nn WS GENEE ES e Em EX G WS2 P THN STK THN MED THN MED 91109075001 1109075001 fi 109075001 RD e eher mme e e TS TN Nee eg E Ke eg Kees Sales Purchase Summary Packet Master Ledger Gl4 DOSS
13. Gl4 DO0SS Transaction Transfer Receipt Production fi Details of the selected packet is displayed on the basis of tab and sub tab Packet details can be viewed on the basis of these tabs ub tabs gt Reports User can view following reports 1 Certificate inventory spot report 2 Certificate price report Price Flag Cost d Print FL CUT MEASUREMENTS MEMO DAYS DATE SHAPE WEIGHT COLOR CLARITY LAB TABLE DEPTH POLISH SYM MEMO 86 40Go0d Good 56 10 Good 56 40V Good Good 61 40VG 63 50VG 63 30EX 62 20GD 64 00VG 60 60EX 62 50VG None Mediun 433K 3K 3 31 D2 XLHX29 446X452 X 2 54 3 36 X 5 39 X 3 30 549K 5 44 3 47 ofS X 5 77 X 3 64 433 429 X 2 66 S43 X5 41X3 47 3 32 X 5 46 X 3 33 5 27 X9 25 3 29 46006 5100E 3100D 5700H 65001 74001 30006 63001 61000 5500 VS2 GIA GIA 63 00 64 00 66 00 56 00 57 00 56 00 56 00 10782813 10989867 1109071540 1109071548 1109071847 1109071947 1109072085 1109072090 1109072119 2 3 8 8 8 8 8 6 6 2 kX S amp S amp G amp G lt Ga Creation Date 09 16 11 Confidential Diamond and Stone Inventory Page 200f 20
14. amonds stones are sent for testing certification at Lab To prepare Lab Memo click on Module gt Diamond amp Stone Inventory gt Transactions gt Memo to Lab User has to enter values at the following important fields Header Tab 1 Trans Type Certification Polishing Recut Salesperson Other 2 Lab 3 ShipTo 4 Ship Date Diamond and Stone Inventory Page 130f 20 Creation Date 09 16 11 Confidential DIASPAR Diamond and Stone Diaspark Inc Inventory Enter Select Ship To id of Lab id lab OO ESE I A ae r a a 1 rat ATRI at aa A mmole F WEFT Z OT YEW Par ALI do bia Fa HUTE LLL a OEF IYI CN AF HE Af PHEW Jr OF ACILI O AOp CJ BULL UUU E E dE Leen Ee teste teuren set ba SES ge J Query List Lab H at Memo H Date i DOUT 09 25 2071 emological Institute of America AC Period 201 109 IN ew york Me Ship To Po Kon Rapaport Date Discount foo 000000 DU Header Detail Multiple Detail Single Footer Status Active lo Den Unposted Contact MG LINDA Name Gemological Institute of America Copy From Order Address fee0wW4ethSteet oS PO Datel DoS E Order H iDate 1 92820 ity State Zip Newrok My fos o Terms Due Dt NOD 03 25 2011 County USA Packi i tsti sSCS Salesperson NMA 0 Type E Group NMA redit Limt Current UU Location E Commission 00 PackinoLit TT Total Amt 300 00 Print Format M2 Price Uevel Discount a Gold Dt Price 09 25
15. aspark Inc Inventory 3 8 Update Rapaport Price This feature helps you to update Rapaport price Price for the selected packets can be updated at a time Here we can see the old Rapaport price amp the new price then we can select which Packet needs to be updated Through this screen we can also update the Web Prices amp Web Discounts either by Uploading through Excel or by entering manually on the screen To update Rapaport price click on Module gt Diamond and Stone Inventory gt Setup gt Update Rapaport Price Select rapaport date from Enter web Click on update web the drop down of which discount if to be Price button to update price is to be applied updated web price 5 Update Rapaport Price kalbo Filter Clarity m o Color shapa ECH wt op 00 Resetdiiter Select From Excel Select All Rapaport Date 07 05 2010 I Update Price 1 we Disc Web Disc 2 Web Disc 3 Yuet web i Web Price Select Packet SS a Price2 Web New Web jaa aad fis SE SE Price oe Discount SSC Discount2 Discount3 Discount 3 10316959 1 G H PR 0 46 D g 0 0 0 10989867 1 000 H i RD D D 0 3200 a 0 3200 a 0 jw 11109071540 1 00 sit RD i 0 57 D 0 2300 00 U 2300 00 0 jw 11109071548 1 00 sit RD i ds D 0 2000 00 0 2000 00 0 lw 1109071847 1 00 sit RD i 0 74 D 0 3100 00 i 3100 00 U 1109071947 1 Hp sit RD i 0 30 1 700 oq 0 1600 o 0 1600 oq 0 1109072085 1 D 512 RD i 0
16. e 09 16 11 Confidential DIASPARX 3 2 Diamond and Stone Diaspark Inc Inventory Stone Lot Master The stones that have similar shape and quality are put together in a particular group called lot Each lot is provided with a unique id or code Lot Master setup helps users to define different lots of diamond stone received by the diamond department At the lot master user can also set price up to ten price levels Here we can view all the transaction relating to the Lot at one place amp can navigate to the desired transaction through drilldown If Lot is certified then on saving the Lot a Packet will be generated automatically You can view the Packet by clicking on the Open Packet Button To navigate to Lot Master click on Module gt Diamond amp Stone Inventory gt Setup gt Stone Lot Master Enter a Prefix and click on Generate Lot button This will auto generate a Lot id a sequential lot id with the prefix will be allotted Enter a unique Lot id Lot Master 1 of 1 New by ADMIN on Sep 21 2011 00 00 00 o Em Quer List Add Edit Lot Sublot 8 NA See Open Packet Lot Master Summary All Transact Sales Purchase Inventory Price Certificate Must Ir Prefix Generate Lot Lotgroup Id M Description FE Discontinue No 00 Origin Di Diamond Mergdol o From To Stone DIAM wtf 0000 f DO Saef CT Quality NAT Color NA Clarity NA Gu DO Price Variation 4 Purchase D
17. e orders can be generated for loose diamonds also Diamond and Stone Inventory Page 16of 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory 4 7 Import Rapaport Data This feature helps user to import diamond price from rapaport User can import the file CSV from rapaport To import the rapaport data go to Module gt Style Setup gt Transactions gt Diamond Pricing gt Show Rapaport Data E RAPAPORT Stone price import Price Date Shape Clarity Color From Wl To Wt Price Import Data Show Data Close 4 8 Show Rapaport Data The rapaport data that has been imported is shown here To view the rapaport data go to Module gt Style Setup gt Transactions gt Diamond Pricing gt Show Rapaport Data Filter Options Data can be filtered through these options WW View Rapaport Price Data Shape D Wt Range OB Price Date 1 1 1900 D Rapaport Data Rapaport Discount amp Markup Rapaport Price Price Date 0472372010 EMERALD Cu From Wt 0 00 To We 0 22 0 0001 0 2200 Color IF WS1 WS2 vi vi am a am np 13 G mg 115 105 105 9 ES Fromwt 0 18 Towt 0 22 01800 0 2200 IF wat w i wei V52 GESb 135 135 135 11 5 11 5 10 55 35 13 5 135 135 11 5 11 5 10 BN 35 135 135 135 11 5 115 10 5 5 35 3 H 43 26 A3 26 Print Close The imported rapaport data is shown 5 1 Stone Lot Stock This screen helps us
18. e when sell items or send items back to the vendor in purchase return or if send stock to another business unit of your own company gt Adjustment entries that involve both Issues as well as Receipts can be made with the help of the Transfer 3 Setups The Diamond amp Stone Inventory Setup allows user to set up stone parameters lot master stone set category etc These setups are used to record transactions in the Diamond amp Stone Inventory module like receipts transfers issue physical inventory packet assignment diamond set create etc 3 1 Stone Parameter Parameters can be set for the stones that are to be kept in stock This has 12 parameters in different tabs namely Stone Shape Quality Setting Color Clarity Make Shade Cut Size Group Wt Group and Size Band To open stone parameter window click on Module gt Diamond amp Stone Inventory gt Setup gt Stone Parameter Diamond and Stone Parameter Stone Parameter 1 of 6 Edit by ADMIN on May 18 2010 10 03 09 Je ES Query List Add Edit Shape Quality Setting Color Clarity Make Shade Cut Size Group Wl Group Size Band Description Sell Debit 4 0 Purchase Credit A C H Purchase Debit A C H AM AMETHYST Active DIAM diamond Active EMRD EMRALD Active GOLD G old Active PER PERIDOT Active Se Enter a unique stone id and description Diamond and Stone Inventory Page 5o0f 20 Creation Dat
19. eceipt 44 of 44 Add Edit Receipt Type Customer New by ADMIN on Bep 23 2011 00 00 00 e Je zel Receipt Date RED 00015 09 23 2011 AC Period Pn Retailer oS Location NA Ee Wee Remark Refeance j jogveqv2011 Status fictive Open Unposted Receipt Lott Rec Rec SC Prie Rec Size dese Location Remark Quality Shape Size Stone tee Pcs Price Amt a Ee Carat 5 00 1 20 44 A0 Bra 410 100240 01AM z 1 20 57274 El Select item type as Enter Lot id received diamond or stone pieces and receive wt at from the drop down the respective columns Receipt Type gt Opening Balance When the application is used for the first time entry for existing inventory can be made through this option gt From Vendor It suggests that the goods have been received from a vendor So it is actually a purchase gt From Customer It suggests that the goods have been returned from a customer So it is actually a sales return gt Production This receipt type is used when diamonds are to be received from the production 4 2 Issue Issue is used to record all the sales that user makes to various customers and all the purchase returns to vendors Issue is also used for internal issue of diamond stone to workbags There are several details that can be stored in the window for issue of diamonds stones An issue transaction can be generated for the diamonds stones returned to the vendor as
20. ed together in one category User can also edit this information at the time of recording the information Various Transactions involved in Inventory Module helps in creating purchase receipts Sales return Issues for Sales made or Purchase return and making Transfer entries for transfer of goods from one business unit to another or from one department to another Transfer is one of the vital functional transactions of Diaspark Jewel Diaspark Jewel helps user in keeping inventory cost at the minimum and helps in optimizing inventory levels Inventory reports can be used to find out details of receipts issues transfer entries and adjustments made User can also use these reports to check how many items have stock less than reorder level and accordingly place the order for the same Highlights gt Provision for allocating multiple vendors for an item gt Inventory Transactions consists of various procedures that you undertake for tracking your sales and purchases gt Apart from recording details of sales and purchases the inventory procedures include transfers and adjustments for receipts and issue of items Diamond and Stone Inventory Page 40f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory gt A Receipt will be created when items are purchased or received from the customer as sales return or if receive stock from another business unit of the same company gt You create an Issu
21. er to view stock of the lots Through this screen user can not only view stock but can also track diamond stages You can also create sales quotation and sales memo through the same screen just by selecting the lot and clicking the button With the drilldown facility you can have a detailed view of the lot stage Diamond and Stone Inventory Page 170f 20 Creation Date 09 16 11 Confidential DIASPARX Diamond and Stone Diaspark Inc Inventory This screen consists of the following tabs gt Summary This tab shows the stock summary consisting of lots weight quantity onhand memo in memo out stock average cost and total amount Filter options eee Ston Ae Tear AA ro Stone Lot Stock Tracking sec Query Summary p Refresh Stock se Customer si fo Create Document IESEL Create Sort Lot Onhand Average Stock Remaining Amount Amount Shape Quality Color Clarity Type Size e Size Ce D Cost Value Avg Cost penar value From E a SC100754 248 40 225 20 55 939 68 CSH PAVE Ws2 D 1 00 64 8 5 9 20 20 00 RD na ina na D M 8 5 9 11CC3 373 240254 3 73 556 20 8 961 47 2 074 63 RD BEZEL F ap D 10 go 11 11 5CC5 34000 RD CHANNEF M D a oo 4115 C3 132 Si 221 44 51 00 1 00 82 95 221 44 18 368 45 18 368 45 RD BEZEL E ep D J10 010024 11 5CC4 4 05 363 09 3 00 1 05 64 46 381 24 67 68 RD PRONG F H D J10 010024 11 5 CC5 1 82 334 74 1 82 124 43
22. nter Select lot id under which packet is to be created Packet Master 81 of 3163 Ed by on Jul 21 2006 Add Edit Packet 11649370 Packet Master All Transaction S iles Purchase Inventory Summary Prices EARCH PackeLDetai Pabket Specifics Shape IER Depth 76 3 Cul ss Weight A Tale 82 MaxGirdle Thick Sub Lot MISC Color H Polish Good Min Girdle Medium Vendor PO Clarity Wi O Symmetry Good Girdle pO Location PO Fluorescence Faint Proportion Ir Culet Non Status Active Fluor Color DEER Cert File f11649370 ipg Open File Origin Of Diamond Comments Discontinue x Additional Specs po Certification Costs amp Prices Dimensions Gemex Certified Jr Yes C No Rapaport Price 2 400 00 Unit Carat White Light 4 Received Yes No Discount 40 000 Langh FOE Color Light Cert Type p00 Cost 474 24 Certificate 11649370 Web Upload Yes oe 382 Scintillation Certificate2 os Web Discount D web Price 610 08 Depth 2 99 Report File 11649370 ipg Laboratory GA eb Upload 2 E Size KH Open File Laboratory 2 pO Web Discount2 f 0 Web Price 2 0 Client Web Upload3 OOO Barcode 15482 Web Discount3 DU Web Price 3 D 3 4 Diamond and Stone Inventory Enter diamond stone certification details Stone Packet Parameter Update You can update parameter details of stone packet through this option The updated details will be applied to all
23. t Category window click on Module gt Diamond amp Stone Inventory gt Setup gt Stone Set Category Enter a stone set category name Enter a category id Category id should be E Stone Set Category 2 of 2 Edit by ADMIN on Dec 06 201019 41 18 cn D k sd Query List Add Edit Set Category TEST Status EE Name jtest Vendor 4001 Vendor 4009 Vendors Purchase Debit 4 0 1090 Sell Debit 4 0 1090 Purchase Credit A C 1090 Sell Credit A C 1352 Enter Sell Purchase debit and credit account details 3 7 Stone Set At the stone set screen you can add information about the stone sets i e stone set id category price its lot no vendor certification etc To enter stone set information go to Module gt Diamond and Stone Inventory gt Setup gt Stone Set Enter Select Enter a unique stone set category stone set id Stone Set Item Master 33 of 39 Edit by ADMIN on Dec 06 2010 19 42 01 Query List Add Edit mEn k zd Set Category Es Staus Riis Totalwwt D Pice Set Di Certified C Yes No Remark det Group 4 Vendor pr Wm wen SMHo Lot Sub Lot H Shape Size Group Pres Carat Matts Cert Unit Cut Color foi 5C100754 1 00 DI of II Cas o o Enter stone set Enter lot name information here Diamond and Stone Inventory Page oof 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Di
24. the purchase return and for opening balances Issue date and accounting period are automatically generated To open issue screen click on Module gt Diamond amp Stone Inventory gt Transactions gt Issue Diamond and Stone Inventory Page 110f 20 Creation Date 09 16 11 Confidential DIASPARX i Diamond and Stone Diaspark Inc Inventory Select Issue type from the drop down Enter Reference id CR Stone Issue 128 of 129 View by ADMIN on Sep OS 2011 00 00 00 Query List ddEdit Issue Type 3 Vendor lskue H Date PEO 1 D001 2 0970872011 Referance Id Dis AJC Period 201109 AMERICAN GEM SOCIETY MS HMA Location 00000 New ork NY Remark Referance H ADF Da8 Status Active A Unposted Unit lssue Issue Issue Issue Size Packet Location Hemark Diam Set Qualty Shape Size Stone Pes WHE Price Amt it H H H LB 2500 Carat 0 5 00 DUU 2500 00 NA 2500 00 Select Item type as Enter Lot id issue pieces diamond or stone issue wt and price at the from the drop down respective columns Issue Type gt To Vendor It suggests that the goods have been returned to vendor i e purchase returns gt To Customer It suggests that the goods are sold to customer i e sales gt Opening Balance When the application is used for the first time the entry for existing inventory can be made through this option gt Production When diamonds are to be issued for the production
Download Pdf Manuals
Related Search