/
New report INTRN065 - Stock Take History with Categories

New report INTRN065 - Stock Take History with Categories

Problem

There was no report that allowed you to view variances only over a number of stock takes and allowing

Solution

SQL skills required

A working knowledge of SQL Management Studio is required to complete this task

The report is designed to allow reporting over a number of activated stock takes, in part number order based on Classifications and / or Categories and can print variances only if required.  Here is an example of the report with variances only requested.

Download the report and use Refresh from Files from the System Settings > Report Configuration > Reports form.  Add the report to the relevant menus.  Run the relevant SQL script over the database.

Related articles







Related content

Additional Stock Take reports
Additional Stock Take reports
More like this
What report can I use to track inventory movements by warehouse?
What report can I use to track inventory movements by warehouse?
More like this
Stock Takes
Stock Takes
More like this
Inventory reports have been re-formatted for readability
Inventory reports have been re-formatted for readability
More like this
What report can I use to track postings to an account for a defined Set Number range?
What report can I use to track postings to an account for a defined Set Number range?
More like this
GLMGT235 - Profit & Loss With Actuals, Budgets, Variance reported incorrect budget 2 and 3 information
GLMGT235 - Profit & Loss With Actuals, Budgets, Variance reported incorrect budget 2 and 3 information
More like this