mO SharemO Share

We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!

#Item wise Qty & Amount (Batch-Serial)#

Report Name

#Item wise Qty & Amount (Batch-Serial)#

Report Location

Inventory\Status\StockBook\

Report Type

Register

Report Description

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 Summary Batch' 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-Item/Batch-Serial Description level Stock qty and amount. Item Description will show Category 1 - 6 and Description 1 -6 values based on the user selection.

Target Audience

Finance Manager, Inventory Manager, Operation Manager

Selections

Name

Selection type

Objective

Cube Info [Cube Code | Cube Name | Period | Refreshed On]

Single

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

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

Show Description 1 :

Single

If user opt ‘Yes’ then Report will have Description 1 Values

Show Description 2 :

Single

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

Show Description 3 :

Single

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

Show Description 4 :

Single

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

Show Description 5 :

Single

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

Show Description 6 :

Single

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

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