Stock Ledger

Stock Ledger

Introduction
Stock Ledger is a record which shows the stock details including the opening stock, closing stock, in stock and out stock of the items. For each item, you can also view the transaction history including purchase, sales, stock in hand, adjusted stock etc.

Purpose:
Users can view the stock flow of the items-
  1. From a selected category or from a selected manufacturer or for all the items
  2. For a single day or for a specific period
  3. With or without selling rates of the items

To view the stock details, follow the steps below:

1. Click Inventory >> Stock Ledger [CTRL+L]. The Stock ledger screen is displayed with the Filter screen.

 

Use the filter screen-

  1. To select the date or period
  2. To select few or all the items from the item LOV
  3. To filter the items based on manufacturer
  4. To filter the items based on category

The items are loaded in the Stock ledger screen based on the selection in the filter.

Note: After selecting the date or period, you can load all the items without using the other filter options by pressing the Esc key.

2. In the Date field, enter the date for which you want to view the stock details of the items. By default, the system date is displayed in the date field.

3. In the Item Name field, press Enter. The Item LOV is displayed.

 

4. Select one or more items from the LOV. Press spacebar to multi-select the items (or) press ALT+A to select/deselect all the items in one time.

 


 

5. Press Esc key. The items are loaded in the Stock Ledger screen with the stock details.

 

To view the stock details with selling rates, press F2 [WSaleRate] key in the Stock Ledger screen. The selling price of the items are shown in the Selling column as shown in the below image.

 

Other Filter options:

Manufacturer based selection

To view the stock details of the items specific to a manufacturer, follow the steps below:

1. In the Manufacturer field, press Enter. The Manufacturer LOV is displayed.

2. Select the manufacturer from the LOV. Press Esc key. The stock details of the items from the selected manufacturer will be loaded in the Stock Ledger screen.

Category based selection

The created categories will be listed in the filter screen. In this case, the categories created were BRAND and COLOUR. For category selection, follow the steps below:

1. In the BRAND field, press Enter. The BRAND LOV is displayed. Select the BRAND from the LOV.

 

3. In the COLOUR field, press Enter. The COLOUR LOV is displayed. Select the COLOUR from the LOV.

 

5. Press Esc key. The stock details of the selected categories will be loaded in the screen.

 

Other features

Loading all items

1. To load all the items, enter the date or period and press Esc key in the Stock Ledger screen. A confirmation message to load all the items is displayed.

 

2. Click Yes. All the items in the selected date or period will be displayed in the screen along with the stock details.

 

Viewing stock for a period

The stock flow of the items for a particular period can also be known. Follow the steps below-

1. Press F4[Period] key in the Stock Ledger screen. The From and To fields are displayed in the Filter screen.

 

2. In the From and To fields, enter the dates.

3. Press Esc key to load all the items of the selected period.

 

4. To know the date-wise stock details of each item, select the item and press Enter. The stock details of the selected item is displayed.

 

For Matrix items

Similarly, the stock flow of the matrix items for a particular period and the date-wise stock details of each matrix combination can be known. [Refer the images below]

 

To know the date-wise stock details of each combination, select the matrix item (in this case shirt) and press Enter. The stock details of the selected item is displayed.

 

Report

Stock Ledger Details [Report ID: 3116]

 



Stock Ledger




    • Related Articles

    • Stock Report - Lot Number

      Stock Report - Lot Number Purpose: Traceability: Lot numbers provide a unique identifier for batches of products. Checking stock based on Lot numbers allows you to trace the origin and history of each batch, which is crucial in industries like ...
    • Stock Repost

      Stock Repost Purpose: The purpose of stock repost in a POS system is to update the inventory levels of a particular product. When a product is sold, the POS system reduces the inventory level of that product in the system. Stock repost can help to ...
    • CSV Import Support in Stock Update

      CSV Import Support in Stock Update Purpose: The purpose of stock updation is to reduce the costs of holding stock while ensuring you can meet customer demand. Businesses should always have a 'safe' amount of stock so that they're able to react and ...
    • Tax Based on Tax Slab Rate in Stock Transfer out Transaction

      Tax % Based on Tax Slab Rate in Stock Transfer out Transaction Purpose: The purpose of Tax % based on tax slab rate in stock transfer out transaction in RetailEasy Apparel POS is to calculate and apply the appropriate tax rate on the value of the ...
    • How to change from Temporary Purchase to Normal Purchase with Temp Stock Adjustment

      How to change from Temporary Purchase to Normal Purchase with Temp Stock Adjustment Purpose: The purpose of performing a temporary stock adjustment when converting a temporary purchase to a normal purchase in a POS system is to ensure that the ...