#Item wise Qty & Amount#

Inventory\Status\StockBook\

Register

This report will display site wise item 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.

This Report is to get Site wise Division-Section-Department-Item Description level Stock qty and amount. Item Description will show Category 1 - 6 values based on the user selection.

Finance Manager, Inventory Manager, Operation Manager

Name

Selection type

Objective

Show Category 1

Single

If user opt ‘Yes’ then Report will have Category 1 Values in Item

Show Category 2

Single

If user opt ‘Yes’ then Report will have Category 2 Values

Show Category 3

Single

If user opt ‘Yes’ then Report will have Category 3 Values

Show Category 4

Single

If user opt ‘Yes’ then Report will have Category 4 Values

Show Category 5

Single

If user opt ‘Yes’ then Report will have Category 5 Values

Show Category 6

Single

If user opt ‘Yes’ then Report will have Category 6 Values

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.

Cube need to be Refreshed

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

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.