Promotions

New products

  • Label Designer for Dolibarr

    Create personalized labels easily for your products, batches, warehouses, and third parties directly from Dolibarr. Design a reusable visual template with text, images, barcodes, and QR codes, then automatically generate print-ready PDFs with the data of each item.

    180.00 €
  • Building Finishing Works Management – Second-Fix & Finishing Trades ERP for Dolibarr

    Turn Dolibarr into a complete ERP for second-fix and finishing contractors: projects, sites with phases, lots and zones, works board, site log, timesheets, stakeholders, subcontractors, trade teams, tenders and contracts, quotes on quantity take-offs, technical studies, materials and stock, purchasing, equipment, HSE, quality and snags, documents, monthly situations and reporting.

    299.00 €

Perpetual Inventory Accounting

c20959d20200609115633

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.

25.00 €
Excl. tax

Previous Next
  • Author Ohoo Solutions
  • Module version 1.0
  • Release date 06/09/2020
  • Compatibility Dolibarr V11 - V12
  • Last update 05/22/2026 02:32 PM

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



If you think this module is a fork of another one (published after the first one) or violates some terms or conditions of use (for users or vendors), you can make a report at dolistore@dolibarr.org