Promotions

  • massaction

    This module offers new mass actions: batch download of PDF documents as a zip archive, batch adding of recipients to a mailing list, batch assignment of a salesperson to third parties.

    216.00 €
  • 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€ )

New products

  • Validate stock

    This module helps if you don't have a single method for increasing stock.

    30.00 €
  • CRM 360

    This module provides a comprehensive overview of customer interactions and data, centralizing all relevant information in one place.

    420.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 Ohoo Solutions
  • 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