News

Stocktake Procedure

Below is a brief point-form summary of what needs to be done in to run a full stocktake for an entire store.

  1. Run stock on hand report before you commence stocktake, log onto Readysell, select report wizard, type = management, description = stock on hand report; highlight it and click on run highlighted report, close query.
  2. Start Stocktakes, Log onto Readysell, Select Product Transactions,Close Stock Adjustments, Click on ‘Stocktakes’ icon top task bar.
  3. Run “Flag Products as not counted” on Tab 4 Modify, Exit = NO, Exit = NO, Exit = NO, close query.
  4. Add each stocktakes as follows:
    • Click on Insert
    • Ensure that the check overwrite flag check box is not TICKED
    • Enter or scan in product and input quantity
    • Click OK when all products entered
    • Highlight stock and click on tab 3 print, print stocktake variances for one stocktake before stocktake applied
    • Check variance report if you need to change any quantities then do so on each stocktakes
    • Repeat step 4 until all stocktakes entered
  5. Backup entire database before u apply any stocktakes (MUST ring Readysell)
  6. Apply stocktakes
    • Click on Tab 3 print”Print Stocktake variance for stocktakes by date range applied after stocktakes applied or print stocktake variances for all stocktakes by date posted after applied” ensure to archive and print either one
  7. Create empty Stocktake
    • Click on Insert
    • Ensure that the check overwrite flag check box is NOT TICKED
    • Click on tab 4 modify and select “Add all non counted products to this stocktake as zero on hand”, close query
    • Check it and then apply it
  8. Run another stock on hand report after applying and check products/qtyonhand (step 1).
  9. Adjustment stock takes after applying all stocktakes- click on insert a stocktake and enter products and quantities.
  10. Turn overwrite flag ON.
  11. Print Variance report before applying.
  12. Apply Stocktake.
  13. Print Variance after applying/archive.
  14. 14. Run another stock on hand and check products/qtyonhand.

Using Data Capture Unit – Cipher Lab

  1. From your desktop double click on Icon ‘8000 Cradel Shortcut’.
  2. Put scanner into cradle and select option 2 upload.
  3. Press any key to continue on command prompt.
  4. Click on Yes to download question.
  5. Print report.
  6. Press any key to continue on command prompt on ‘import pde transaction’.
  7. High – CIPHER LAB – CIPHER STOCKTAKE -DOULBE CLICK TO OPEN.
  8. Leave the Prefix and Suffix Box un-flagged and make sure they are CLEAR.
  9. Leave all other boxes as default settings all unchecked.
  10. Click on OK to continue.
  11. Click on OK again to accept stocktake number.
  12. Print report that appears.

Using Data Logic Unit

  1. Double click Readysell Mobile.
  2. Click on Stocktakes.
  3. Click on New Stocktake.
  4. Commence scanning products into the unit.
  5. Once finished scanning a location.
  6. Click on OK to accept.
  7. Stocktake created = click OK.

Manual stocktake within Readysell not using any mobile units

  1. Log onto Readysell.
  2. Select Product Transactions.
  3. Close out of Stock Adjustments.
  4. Click on ‘Stocktakes’ icon top task bar.
  5. Print stocktake work sheet.
  6. Physically start count stock and entering on worksheet.
  7. If it is for an entire store, remember the correct steps.
  8. Firstly “Flag Products as not counted”.
  9. Click on “Insert”   to insert Stocktake.
  10. Make sure you are in Add Mode (take overwrite tick OFF).
  11. Once all entries have been entered into Readysell.
  12. Print all variance reports before applying stocktake option.
  13. Check all negatives and discrepancies which may be on the stock take report.
  14. Do a backup (ring Readysell for backup).
  15. Apply your stock takes.
  16. Insert another stocktake for only for <Add all non counted products as to this stock take as zero on hand> only for entire store stock take, and print the variance report for this stock take.
  17. Check your flags one more time.
  18. Apply that Stocktake.
  19. If applying by Location, steps are different.
  20. Override or add mode depending on if product exists once.
  21. Do not run “add all non counted products to this stock take as zero on hand” for a single stock location as it will set the stock not counted at every other location as zero.
  22. Print Variance Report and make changes if need be.
  23. Check flags once again.
  24. Do a backup.
  25. Apply your stock take.

