Promotions

  • Advanced Professional Gantt Dolibarr

    Would you like to see your project evolve in an efficient and structured way? The Gantt Professional Advanced Module allows you to manage all your projects in one place, without the need to use Gantt Project. We believe that you can effectively manage your projects with the right tools in place, and the Gantt Professional Advanced Module is one of them.

    360.00 €  ( 720€ )
  • Medical Center

    DoliMed is a module to manage a medical center. Patients, consultations, alerts, documents, ...

    67.20 €  (84€)

New products

  • FacturZen : Relance factures impayés automatique

    The FacturZen module for Dolibarr simplifies and automates the management of overdue invoice reminders. Whether via email or internal tasks, FacturZen helps you optimize your debt collection processes while maintaining full control over your actions.

    72.00 €
  • Translate

    Automatic translate your products & services database into other languages thanks to online translations tools

    60.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.

30.00 €

Previous Next
  • Author Aruna Gnanasekaran
  • Module version 1.0
  • Release date 06/09/2020
  • Compatibility Dolibarr11.0.0 - 12.0.2
  • Last update 01/02/2025 04:59 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