跳至内容
菜单
此问题已终结

Q1: Why does Odoo system generate Revaluation journal entry (negative inventory)(WH/MO/XXX) (MO for manufacture order)?

The automated journal entry is hitting inventory account and work in progress account (account set on virtual production location).


Q2: How do I balance the work in progress account?


Related post: Revaluation (negative inventory) (WH/OUT/XXX) (OUT for delivery)

https://www.odoo.com/forum/help-1/why-does-odoo-system-generate-revaluation-journal-entry-negative-inventory-wh-out-xxx-232344

形象
丢弃
编写者 最佳答案

Prerequisite:

1. Set product category to Automated inventory valuation.

2. Set Anglo Saxon on accounting.


When the user pushes a manufacture order to finish even the warehouse doesn’t have enough material.

We will observe a situation where the quantity of material on hand becomes negative. Subsequently, when we attempt to restock the material through either procurement or inventory adjustment, Odoo will automatically create a revaluation journal entry to account for the negative inventory utilized in the prior manufacturing order.

 

***********************************************************************************

The following screenshot and workflow is using v16.0.

The solution should be applied to most of the versions.


Configuration:

1.      Setup work in progress (WIP) account (asset type of account) in inventory location > virtual production            


2. Set components, and finished good product to an automated  valuation in the product category (Either FIFO or Average costing  )

3. Create a component and finish goods product where the cost is $0 and there is 0 on hand quantity.




Workflow: 

4. Create a manufacture order to consume the components when there is 0 on hand to use.


5. Push the manufacture order to be complete (I.e., consume qty 1 components)

6. There is no journal entry since the stock valuation shows $0 on both finished goods and components.


7. Purchase and receive the components. (I.e., buy qty 10 components at $11 each)


8. Instead of 10, we will observe a quantity of 9 components. Simultaneously, Odoo will generate a revaluation journal entry, crediting the stock valuation to reflect the usage of a component.  




Explanation

* From steps 5 and 6, Odoo would automatically create a journal entry for the finished goods and a journal entry for the component.

*This is the missing journal entry (JE1) after completing a manufacturing order for the finished goods

Account

Debit

Credit

Stock valuation  

11​

-

Work in Progress

 -

11

*This is the missing journal entry (JE2) after completing a manufacturing order for the components
But Odoo automatically creates this journal entry when we purchase and receive the components.

Account

Debit

Credit

Stock valuation  

11

Work in Progress

 11

-


*Upon acquiring the components for 10 units at $11 each, Odoo will automatically generate a journal entry to record the consumption of one component for the preceding manufacturing order once the 10 components have been received.

See the revaluation journal entry below

Revaluation journal entry of the component (JE2)

Account

Debit

Credit

Stock valuation  

 

11

Work in Progress

11

 

 


Since there is a missing journal entry (JE1) for finished goods upon manufacture order completion, after we deliver the product, Odoo will not recognize the stock value and the cost of goods sold.

*This is the missing journal entry (JE1) after completing a manufacturing order for the finished goods

Account

Debit

Credit

Stock valuation  

11​

-

Work in Progress

 -

11


* This is the missing journal entry (JE3) for delivering finished goods (sales)goods

Account

Debit

Credit

Stock valuation  

 

11

Stock interim delivered

11

 


* This is the missing journal entry (JE4) for the invoice for the cost of goods sold.

Account

Debit

Credit

Stock interim delivered

 

11

Cost of goods sold

11

 


If all three missing journal entries are created automatically, the stock valuation account and stock interim delivered account would offset to zero.

We should manually create the journal entry for Work in progress and cost of goods sold.

This way work in progress would balance to zero with the revaluation journal entry.


Solution: 


Create a manual journal entry (JE5). 
Cr. Work in progress and Dr. Cost of goods sold


Account

Debit

Credit

Work in Progress

 

11

Cost of good sold

11

 

 



形象
丢弃
相关帖文 回复 查看 活动
2
7月 24
6803
1
12月 23
2603
1
12月 24
4015
1
9月 23
1212
1
2月 25
1757