Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log onto Readysell>Reports>List Reports>L-018 Stock Report
  2. Highlight the report and click on 'Show Report Using Parameters'
  3. Start date = 01/01/1900
  4. End date = 01/01/1900
  5. Include Non Stock Products = True (if you are reconciling all stock whether stocked or non stocked)
  6. Include Archived Products = True
  7. Include out of stock products = True
  8. Not shipped since date = leave the default date. 

    Info
    titleShow me



Note

If you need to see the stock on hand for anytime any time in the past prior to today use the Calculated Value on Hand and Calculated Quantity on Hand fields.
If you need to see the stock on hand as of today's date use the Value on Hand, Quantity on Hand fields .Leave the (note if you run it as of today bear in mind transactions maybe taking place, best to run it on the test database for the day before for an accurate figure)

Leave today's default date on the field of 'Not Shipped Since' .

This report calculates the value as 'Ex Tax'.
In With respect to Imported data, all imported data is brought over as a one-line entry dated 1/1/1900 being the initial starting stock on hand for that product.

To check some of the data on the report to the live data: Product file>highlight a product>click on Sites>Movements and filter the stock movements by adding the field of 'Imported' to the detail list view. Filter for 'Unchecked'. You will see the starting stock on hand position dated 1/1/1900 with all current movements since.



...

  1. In the Navigation panel, go to Reports>List Reports.
  2. Search for Stock Report
  3. Highlight the report and click on the Parameter 'Show Report Using Parameter'

    Expand
    titleShow me


    To find out what the stock on hand was in the Past, set the start and end date to be that date (same date).
    To find out what the stock on hand is as of now, set the start and end date to be today
    Turn on the appropriate check boxes 
    Leave the date in the field of 'Not Shipped Since' to default to todays today's date.
    If you wish to narrow the report even further, you can select one supplier and/or one category otherwise leave these fields blank. 

  4. Click OK
  5. Result The result appears as above image (Image of report result) depending on the parameters.

    Expand
    titleShow Me


  6. The report defaults with the following fields 'Calculated Quantity on Hand' and 'Calculated Value on Hand'.
    These two fields are used if you run the report for any date into in the past
    If you have run the report as of today, add the following two fields to the report 'Value on Hand' and 'Quantity on Hand'.


  7. This report can be customized to suit your company
    Copy the Original Stock Report
    Rename the Report and ensure to assign it to the right Category, Click on Save
    When you run the copied version, add the columns you require, and remember to click on 'Save Report Layout'.


...