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!

#Inventory Status Summary#

Report Name

#Inventory Status Summary#

Report Location

Inventory\Status\

Report Type

Register

Report Description

This report will show the Site and Stockpoint wise inventory status summary.

Report Objective

This Report is designed to have Stock Report with various dimension at stock point level

Target Audience

Inventory Manager, Warehouse Manager, Operation Manager, Finance Manager

Selections

Name

Selection type

Objective

As On

Single

User can select a particular date for which he wants to have the stock Report.

Division

Single

User can opt report for a specific Division by selecting any one from the list. ‘ALL’ can be selected if no specification is needed

Section (for selected Division)

Single

User can opt report for a specific Section by selecting any one from the list. ‘ALL’ can be selected if no specification is needed

Department (for selected Section)

Single

User can opt report for a specific Department by selecting any one from the list. ‘ALL’ can be selected if no specification is needed

Site type

Single

User can opt any one site type from the list for the report else ‘ALL’ can be selected for report with out any specification.

The options available in the list are

Customer Owned Store Site , Organization Owned Store Site, Organization Site

Sites (for selected Site Type)

Single

User can opt for any specific Site from the list. If no specific site needed to select then can opt for ‘ALL’

Stock Point Group

Single

User can opt for any specific Stock Point Group from the list. If no specific site needed to select then can opt for ‘ALL’

Location Wise

Single

User can opt to see the Report on location wise. If it is selected as ‘Yes’.

Stock Point

Single

User can opt for any specific Stock Point from the list. If no specific site needed to select then can opt for ‘ALL’

Show Barcodes

Single

If user opt ‘Yes’ then Report will have Item Barcode

Show Category 1

Single

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

Show Category 2

Single

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

Show Category 3

Single

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

Show Category 4

Single

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

Show Category 5

Single

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

Show Category 6

Single

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

MRP From

Single

User can opt for report based on items with certain MRP. Here user can define the lower boundary of the MRP range.

MRP To

Single

User can opt for report based on items with certain MRP. Here user can define the upper boundary of the MRP range.

Closing Stock (Above)

Single

User can opt to consider certain items in the report, which have stock more than the value defined in this field.

Item Vendor

Multiple

User can opt to have report for those items which has been purchased from a specific vendor / group of vendors selected in this option.

Category1

Multiple

User can select Single/multiple Category 1 values here to see in the report.

Category2

Multiple

User can select Single/multiple Category 2 values here to see in the report.

Category3

Multiple

User can select Single/multiple Category 3 values here to see in the report.

Category4

Multiple

User can select Single/multiple Category 4 values here to see in the report.

Category5

Multiple

User can select Single/multiple Category 5 values here to see in the report.

Category6

Multiple

User can select Single/multiple Category 6 values here to see in the report.

Barcode

Multiple

User can select Single/multiple Barcode values here to see in the report.

Dependencies

NA

Alternative reports to validate

Any Stock Report available for the selected Date

Sample Output

 

Data Source Category Used

01-Master\Item [LV_ITEM]
01-Master\Owner Site [LV_SITE]
01-Master\Stockpoint [LV_STOCKPOINT]
03-Inventory\04-Report Specific\Inventory Status Summary [TV_INV_STATUS_SUMMARY]