If Stocktake is by Location (or an adjustment stocktake)

  1. If running by location steps are different.
  2. Flag all products as not counted.
  3. Override or add mode depending on if product exists once.
  4. DO NOT RUN ‘ADD ALL NON COUNTED PRODUCTS TO THIS STOCKTAKE AS ZERO ON HAND” for a single stock location as it will set the stock not counted at every other location as Zero.

End of Year Procedure

Below is a brief point-form summary of what needs to be done in respect to the End of Financial Year.

IMPORTANT: Please make sure that a End Of Financial Year Backup is done and Removed from your Current Backup set and KEPT

SITES THAT ARE NOT RUNNING READYSELL GENERAL LEDGER

Please follow steps below:

  1. Set up a folder on the main drive on the server and call it something like ‘EOYJune2011’ and archive all relevant reports into there.
  2. If you are doing a stock take please ensure that you have printed and archived a stock on hand report BOTH BEFORE AND AFTER THE STOCKTAKES.
  3. Ensure that you have printed and archived The Stocktake Variance reports
  4. Ensure all data for the last day in June is completed and dated and entered correctly into Readysell.
  5. At end of Trade on the 30/6/2011 Run a Stock On Hand Report, Print it as well as ARCHIVE it into a safe folder on your hard drive.
  6. Print out whatever other relevant reports that you may require in respect to sales, stock on hand, etc.
  7. You may not run your debtors or creditors end of month as yet as you are probably waiting to download your bank statement early the next morning as you will have direct deposits and electronic transfers and miscellaneous transactions dated up to 30/6/2011.
  8. If this is the case, then the next step would be at end of trade on the 30/6/2011 please ensure that a number of BACKUPS are done.
  9. Firstly the normal backup then another backup and keep it off site as well as label it.
  10. If you require the data to be backed up into a separate database as well please contact Readysell.
  11. Early the next morning on the 1/7/2011 no transactions in sales or purchasing should be backdated into June 2011.
  12. Unless of course if your company policy for Suppliers is different and you allow the first week of the next month for supplier invoicing.
  13. Bear in mind if you are receipting supplier invoices re stock on hand, the stock on hand figures on the stock on hand report that was run 30/6/2011 will not change due to the back dating.
  14. Down load your bank statement and enter all deposits and payments and misc entries that have not yet been entered into Readysell for June and date them the DATE (JUNE) as per your statement.
  15. These can be backdated as you have not yet run your Debtors Trial Balance or Statements.
  16. Allocate the payments then run through your normal End of Debtors process.
  17. Remember to archive debtors trial balance and debtors statements and transaction listing.
  18. Make sure you do you last Bank Reconciliation dating it month ending 30/6/2011.
  19. Please ensure with Bank Reconciliations that you do not present any forward dated transactions into the end of financial year bank reconciliation.
  20. Print out your both Bank Reconciliation Reports and attached them to the bank statement.
  21. Any customer payments that are received on the 1st July 2011 can be entered but please DO NOT ALLOCATE THEM until the trial balance and statements have been run for JUNE 2011.
  22. As for suppliers if you do not cut off exactly on the 30th June 2011, then please ensure you DO NOT RUN A CHEQUE RUN for July until you have finalised June and run and archived your Supplier Trial Balance. If you do need to pay suppliers in July, then don’t do a cheque run whereby allocation is automatic, enter the payments as manual SUPPAY and date them July BUT DO NOT ALLOCATE THEM IF YOU HAVE NOT CLOSED OFF SUPPLIERS FOR JUNE.

SITE THAT ARE RUNNING CASHBOOK AND GENERAL LEDGER

