There is a selection of reports available around stock deliveries. The builder screen looks like this;
As with similar report builders, you can set the date range at the top of the screen, then there’s a choice of four separate reports on the left.
Category
The Deliveries by Category report provides a breakdown of deliveries in the selected period grouped by category. You can choose all categories or make a selection from the list on the right.
There are options to Show Zero Values, which will show every category selected in the report even if there were no deliveries in the selected period, and Include Deleted Items, which will show any deleted categories in the list on the right and will also mean the report includes any deleted products delivered in the period.
Once you have selected the categories you wish to report on, and chosen any relevant options, click Generate Report. You’ll see a report like this;
Each category is listed, and under that the date of each relevant delivery, the supplier name, delivery note number, product, delivery size, quantity and total cost. Naturally many of the products within a category will come from the same supplier and in the same delivery, so these details may well be repeated.
Product
This is similar to the categories report, but you can specify which products the report covers rather than it showing all products within each selected category. The builder screen is very similar, but each category has an expander next to its checkbox to allow you to drill down.
Again, once you have selected the required products and any relevant options, click Generate Report.
Where the category report lists the delivery date and time followed by the product details, this report lists each product, then shows every delivery date and time in the period for that product, the supplier name, delivery note number, delivery size, quantity and total cost.
Supplier
This option allows you to select individual suppliers to report on.
Again there’s the option to Show Zero Values, for any suppliers that didn’t deliver in the selected period. Clicking Generate Report once you’ve selected the required supplier(s) from the list will show a report like this;
The supplier report shows the name of each supplier, under which is listed the date and time of each delivery they provided in the period along with the stock family, delivery note number and total cost (ex. VAT). The overall total per supplier is then shown underneath the list of their individual deliveries.
Cost Anomalies
This is a slightly different report. It highlights only delivered products that have been received at a different price to the standard price for that item. It’s again selected by supplier, though this time there’s no option for showing zero lines.
The report looks like this;
Each selected supplier is shown, under which there’s a line for each delivery in the period from that supplier where an item was charged differently to the standard price. The date and time of the delivery is shown, then the delivery note number, and then each product in the delivery that had a price variation is listed with the delivery size, quantity ordered, item cost at order, total cost at order, quantity delivered, item cost on delivery and total cost on delivery.