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.
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.
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.
Journal Entry to Update Stock Received but not Billed account
An account "Stock Received but not Billed" is an adjustment account which reflects the value of the stock for which Purchase Receipt has been submitted, but Purchase Invoice is yet to created. A Journal Entry should be created to update the value open Purchase Receipt pending for billing into "Stock Received but not Billed" account.
To know the value of the stock received but not billed, you can refer the report "Received Items Pending for Billing" in the Accounts module.
Create a Journal Entry as follows to update the value in Stock Received but not Billed account.
Cr. Stock Received but not Billed ........... XXX
Dr. Expense Account (COGS) .................. XXX
Setup the following default accounts for each Company
Go to: Home > Accounting > Company