Home >
Reports > Screen Shots/Explanations > Inventory Status
By Department With UOM Report
Inventory Status By Department With UOM 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. This report
is the same as Inventory Status by
Dept report but with an added column for display of UOM and
shows quantities to 3 decimal places instead of 4 places.
Full details for a single item can be obtained by
using Stock Audit.
Command
Client - REQUESTREPORTINVENTORY.EXE
INVSTATUSBYDEPTWITHUOMREP
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.