CK StockTake manual
Contents
1. Bin numbers Tick the box to update the bin location on the stock file If the stock item is in the incorrect bin per the computer this can be amended also Once all the criteria have been set choose OK to load the CK Stock Take browse screen You will receive a warning saying that a backup should be taken before updating 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 4 of 8 3 2 STOCK TAKE ADJUSTMENT BROWSE ENTRY SCREEN The CK Stock Take browse entry screen is where the physical count adjustments are entered The utility takes a snapshot of the current in stock quantities based on the criteria selection Stocktake Adjustment Description O Stock Code Match Any Word O Bin Loc WJH Stock Code Bin Loc Computer Counted Description MAIN FILTEROO emo 20 25 00 Engine Oil Fitter GL3AC MAIN cMATO44 o 355 00 Car Mat Small MAIN CMAT109 xw 317 00 Car Mat Medium MAIN CMAT122 m 259 00 Car Mat Large MAIN DTRON16 so 93 00 Dialotron 16 Mobile Telephone MAIN DTRON32 65 00 65 00 Dialotron 32 Mobile Telephone MAIN JECAFO01 mo 173 00 Poppy Coral Air Freshener MAIN ECcDOO1 no 11 00 Digital Compass MAIN ECHCO01 o 38 00 Heat and Massage Cushion MAIN JECMHOO1 i00 i000 Mobile Phone Holder Silver MAIN JECRDOOI o 94 00 Uniden LDR6157 Radar Detector MAIN E2. the adjustments A Save Changes and Update Stock The Opera Printer Publisher is opened where you can choose an output option for the adjustment report to be produced You have the standard Opera options available Screen Printer File pdf etc Email 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 7 of 8 The report produced is an audit trail showing the Stock item and location its original computer quantity the actual count quantity entered and the difference which is to be posted Remember it is the difference that is posted as an adjustment not the counted quantity Orion Vehicles Leasing Stocktake Adjust Report Printed 28 01 2011 at 14 58 by USER Orion Vehicles Leasing Stocktake Adjust Report Product Description Bin Loc Computer Counted Difference Warehouse MAIN Main Warehouse FILTEROO1 Engine Oil Filter GL3AC BIN1 25 00 30 00 5 00 Once the printing has been completed the transactions are posted Heat and Massage Cushic Before the stock is used it is recommended to print a Stock Valuation report and or a Theoretical Stock report and check these to the count sheets to ensure all adjustments have been made correctly You can re run the CK Stock Take utility as often as required to complete all adjustments 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca
3. CK Stock Take A Utility for the Pegasus Opera Il 3 Accounting System User Manual Updated 28 01 11 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk 1 0 2 0 3 0 CK STOCK TAKE MANUAL CONTENTS Introduction and Overview CK STOCK TAKE Installation Activation CK STOCK TAKE Utility 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 1 of 8 1 0 Introduction amp Product Overview CK STOCK TAKE is a utility for the Opera II 3 accounting systems which allows the users to freeze the current Opera in stock quantity figures and displays them on a browse screen The end user can then enter their counted Stock take quantities onto this browse screen and then the utility will post the required Stock Take adjustments to amend the current computer in stock quantities to the counted quantity The browse screen is displayed by warehouse and can be ordered by Stock Reference or Bin location and a full audit trail report of the adjustment postings is produced The purpose of this manual is to ensure that you setup and use CK STOCK TAKE correctly Should you experience any problems when running CK STOCK TAKE or you have any queries or comments regarding this product please contact CK Systems by telephone on 01384 245243 Alternatively you may contact us by fax on 01384 245250 or b
4. NTPACKOI mmo 144 00 Entertainment Package With Phone MAIN FAKO1 84 00 34 00 First Aid Kit MAIN FAKOZ 0 96 00 First Aid Kit No Label MAIN FPPEa3 a aw 21 00 Foot Pump MAIN FUS269 5 5 970 5 amp Fuses Box of 1000 MAIN HSSWOO1 4o 4 00 High Security Steering Wheel MAIN H5wB001 so 18 00 High Security Steering Wheel Bar MAIN ick102 O mo o car Jack MAIN LABEL 43 000 43 000 Company Logo Labels Box of 1000 The Counted column defaults to the same in stock quantity as the Computer column This is to Save time on data entry The adjustment that will be posted is the difference between the Computer and Counted column and a positive or negative adjustment will be made as necessary NB The amount entered in the counted column should be the actual count quantity that should be in stock and not the adjustment to the current computer in stock quantity 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 5 of 8 At the foot of the browse screen is a Microsoft Excel icon Clicking on this will create a spreadsheet based on the information in the browse screen This can be used for information purposes or used as the physical count sheet There is no import routine to update the adjustment screen from a spreadsheet Find If you want to move to a particular item quickly enter your search parame
5. Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk
6. co uk CK Stock Take Page 8 of 8 3 3 After the Stock TAKE has completed Once complete a stock transaction will then be posted into the main live company as below the main in stock quantity fields on the stock and warehouse headers are updated also along with the Free Stock quantities being recalculated too Ra Stock Processing FILTEROO1 Engine Oil Filter GLJAC General Memo Extended Description List Description Engine Oil Filter GL3AC Search Ref 1 Barcode Search Ref 2 Snalysis Sales Code CONSOL Lease Consumables Override Supply Code M210 Purchases Servicing Override Category CONS Consumables Type FIFO Profile ITM1 Single Items Packed 0 Per Sell Price 7 00 Std Cost Nokk Last Cost Se In Stock al 30 00 Projected 35 00 Allocated 5 00 Qty PO 10 00 _LastIss _ 15 08 2008 FILTEROO1 Engine Oil Filter GL34C Description In Stock Allocated Stock Transactions FILTEROO1 Engine Oil Filter GL3AC Main Warehouse Tran Type Trans Date Reference Tran Qty Cost Value Sell value A Alloc 20 11 2009 ORD00250 Receipt 04 12 2009 POROO116 Adjust 28 01 2011 AUTOADI Ix The stock take adjustment transaction has a reference of AUTOADJ placed in the reference field for audit trail purposes 4 Castle Court 2 Castlegate
7. er fields and they are greyed out and cannot be altered 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 6 of 8 Continue entering the count figures as required MAIN MAIN MAIN MAIN MAIN MAIN MAIN FAKOZ 96 00 96 00 First Aid Kit No Label FPP883 am 21 00 Foot Pump FUS269 5 5 970 S amp Fuses Box of 1000 HSSWO01 4 4 00 High Security Steering wheel HSWB001 o 18 00 High Security Steering Wheel Bar ICK102 o 14 00 Car Jack LABEL 43 000 43 000 Company Logo Labels Box of 1000 v Cancel If you want to cancel any items entered so far and stop the current stock take choose this You will be prompted to confirm cancellation and if confirmed the stock take is cancelled and no adjustments are posted Save If you are part way through the stock take and you wish to save the entries made so far but not yet post the adjustments then choose save and you are prompted to confirm then the stock take is saved and will be reopened when you go back into the criteria screen Any quantities amended are saved but no adjustments are posted at this point If you wish to print the progress so far then this can be done using the printer icon on the Opera toolbar Print amp Update When all the quantities counted have been entered selec print amp update You are asked to confirm that you wish to post
8. ter in the entry box and click the find button This will take you to the item on the adjustment screen Description Stock Code Bin Loc Used in conjunction with the find to define where the system should search for the criteria entered Match any Word Allows any part of the text entered in the find criteria to be searched upon If left un ticked the search will only find exact matches Stocktake Adjustment Description O Stock Code C Match Any Word O Bin Loc WIH Stock Code Bin Loc Computer Counted Description MAIN FILTEROO1 Bm 25 00 Engine Oil Filter GL3AC MAIN CMATO44 o 355 00 Car Mat Small MAIN CMAT109 aw 317 00 Car Mat Medium MAIN cmati22 m 259 00 Car Mat Large MAIN DTRON16 93 00 93 00 Dialotron 16 Mobile Telephone MAIN DTRONS2 o0 Dialotron 32 Mobile Telephone E MAIN JECAF001 mo 173 00 Poppy Coral Air Freshener MAIN EccD001 11 00 11 00 Digital Compass MAIN ECHCoOt 38 00 38 00 Heat and Massage Cushion MAIN ECMHOO1 oo 1000 Mobile Phone Holder Silver MAIN JECRDOO1 94 00 94 00 Uniden LDR6157 Radar Detector MAIN ENTPACKOL 144 00 144 00 Entertainment Package With Phone To enter a new counted value or a new bin location click into either the Counted or Bin Loc fields next to the product you want to amend and type your changes here These are the only fields that can be edited click into oth
9. ure no one is processing in any part of the system that involves updating the stock files ie SOP POP BOM Costing and stock As the utility freezes the stock any movements made after this would not be reflected in the browse screen in stock figures so would lead to incorrect stock adjustments being posted The utility is also designed for single user input only 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 3 of 8 3 1 USING CK STOCK TAKE Select CK Stock Take from the Stock module menu This loads the criteria screen P CK Stock Take Options Sequence Warehouse Range From MAIN Qa Main Warehouse To STOR Storage Warehouse Bin Location C Include Zero Stock Items Order By Stock Reference C Writeback modified Bin numbers Sequence Defaults to Warehouse this cannot be amended Range Allows you to filter the Stock products by Warehouse Choose either the warehouse you wish to see on the browse screen or a range of warehouses Order By Choose an option to filter the products on the browse screen The Choices are by Bin Location or by Stock Reference Include Zero Stock Items Tick the box to include ALL stock items regardless of in stock quantities By default only stock items that have a quantity in stock will be presented for adjustment Writeback modified
10. y e mail to support ckca co uk IMPORTANT NOTE FOR CK STOCK TAKE TO RUN CORRECTLY THE OPERA II 3 TOOLKIT MODULE MUST BE ACTIVATED ON THE SYSTEM DISCLAIMER Although programs are tested by CK Systems before release no claim is made concerning the accuracy of software CK Systems cannot assume liability or responsibility for any loss or damage arising from use of these programs It is a condition of every sale or purchase of CK STOCK TAKE that the purchaser accepts all such risk and such acceptance shall have deemed to be given when the purchase is made 4 Castle Court 2 Castlegate Way Dudley West Midands DY1 4RH Telephone 01384 245243 E Mail cks ckca co uk CK Stock Take Page 2 of 8 2 0 Installation amp Activation of CK STOCK TAKE For detailed instructions on the installation and activation of CK STOCK TAKE please refer to the separate CK Activation and Installation guide Once installed and activated you can then proceed to the next step below wake IMPORTANT ALWAYS TAKE AT LEAST ONE DATA BACKUP EACH TIME BEFORE RUNNING THIS UTILITY 3 0 CK STOCK TAKE Utility Ms Supply Chain Management Processing fen G R N amp R T Q view w Enquiry w Reports 0 Utilities a Maintenance CKStockkake The CK Stock Take utility is accessed from the main Supply Chain Management Stock menu The utility should only be run with Exclusive access to the Stock files therefore ens
Download Pdf Manuals
Related Search