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 Ledger#

Report Name

#Inventory Status Ledger#

Report Location

Inventory\Status\

Report Type

Register

Report Description

This report will show the Site wise and Item wise inventory status ledger having Stock transaction details like add or minus during the time period.

Report Objective

This Report is designed to have movement of a barcode for a specified period of time. This Report is grouped at at item wise date with entry no wise stock point 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.

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

Any Stock Report will match provided the criteria matches. Mainly #Item Barcode History# / #Item Costing# can be used to match individual item level stock qty.

Sample Output

 

Data Source Category Used

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