Please follow steps below:

  1. If you are doing a stock take please ensure that you have printed and archived a stock on hand report BEFORE AND AFTER THE STOCKTAKES.
  2. Also ensure that you have printed and archived the Stocktake Variance reports.
  3. Ensure that all data is entered and dated correctly for the last day in June is completed in Readysell.
  4. Ensure that all transactions that physical reduce or increase stock like stock adjustments, stocktakes, sales, purchasing, credit requests, stock transfers are entered prior to Running Your End of Year Stock on Hand Report.
  5. At end of Trade on the 30/6/2011 Run a Stock On Hand Report, Print it as well as ARCHIVE it into a safe folder on your hard drive.
  6. Print out whatever other relevant reports that you may require in respect to sales reports, stock on hand, etc.
  7. You may not run your debtors or creditors end of month as yet as you need to download your bank statement early the next morning as you will have direct deposits and electronic transfers and miscellaneous transactions dated up to 30/6/2011.
  8. If this is the case, then the next step would be, at end of trade on the 30/6/2011 ensure that a number of BACKUPS are done.
  9. Firstly the normal backup then another backup and keep it off site as well as label it.
  10. If you require the data to be backed up into a separate database as well please contact Readysell.
  11. The next morning on the 1/7/2011 no transactions in sales or purchasing should be backdated into June 2011.
  12. Unless of course if your company policy for Suppliers is different and you allow the first week of the next month for invoicing.
  13. Bear in mind if you are receipting supplier invoices and stock on hand, the stock on hand figures from the stock on hand report that was run 30/6/2011 will not change due to the back dating.
  14. Down load your bank statement and enter all deposits and payments and misc entries that have not yet been entered into Readysell for June and date them the DATE (JUNE) as they are on your statement.
  15. These can be backdated as you have not yet run your Debtors Trial Balance or Statements.
  16. Allocate the payments then run through your normal End of Debtors process.
  17. Remember to archive debtors trial balance and debtors statements.
  18. Make sure that the last Bankrec for Each Bank Account is dated and extracted to 30/6/2011.
  19. Please ensure with Bank Reconciliations that you DO NOT PRESENT/TAG any forward dated transactions into the end of financial year bank reconciliation.
  20. Print out your both Bank Reconciliation Reports and attached them to the final bank statement for that financial year.
  21. Any customer payments that are received on the 1st July 2011 can be entered but please DO NOT ALLOCATE THEM until the trial balance and statements have been run for JUNE 2011.
  22. As for suppliers if you do not cut off exactly on the 30th June 2011, then please ensure you DO NOT RUN A CHEQUE RUN for July until you have finalised June and run and archived your Supplier Trial Balance. You can enter manual Supplier Payments and date them July BUT DO NOT ALLOCATE THEM IF YOU HAVE NOT CLOSED OFF SUPPLIERS FOR JUNE.
  23. The General Ledger is an overnight process which runs as part of the End of Day Backup. So that means that all data entered into Readysell on the 30/6/2011 will update the General Ledger and Generate Journals sometime after trade and ready for reviewing the next morning.
  24. Check the General Ledger the next morning and Print off a Profit & Loss, Balance Sheet and General Ledger Trial Balance.
  25. Ensure you archive these as well.
  26. The general ledger does not have to be closed off at the end of June. It can be left open for Manual Journal Entries or Miscellaneous Debits and Credits into Customers or Suppliers that have no physical affect on Stock on Hand only Miscellaneous Expenses.
  27. Ensure that you have run your General Ledger Postings Report and compared it to your source modules of Sales, Customers, Suppliers and Cash Book (General Ledger Balancing Act).
  28. Ensure that at the beginning of the next month you have closed your financial Period to prevent Back Dating.
  29. Once you are ready to close off the financial year, you will need to rerun your 3 general ledger financial reports, send them off to your account to be reconciled.
  30. Usually your account will provide you with a reconciling journal for that financial Period.
  31. That journal needs to then be entered into Readysell in the right Period.
  32. Then you need to contact Readysell so that you can run and clear that financial year (P&L Appropriation Process).

