# Inventory Journal **URL:** \ **Category:** Financial modules\ **Tags:** Journals, Accountancy, Help, v14\ **Created:** [November 14, 2021, 1:43pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431 "2021-11-14T13:43:06Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [November 14, 2021, 1:43pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/1 "2021-11-14T13:43:06Z")
I am not seeing any inventory transaction in the INV (Inventory) Journal when I try to run the report, and unlike the other journals am I missing something as I can see movements at the item level but need to be able to get to this information? I am utilizing the Double Entry Accounting Module and Manufacturing orders, so I have to be able to audit these transactions. I also believe I have an issue with items not posting to the ledger correctly so need to get this resolved quickly Appreciate any help you can offer ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 14, 2021, 7:30pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/2 "2021-11-14T19:30:13Z")
Hello In order for others to offer help, please state your Dolibarr setup including the version you are using. Screenshots may help also. ---
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [November 14, 2021, 7:36pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/3 "2021-11-14T19:36:08Z")
I am using version 14.0.2, but when I go to look at the inventory journal nothing is showing ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/c/c4b0e4c17e3ff65aa04984dcecf37a4b9e65ae43.png) ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 17, 2021, 1:00pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/4 "2021-11-17T13:00:53Z")
The Programming of the Inventory Item is not complete: On Purchases the Entry Must be Inventory DR Account Payable CR or This is already done Cost of Purchases or Expenses DR Accounts Payable CR On Sales This will not be done in Dolibarr on sales of the Items Sales CR Account Rec DR Inventory CR Cost of Sales DR Why? Check the Module, So we must do that entry above manually ---
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [November 17, 2021, 7:16pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/5 "2021-11-17T19:16:45Z")
I am sorry but I do not understand what you are stating, are you stating I set-up something wrong or that Dolibarr has not programmed this and the function does not exist? ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 18, 2021, 9:17am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/6 "2021-11-18T09:17:37Z")
I am talking about what is missing when you setup the Item: This picture below is comparisson and journalization effects, ![DOLIBARR COMPARISSON](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/8/8aa93aecf027b43987f71041acc1539fc4cb4f76.png) Can you explain how? Or As for me I did the Costing manually, Oh dolibarr is Free Anyway. By the Way Straight 3 year with 4 Accounting Cycle I used Dolibarr. Audited 4 times. ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 18, 2021, 9:22am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/7 "2021-11-18T09:22:41Z")
Okay, I am running Windows Server, 120gm solid state, 30gb ram, Dolibarr version 12 upgrade to 14, PHP 8 mysql 8.0.17. It is running fine. Everything is okay. Now I want only to know how to do that Inventory and Costing ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 18, 2021, 9:24am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/8 "2021-11-18T09:24:09Z")
I am saying, Nothing so called Inventory Module, It is called in Dolibarr Products Module. You have to understand that. ---
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [November 20, 2021, 2:37pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/9 "2021-11-20T14:37:44Z")
I am sorry but I am still confused by what you are stating, I set-up a test item received in items and corrected stock but I still see nothing in the inventory journal. Below is how I set it up, based on what I think you were stating in your previous. ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/6/6a64c2b0c621ef6598b9a55325812532dcfe923e.png) ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 22, 2021, 5:28am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/10 "2021-11-22T05:28:56Z")
You have a wrong setup,: Your entry for purchases import will be resulted to this: 2001 - Accounts Payable - Debit 2001 - Accounts Payable - Credit The Correct shall be(let say you assigned Accounting code (purchase import) 1201 Materials Inventory 1201 - Materials Inventory - Debit 2001 - Accounts Pyable - Credit That Accounting Code should not be there because you are setting up the Products or Services. The Accounts Payable which is you assigned 2001 should only be assigned on the following Module: Third party —\> then Vendor Setup then that 2001 Account code shall be there, below is the picture ![dolibarr AP](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/3/3d6ada19dd67304b9f3c84a53f0b851101307e44.png) ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [November 22, 2021, 5:39am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/11 "2021-11-22T05:39:36Z")
On your case, You need to assigned either, Cost or Inventory Account meaning either Assets or Cost/Expenses, it is wrong to assigned Liability Account for setting up New Products. Yes you are right, the stock is correct and the corresponding amount but your Journal Entries will be resulted into wrong Accounting Code(on this case Liability vs Liability). ![dolibarr inventory cost](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/1b928a23d9b0637359030ebcf7bd9aba8729b714.png) ---
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [November 22, 2021, 6:05pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/12 "2021-11-22T18:05:47Z")
Thank you very much I think I understand now, you help is greatly appreciated this module really needs documentation. ---
**Author:** ![jkellogg](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/e68b1a/32.png) [@jkellogg](https://www.dolibarr.org/forum/u/jkellogg)\ **Post date:** [December 4, 2021, 2:20pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/13 "2021-12-04T14:20:53Z")
I am sorry to bother you again, but I am setting up items that are issued to manufacturing orders I assume Account Code (sale) should have the items issued to Inventory Work in Process (WIP) but do not understand the reasoning for 4 accounts or should they just be the same as the one above? |Accounting code (sale)|1210 - WIP Inventory| |Accounting code (sale export)|1210 - WIP Inventory| \*\*\*\* This One\*\*\*\*\* |Accounting code (purchase)|1205 - Product Packaging| |Accounting code (purchase import)|1205 - Product Packaging| \*\*\*\* This One \*\*\*\* ---
**Author:** ![isoscent](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/isoscent/32/3200_2.png) [@isoscent](https://www.dolibarr.org/forum/u/isoscent)\ **Post date:** [December 14, 2021, 12:38pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/14 "2021-12-14T12:38:08Z")
Yes Correct but you have to do the manual costing at the time of Sale, At the time of Sales recall the Journal Entry from the Accounting, Then customer Invoice Binding: then Edit this one: This should be the Entry: Debit - Account Receivables Credit - Sales Then Add This Entry Debit - Cost of Sales Credit - (12100)Inventory No Entry has Yet so you need to Journalized it or Just leave it, but just leave it. Nothings has affected on the Journalization of if You used only one Inventory Account. But in Your Case since you created an Accounts for this. You have to manually Journalized it. Do not touch the Setup code for Setting up the Products. ---
**Author:** ![sheref](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@sheref](https://www.dolibarr.org/forum/u/sheref)\ **Post date:** [February 12, 2025, 9:45am UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/16 "2025-02-12T09:45:04Z")
Dears, if you please can you clarify how to read inventory journals in the reports of Accounting I made all your clarifications but can’t read any thing in (inventory journal) for example ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/c/ccb8fa9c3aebd1a6435683e2312b33947db71fec.png) also, ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/0/061436457102ae6985fdd4d07ab12202287b9136.png) or you advice to buy the module > **[Perpetual Inventory Accounting](https://www.dolistore.com/product.php?id=1174&title=perpetual-inventory-accounting&l=en)** > > 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... ---
**Author:** ![hiplus](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/hiplus/32/8667_2.png) [@hiplus](https://www.dolibarr.org/forum/u/hiplus)\ **Post date:** [July 24, 2025, 4:37pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/17 "2025-07-24T16:37:16Z")
> [@isoscent](#): > > On Sales > This will not be done in Dolibarr on sales of the Items > > Sales CR > Account Rec DR > Inventory CR > Cost of Sales DR > > Why? > Check the Mo Dear Dolibarr comunity, now 4 years later on Dolibarr 21.01 we still have the same problem as isoscent describes. A sale will only create an accounting journal entry of “sales income” vs “accounts receivables” but the inventory (“stock of finished goods”) shall be reduced and the “cost of sales” has to be deducted from the earnings. Right now for each sale the accounting generates a 100% margin and does not reduce the value of my inventory. That is such a big flaw that I can’t believe that there isn’t a solution to it. I created a script that generates the missing journal entries for the whole week and then I have to upload the csv file using the import feature. But still, this is prone to errors. My solution is to find out what tables exactly the import feature touches in the Database, so I could automate the process with an SQL statement. Of course a better way would be a modified PHP module to make the 4 entries instead of only 2. Does anyone know of a solution to this topic? Or exactly which php files must be modified, or how to create a journal entry in the Maria DB? ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [July 29, 2025, 4:44pm UTC](https://www.dolibarr.org/forum/t/inventory-journal/21431/18 "2025-07-29T16:44:37Z")
hey @hiplus did you enable the stock module in your dolibarr?