Promotions

New products

  • Gantt Project Planning – Plan, Link And Reschedule

    Plan your Dolibarr projects on an interactive multi-project Gantt chart: six time scales from hour to year, task hierarchy, four dependency types with lag and cascade rescheduling, critical path, milestones, budgets, workload, alert dashboard, fifteen reports and PDF, PNG, CSV and Excel exports.

    299.00 €
  • Advanced Business Workflow Management – Draw It Once, Run It Forever

    Model your business processes in Dolibarr: a visual builder chaining steps with owner, delay and type, versioned templates, roles instead of people, running instances, user tasks, validations with reasons, business rules, automatic actions, dynamic forms, notifications, history and cycle-time 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