Perpetual Inventory Accounting

c20959d20200609115633

New

This Module enables the Perpetual Inventory Account posting on the Inventory transactions. This module will enable the posting of Cost of Goods Sold on every Shipment Validation. Also, this module will manage the Goods Received Not Invoiced Posting on the Purchase Module. The Inventory Valuation will be done based on the Weighted Average Cost of the Product.

More details


30,00 €

More info

Module version: auto
Publisher/Licence: Ohoo Solutions / AGPL
User interface language: English
Support Portal:  Ohoo Solutions Support Portal
Support Email:  support@ohoosolutions.com
Installation Document Link: Please Click Here
FAQ & Pre-Requisites: Please Click Here

Prerequisites:

  • Dolibarr min version: auto
  • Dolibarr max version: auto

Install (For Dolibarr v9+:

  • Go into menu Home - Setup - Modules - Deploy an external module and submit the zip file
  • Module is then available and can be activated.

Install (For Dolibarr v8-):

  • Download the archive file of module (.zip file) from web site DoliStore.com
  • Put the file into the root directory of Dolibarr.
  • Uncompress the zip file, for example with command  unzip module_perpetualinventory-1.0.zip
  • Module is then available and can be activated.

Installation Document Link: Please Click Here

Features of the addon:

The periodic and perpetual inventory systems are different methods used to track the value of goods on hand. The more sophisticated of the two is the perpetual system, but it requires much more online management of Inventory related General Ledger posting. The periodic system relies upon an occasional physical count of the inventory to determine the ending inventory balance and the cost of goods sold, while the perpetual system keeps continual track of inventory GL balances.

This Module enables the Perpetual Inventory Account posting on the Inventory transactions. This module will enable the posting of Cost of Goods Sold on every Shipment Validation. Also, this module will manage the Goods Received Not Invoiced Posting on the Purchase Module. The Inventory Valuation will be done based on the Weighted Average Cost of the Product.

The Perpetual Inventory Module will be generating a Journal on the Purchase Receipt creation as shown below

 

Inventory

Dr

Purchase Cost * Received Quantity

Goods Received Not Invoiced

Cr

Purchase Cost * Received Quantity

 

The Dolibarr Standard Journal posting on the Purchase Invoice is expected to be as shown below (When the Tax / VAT / GST is 0)

 

Goods Received Not Invoiced

Dr

Purchase Cost * Invoiced Quantity

Accounts Payable

Cr

Purchase Cost * Invoiced Quantity

 

 The Perpetual Inventory Module will be generating a Journal on the Validation of Sales Shipment as shown below

 

Cost of Goods Sold

Dr

Weighted Average Cost * Delivered Quantity

Inventory

Cr

Weighted Average Cost * Delivered Quantity