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
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?
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.
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
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.
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).
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?
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.
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?
