Learn How to Reconcile Opening Stock in RetailGraph Software | Stock Reconciliation

Reconcile Opening Stock In SwilERP (RetailGraph)

How to Reconcile Opening Stock/Inventory in SwilERP

In SwilERP, there is an option to Reconcile Opening Stock. With this option, users can add stock quantities in products as per their requirements, and you can also add stock in newly created or already created products. In this process, the system checks and records actual physical stocks. The existing and current inventory in the system should be accurate; if not, you can use the stock reconciliation option to reconcile the opening stock.

  Note:- You can create a new product and add the opening stock with this option.  

These are the step-by-step instructions to reconcile opening stock:

Start with Login in the SwilERP dashboard to initiate the process:

  1. Go to Inventory > Reconcile Opening Stock.

Reference Image:
SwilERP Dashboard Window

The process when you create a new product:

  1. Go to the Home tab.
  2. In the Reconcile Opening Stock window, whenever you create a new product then, your stock is considered as opening stock: 
  3. Select the Product from the list, or the user can create a new product. 
  4. If you select a new product, then first you have to allow Lot details- 
    1. Click on the Right button on your mouse.
    2. Click on the option of Set Grid Layout.
    3. Then, search Lot Number and tick mark on Visible, Allow focus. 
    4. Save the window.
Reference Image:


How to select product Lot number details:

  1. Click on Lot number, and then you will see "-1" Select this.  
  2. Then, you'll see a pop-up window of Product Lot.
  3. Enter the Required details - 
    1. Enter the Batch number manually. 
    2. Enter MRP/ Rate/ Sale Rate and other details. 
    3. Click on OK. 

Reference Image:

Lot number details

How to select the Product to reconcile:

   After updating Product Lot details, follow the below steps to reconcile the opening stock:

  1. Add quantity in Actual Stock.
  2. Now, add Actual Stock and further details will be filled automatically.
  3. Save the window, and stock will add. 

Reference Image:

Product to reconcile

When you add stock to an already created product:

  In Reconcile Opening Stock window, when you add stock to an already created product, your inventory is considered as same as the previous opening stock:
  1. Select the Product from the List. 
  2. Then, Select a Lot Number from the list; you can create a new lot number like the above-given information. 
  3. Now, add Actual Stock and further details will be filled automatically.
  4. You can also view the last Shortage/Surplus entries from the information below.
  5. Save the page. 

Reference Image:

created product

Other options of the View tab:

While Reconcile current stock, users can select the following options: 
  1. To view Reconcile Current Stock list:
  1. View > Browse details as per the requirement (i.e. Month wise, Date wise, etc).
  1. To Navigation:
  1. View > Previous (Alt+Up) & Next (Alt+Down).
Reference Image:
View tabView Tab Options

Using the Reports Tab:

  1. Reports > Select the report which you want to view.
Reference Image:
Reports TabReports Tab Options

Features of the References tab:

The References tab offers various tools for efficiently managing and viewing product details. Some of the key features include:
  1. References >  Rate List/ Product Info/ Product Search/ Generic Search.
Reference Image:
References tabReferences Tab Options