Skip to main content

Migrate To Perpetual Inventory

Perpetual Inventory Valuation is activated by default in the system.

For the users who are currently following periodic inventory valuation system, and wish to migrate to perpetual inventory valuation system, please follow the steps explained below.

1. How to Migrate to Perpetual Inventory​

  1. To enable perpetual Inventory, ensure that the Stock in Hand Account is synced with the value of actual stock value in your Warehouse(s). To sync it, you will have to create a Journal Entry for the difference amount against expense account (generally used in Purchase Invoice).

For example, when perpetual inventory was disabled, you must be having Expense (Cost of Goods Sold) booked via Purchase Invoices. Now, you will have to create a Journal Entry to move the value of existing stock from expense account to stock in hand account.

Cr. Expense account ......... XXX

Dr. Stock in Hand account ... XXX

It can also work other-way round if you were selecting a stock in hand account in the Purchase Invoice.

  1. Before enabling Perpetual Inventory, ensure that Stock Accounts (ledger) is linked for the existing Warehouse. The stock account for a Warehouse can be set at three levels.
  • In the Warehouse master itself
  • In the Parent Warehouse master
  • Default Stock in Hand Account in the Company master, if you maintain only one Stock-in-hand account for all the Warehouses.
  1. Journal Entry to Update Stock Received but not Billed account

An account \