Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Report Name

#Item Group wise Qty & Amount#

Report Location

Inventory\Status\StockBook\

Report Type

Register

Report Description

This report will display site wise item group wise total Inventory movement. This Report will provide quantity as well as cost amount of inward as well as outward type movements along with opening, closing and some other relevant information separately. Since this report is based on 'Stock Book' Cube, it is required to refresh the cube and based on the cube output the report display record.

Report Objective

This Report is to get Site wise Division-Section-Department level Stock qty and cost amount.

Target Audience

Finance Manager, Inventory Manager, Operation Manager

Selections

Name

Selection type

Objective

Cube Name

Single

User need to select a Cube Name (I.e. Stock Book Summary Cube) from the list. The report data to be shown based on the same.

Site Type

Multiple

User can opt for specific Site Type from the list for any specific reporting purpose.

Site Name

Multiple

User can opt for specific Site Name from the list for any specific reporting purpose.

Dependencies

Cube Need to be refreshed

Alternative reports to validate

Any Stock Report available in the following location Inventory\Status\StockBook

Sample Output

View file
name#Item Group wise Qty & Amount#.xlsx

Please Note that the Report is visible in browser in collapse mode at site level. Can be clicked on the arrow beside site name to expand to next level. When it is exported (as the sample output attached) all those collapsed information get expanded for better understanding.

Data Source Category Used

01-Master\Item [LV_ITEM]
01-Master\Owner Site [LV_SITE]
03-Inventory\01-Cube\Stock Book Summary [PV_STOCK_MOVEMENT_NEW]