Versions Compared

Key

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

Report Name

#Inventory Status Detail#

Report Location

Inventory\Status\

Report Type

Register

Report Description

This report will show the Site wise, Stockpoint wise and Item wise inventory status detail.

Report Objective

This Report is designed to have consolidated various transactions of a barcode/All Item within the specified date range. This Report is grouped at at Site, item, stockpoint and transaction type wise.

Target Audience

Inventory Manager, Warehouse Manager

Selections

Name

Selection type

Objective

From Date

Single

Report to be shown based on transaction happened for the period starts from this date

To Date

Single

Report to be shown based on transaction happened for the period ends on this date

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

Multiple

User can opt for certain items which has stock is equal to user given value in this field. The operation of ‘equal to’ can be changed as per need during report run.

Item Vendor/Supplier

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

#Inventory Status Ledger# or any other Stock Report available in Ginesys provided the parameter selection is matcthed.

Sample Output

View file
name#Inventory Status Detail#.xlsx

Data Source Category Used

01-Master\Inventory Entry Type [LV_INV_ENTTYPE]
03-Inventory\04-Report Specific\Inventory Status Detail [TV_INV_STATUS_DETAIL]
01-Master\Item [LV_ITEM]
01-Master\Owner Site [LV_SITE]