INV04 — Valuation

Operational Reports > Inventory

Who would use this report?

Warehouse, purchasing, sales, and finance staff

What is in this report?

inv04Stock holding value reportA set of data deliberately laid out to communicate business information. Depending on the context, 'report' may refer to report specification or report output. Report (more precisely, report specification) is the generic term for the objects created or edited in Cognos Analytics. Pronto Xi Business Intelligence offers a suite of standard reports., by item code, product groupIn security, a list of users or other groups that can be used to assign access permissions and capabilities. Groups can be referenced from other authentication sources or can be local to Pronto Xi Business Intelligence. Local groups are managed from BI Administration. The list of groups that an authentication user is a member of is part of the user's passport for an Pronto Xi Business Intelligence session. In reporting, grouping is the action of organising common values of query item together and only displaying the value once. Headers and footers often appear after each instance of a common value in a grouped column, warehouse or ABC class, value based on current on hand or EOM on hand.

Available in a detailed or summary viewA set of data connected to a cube, deliberately laid out to communicate business information..

How do I use it?

Select Summary or Detail to view the summary or detail version of the report.

Sort options:

• Group/Sort by — group and sortArrange elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. by item code, product group, warehouse, or ABC class

FiltersSelectively remove data from view. include:

• Show $ Values — select whether or not to display the Cost, Consignment Value, and On Hand Value columns

• Cost to Use — select the costing method

  These options come from both the stock code and stock/warehouse record

• Quantity to Use — select the quantity on hand now or the opening balance figure

  These options come from the Item Master/Warehouse detail screen

• Item Code — search by item code, item keyword or the item code or item code range

Other filters include Warehouse, Product Group, Item Type, ABC Class, Condition, and Issue Control.

What can I do in the report?

Select Summary or Detail to view the summary or detail version of the report.

You can group and sort by item code, product group, warehouse, or ABC class.

You can filter by Show $ Values, Cost to Use, and Quantity to use.