Odoo
Implementation
Actual Costing Method | Inventory Valuation With Actual Costing Method | Effective Inventory Valuation | Product Costing Method
by Creyox Technologies https://www.creyox.com
Odoo
$ 225.20
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (account_accountant)
• Inventory (stock) • Purchase (purchase) • Sales (sale_management) • Invoicing (account) • Discuss (mail) |
| Lines of code | 229 |
| Technical Name |
cr_actual_costing_ent |
| License | OPL-1 |
| Website | https://www.creyox.com |
| Versions | 16.0 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (account_accountant)
• Inventory (stock) • Purchase (purchase) • Sales (sale_management) • Invoicing (account) • Discuss (mail) |
| Lines of code | 229 |
| Technical Name |
cr_actual_costing_ent |
| License | OPL-1 |
| Website | https://www.creyox.com |
| Versions | 16.0 17.0 18.0 |
Community
Enterprise
Odoo.sh
Actual Costing Method | Inventory Valuation With Actual Costing Method | Actual Costing Method at Item Level.
Overview
The "Actual Costing Method" is a precise cost accounting approach that tracks the exact material cost for each lot or serial number, rather than relying on average costing, FIFO (First In, First Out), or standard costing methods. By calculating costs directly from purchase or manufacturing orders, this method enables detailed and accurate costing reports. Unlike Odoo’s Standard Costing, which assigns a fixed cost per product, FIFO, which uses the cost of the oldest stock items, and Average Costing (AVCO), which calculates a weighted average for all stock items, the Actual Costing Method records the real value of each received product and retains that specific cost for all subsequent transactions.
This approach is particularly useful for reducing variances that may arise with traditional costing methods. By assigning an exact cost to each inventory item, it provides a clear and precise view of material costs, allowing businesses to analyze the costs of purchase and manufacturing orders in real-time, even before orders are finalized. This level of detail enhances cost control and overall inventory management, offering a more accurate assessment of actual product costs.
Features
- Inventory Valuation base on Costing Level of Product Category.
- Effectively reflect the Actual cost of goods based on actual purchase cost.
- Easy to track the valuation of goods based on Lot/Serial Number.
- Utilize the Actual cost of goods while generating Purchase & Sale orders for it.
- User can manage the Refund functionality with the Actual Costing Method.
- Generate Journal Entries for the Purchase & Sale orders with actual purchase cost.
- Automatic calculation of product pricing based on specified Lots or Serial Numbers.
- Support for various costing methods, such as Standard, FIFO, and Average.
- Supported in Enterprise Edition Only.
Inventory Valuation With Actual Costing Method Flow
- Navigate to Inventory >> Configuration >> Product Categories.
- Here user can create a Category or Select the Existing Category with Storeable Products.
- User need Change Costing Method to First In First Out(FIFO) and Costing Level to Lot/Serial Number.
- Navigate to Inventory >> Products >> Products.
- Here user have to set the Product Type as Storeable Product & Product Category which has the costing level set as Lot/Serial Number.
- Also user have to set the Traceability to By Lots from the Inventory Tab.
- Further user need to do some configurations for Accounting.
- Navigate to Settings >> there search for Automatic Accounting and enable it and save the changes.
- Also make sure that the Inventory Valuation is set to Automated and there user will see a block for Account Stock Properties.
- Now Navigate to Purchase and create 2 Purchase Orders with the storeable product of previously Created or Selected Product Category and different Unit Price.
- Clicking on Confirm Order button user will see a Smart Button of Receipt and state as Purchase Order.
- Click on Receipt Button and enter Lot/Serial Number for the Product.
- When user will click on Validate it will create a Inventory Valuation entry for it as WH/IN.
- To check the Inventory Valuation entry navigate to Inventory >> Reporting and then Valuation.
- Here along with the valuation entries the accounting entries like Journal Entries will also be created automatically.
- To check the Journal Entries user need to navigate to Accounting >> Accounting >> Journal Entries.
- Here in Journal Entries user will see the entries for the valuation.
- Now Navigate to Sale and create 2 Sale Orders with the storeable product of previously Created or Selected Product Category.
- Clicking on Confirm Button user will see a Smart Button of Delivery and state as Sale Order.
- Click on Delivery Button and select Lot/Serial Number for the Product.
- When user will click on Validate it will create a Inventory Valuation entry for it as WH/OUT.
- Coming back to Inventory Valuation entry, Here user will see the entry for WH/OUT.
- Also user can check the accounting entries like Journal Entries and the Journal Items when user create invoice against the sale order.
- To check Journal Entries user need to navigate to Accounting >> Accounting >> Journal Entries.
- Here user will see the Journal Entries against the valuation for the sale order.
- Later when user create invoice against the sale order by click on Create Invoice from sale order and Confirm the invoice.
- Here under the page Journal Items user will see the accounting entries.
- User can also create a valuation and journal entries for the scrap orders.
- User need to navigate to Manufacturing >> Operations >> Scrap and create a scrap order with a Lot/Serial and validate it.
- User can check the valuation from Inventory >> Reporting >> Valuation.
- Also, User can check the journal entries from Accounting >> Accounting >> Journal Entries.
Our Services
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module