Home > Reports > Screen Shots/Explanations > Inventory Status By Department Report

Inventory Status By Department Report

What Is It?

This reports shows the inventory movements (sales, receipts, adjustments, and so on) for items during a specified date range. The items are grouped by department, category and group. For each item the report shows the opening balance as of a selected date and the total of various stock transactions (sales, rec, transfers, returns, adjustments) to give a closing balance. Supports selection of data by PDA import. New sort parameter has been added to allow sorting by Department or Supplier.

Full details for a single item can be obtained by using Stock Audit.

Command

Client - REQUESTREPORTINVENTORY.EXE INVSTATUSBYDEPTREP

Server - REPORTINVENTORY.EXE

What Are The Report Parameters?

Location

The location to report inventory for. If this is a group, a separate report is generated for each location within the group.

Date Range

The date range to report transactions for. The opening balance will be given for the From Date and all transactions between the From and To dates (inclusive) are reported.

Dept/Cat/Group/Sub Group

All items within the selected department, category and group are reported. If left empty all items are reported.

Family Group

All items within the selected family group are reported. If left empty all items are reported.

Classification

All items within the selected classification are reported. If left empty all items are reported.

Grade

All items within the selected grade are reported. If left empty all items are reported.

Supplier

All items from this supplier are reported.

PDA Import#

All items from the PDA import are reported.

Cost To Use

The cost to use when calculating the value of stock. The Actual Cost option uses the cost of the item at the time it was received. However, this is the actual cost paid and does not take into consideration any expected rebates at that point in time. The Buy Cost option, calculates the cost as of the To Date of the report. In this case the system can calculate the expected rebate. However, it does not take into consider that different units of stock may have been purchased at different costs. If you are using Average Cost or Last Invoice Cost as the Cost Of Goods Sold method, then you should use the Actual Cost option. The Buy Cost option is only applicable if you are using FIFO.

Report Items With No Stock

If checked on then items marked as stocked and which have a stock on hand of zero are printed.

Report Items With Stock

If checked on then items with stock on hand greater than zero are printed.

Report Items With Negative Stock

If checked on then items with stock on hand less than zero are printed.

Group By

Department or Supplier.

Paper Requirements

This report prints on A4 paper in Landscape mode.

Sample Report

Figure: Example Inventory Status By Department Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)