Quick Tip: How to Turn on GP% on the Sales Screen

  1. On Tab “3 Change” click “F3 Controls”
    image
  2. Tick “Add Quote Features to Sales Order Entry” and click “OK”
    image
  3. Click On Tab “1 General”. Displayed is;
    •    Line Margin and % will appear on the sale – This shows the GP % for an individual line
    •    Over all Total Margin and % – This shows the GP % for the Overall sale
    image

Please Note: This procedure will have to be run on all registers

Readysell Cloud Backup

Thanks to advancements in online storage, Readysell is now able to offer a cloud-based backup solution running on Amazon’s popular S3 service. The new Readysell Backup service allows you to seamlessly, securely and automatically protect your company’s files against loss, theft, viruses, and natural disasters. It also allows you to access your data from any web browser, anytime, anywhere, securely with just a click.

For customers already taking advantage of this service, we have now configured automatic email for alerts for your backup using your primary email address. You will start to receive your daily reports shortly.

In addition, you should have already logged on to our website to download and installed the Readysell Backup Management console. This should be installed on your workstation so that at any time you can log in and make changes, add additional backup folders or just check your current backup status. If you do not have your username and/or password, please send an email to support@readysell.com.au to retrieve it.

Microsoft Security Essentials 2.0

Late last month Microsoft released the second version of their award-winning and free anti-malware tool, Microsoft Security Essentials.

Microsoft Security Essentials (MSE) can be used for no charge on any Windows XP or Windows 7 computer in businesses with up to 10 PCs. If you fall into this category, we highly recommend MSE as an anti-malware solution.

Benefits of the new version include:

  • Integration with Internet Explorer for better protection against web-based threats
  • Network inspection to monitor local network traffic for threats
  • Heuristic engine to detect even more threats
  • Windows Firewall integration

If you are already running MSE version 1 on your PC, you will be automatically upgraded to version 2 via Windows Update. If you have a new PC you wish to install MSE on, uninstall any existing antivirus software and then go to this website to download and install MSE.

RObI Web Order Changes

RObI (Readysell/Office Brands Interface) version 1.2.4.0 was deployed to all stores late last week. This version contains a change that will potentially affect the way web orders are imported at your store.

RObI now checks the “Customer Order Required” flag on your Readysell customer file (see screenshot below).

If a customer is flagged as “Customer Order Required” and does not supply a Purchase Order number number with their WebSphere Order, the order will be automatically held (i.e. placed into SALHLD status). This means the order will not print automatically (if you have this function enabled) and will instead need to be manually reviewed before it is processed.

Checking the OP23 Catalogue Data

Some members have reported that all customers are getting government prices after this catalogue has been loaded. Please follow the steps below to ensure your OP23 catalogue is correctly loaded.

  1. From the main menu, start the Products module
  2. On the Browse Products window, click the F5 Sales tab
  3. Click on the Promotions button
  4. On the Browse Promotions window, enter OP23G into the Search field
  5. Highlight the promotion OP23G and click on the Change button
  6. Check that the Sell Start Date and Sell End Date is 01/01/2011
  7. Check that the Active Start Date is 01/01/2011
  8. Check that the Active End Date is 30/06/2011
  9. Click the OK button

Additional Data on Purchasing Screens

Additional product data has been added to various purchasing screens.

Now that all Readysell customers have now been transitioned to EzyCode, you may need to reference the legacy product code in some cases. You can find the legacy code in “Previous Code” field on the following screens.

Purchase Order Entry Screen

Purchase Order Work File Screen

Additionally, we have added the Supplier Code to the following screen.

Purchase Receipt Entry Screen

Automatically Printing Devliery Dockets

Readysell can now be set up to print an invoice formatted as a delivery docket after every sale. The system reference is type “SALE” code “PRINT-DEL-DOCKET-WITH-INVOICES”.

If you would like to use this feature, start sales to create the system reference. Then from system admin set the value of the system reference to 1.

For a full list of changes with the latest version of Readysell, please review our Release Notes under “Support Downloads” on our web site.