...
- Log onto Readysell>Reports>List Reports>L-018 Stock Report
- Highlight the report and click on 'Show Report Using Parameters'
- Start date = 01/01/1900
- End date = 01/01/1900
- Include Non Stock Products = True (if you are reconciling all stock whether stocked or non stocked)
- Include Archived Products = True
- Include out of stock products = True
Not shipped since date = leave the default date.
Info title Show 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. Leave today's default date on the field of 'Not Shipped Since' . This report calculates the value as 'Ex Tax'. 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. |
...
- In the Navigation panel, go to Reports>List Reports.
- Search for Stock Report
Highlight the report and click on the Parameter 'Show Report Using Parameter'
Expand title Show 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.- Click OK
Result The result appears as above image (Image of report result) depending on the parameters.
Expand title Show Me 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'.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'.
...