Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Incorrect Product Cost Calculation in Odoo (Example of Average Method) - My Last question explained in detail.
8.0 and above
Steps to reproduce:
Create a Supplier: Pepsi Co and Create a Product: “Can”. In Costing Method of product select: Average Price.
Operation: Create a Purchase Order with above Supplier and Product. Quantity = 5, Purchase Price = 10. Confirm Purchase, Receive Products and Validate Invoice.
Total Cost of Products = 50. Total Quantity = 5. Adjusted Cost per Can = 10.
Operation: Create a Purchase Order with above Supplier and Product. Quantity = 8, Purchase Price = 15. Confirm Purchase, Receive Products and Validate Invoice.
Total Cost of Products = 170. Total Quantity = 13. Adjusted Cost per Can = 13.08.
Operation: Create a Sales Order with above Supplier and Product. Quantity = 4, Sales Cost Generated By Odoo will be = 13.08. Confirm Sale, Transfer Products and Validate Invoice.
Total Cost of Products = 117.69. Total Quantity = 9. Adjusted Cost per Can = 13.08
Operation: Create a Purchase Order with above Supplier and Product. Quantity = 50, Purchase Price = 1. Confirm Purchase, Receive Products and Validate Invoice.
Total Cost of Products = 167.69. Total Quantity = 59. Adjusted Cost per Can = 2.84.
Now, Suppose I forgot to register a purchase order after Step 3. Register it with the back Date so it will be after second PO: Quantity = 25, Purchase Price = 50. Confirm Purchase, Receive Products and Validate Invoice.
Total Cost of Products = 1417.69. Total Quantity = 84. Adjusted Cost per Can = 16.88.
This Last Cost Of Product calculated by ODOO is TOTALLY INCORRECT!
Cost should be 15.72.
Last Picking was made was with back date after third step, and If you make it after step 3 without “”forgetting”, then the Cost will be: 15.72. This means that program didn’t recalculate the cost as should have done. It means that Inventory valuation becomes incorrect if someone makes a purchase with back date.
If user uses Anglo Saxon Accounting (Which writes off cost with journal entry), then the journal entry posted by sale will be INCORRECT as well.
Program should recalculate the cost of the product if user registers the purchase with the back date. Same is for Sales for Back Dates.
Forgetting to register sale or purchase is normal and is faced in everyday operations. Incorrect Inventory value will result in charges from TAX Department or Noticed in Audit Reports.
Recalculation of backdated entries not a best practice. the reason is as and when the stock move happens system calculating the cost.
If you have installed Anglo saxon even cost of sales also calculated so recalculating the cost for the done transactions will effect the system reliability.
In Average cost you have option to update the cost in product master manually
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/8/15, 5:31 AM|
|Seen: 1125 times|
|Last updated: 5/8/15, 8:47 AM|