Report Name | #Item wise Qty & Amount# | ||||||
|---|---|---|---|---|---|---|---|
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' 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 Description level Stock qty and amount. Item Description will show Category 1 - 6 values based on the user selection. | ||||||
Target Audience | Finance Manager, Inventory Manager, Operation Manager | ||||||
Selections | 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. | |||||
Dependencies | Cube need to be Refreshed | ||||||
Alternative reports to validate | Any Stock Report available in the following location Inventory\Status\StockBook | ||||||
Sample Output |
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] | ||||||
General
Content
Integrations
App links