- APPS
- Advanced MRP Accounting 19.0
| Lines of Code | 4743 |
| Technical name | viin_mrp_account |
| License | OPL-1 |
| Website | https://viindoo.com/apps/modules/19.0/viin_mrp_account |
| Read description for | v 16.0 v 17.0 v 18.0 |
| Required Apps | Manufacturing (mrp) Invoicing (account) Discuss (mail) Inventory (stock) |
| Included Dependencies | Viindoo Manufacturing Viindoo Base Viin Warehouse Web Gantt Viin Warehouse Accounting Viin Warehouse Accounting - Enterprise Presentation |
| Extensions | Shop Floor Control - Accounting |
Know what every product cost to make, order by order
For manufacturers whose accountants close the books in the same database as production
Accounting integration for manufacturing.
Community Edition, Viindoo Cloud · OPL-1 · English, Vietnamese
What changes for your team
The cost of an order, read from the order
Today: the accountant rebuilds an order's cost from stock moves and work-center hours in a spreadsheet.
→ A done order and every product carry Cost Analysis: materials, labour and machine time, line by line.
Every production entry names its order
Today: a balance on the production account is explained by opening stock moves one by one.
→ Each journal item carries its manufacturing or unbuild order, so the ledger groups by order.
Machine time lands where your accountant expects it
Today: work-center hours are costed on one rate and sorted into cost groups by hand.
→ Each work center names its report column and the account that receives its cost.
What you see as a manager
What did each product cost to make this period, compared with the last?
Invoicing > Reporting > Manufacturing Reports > Production Cost Report
Built from the done orders of the period. The cost accountant spots the product whose cost moved and opens it.
Where does the cost of this product or order come from?
Production Cost Report > a product, or Cost Analysis on a done order
Each component and work center per order, with its cost share. The manufacturing manager sees which material or machine to act on.
Is the unit cost of a product going up or down, order to order?
Production Cost Analysis of a product, above its tables
One point per done order in the period. A rising line is a signal to review the bill of materials or the routing.
Features
Reading production cost
- ✓ Material, labour and overhead cost per product, with unit cost
- ✓ Compare with previous periods or the same period last year
- ✓ Filter by product and export to Excel
- ✓ Unit cost line across the done orders of a product
- ✓ Semi-finished goods broken down into their own costs
- ✓ Extra costs, by-products and scraps shown when an order has them
Orders and the ledger
- ✓ Cost Analysis on every done order and every product
- ✓ Journal Entries of a manufacturing or unbuild order, from the order
- ✓ Journal items searchable and grouped by manufacturing order
- ✓ A corrected consumption moves into the finished goods still in stock
- ✓ Period-end work in progress posted, then reversed on your date
Setting it up
- ✓ Four production accounts per company, in the accounting settings
- ✓ Cost classifications that become the report's labour and overhead columns
- ✓ Report column and expense account chosen per work center
Built for daily use
- ✓ Cost figures open only to users with the Basic or Read-only accounting right
- ✓ Operators close orders without any accounting right
Ready on day one
Two cost classifications
Manufacturing Overhead and Direct Labor ship ready, and existing work centers are assigned to Manufacturing Overhead.
The reports
The Production Cost Report reads the orders already done; nothing to build.
What the administrator sets first
The Manufacturing Accounts in the accounting settings, then the cost per hour of each work center.
Extend it
Shop Floor Control - Accounting
Adds the labour your operators record on the shop floor to the Direct Labor columns of these reports, and books labour, work in progress and analytic entries.
Before you decide
Does it fit our chart of accounts?
Yes. You choose the production accounts from your own chart, per company; the module ships no country-specific accounts.
We value stock periodically. Does it still help?
The cost reports read done orders in either mode. Journal entries at order completion need perpetual valuation.
Who sees the cost figures?
Users with the Basic or Read-only accounting right. Production users finish orders without seeing costs.
Where do the direct labour figures come from?
From operator time recorded with Shop Floor Control - Accounting. Without it, the reports show materials and work-center time.
What if consumption is corrected after an order is done?
The difference moves into the finished goods still in stock. What stock cannot carry stays on the production account and is noted on the order.
Try it, then ask us
The Documentation tab walks each role through the setup and the reports. Live demo: v19demo-int.viindoo.com/odoo/action-account.action_move_journal_line
Pre-sales & partnership
viindoo.com/contactusTechnical support
viindoo.com/ticketAdvanced MRP Accounting
Note
Labour of the employees on the shop floor is added to the cost reports by Shop Floor Control - Accounting - see its documentation.
Who this guide is for. Cost accountants and accounting managers who read what a product or a manufacturing order cost to make and who book the production in the ledger, production managers who prepare the work centers, and the administrator who sets the module up.
Advanced MRP Accounting makes the cost of production visible in two places: in the ledger and in a cost report. Every manufacturing order posts its consumption, the time of its work centers and its finished goods through the account of the production location, and each journal item carries its order. The Production Cost Report and the Production Cost Analysis show the direct materials, the direct labour and the manufacturing overhead of every product and every order, by period, with a comparison to the previous period and an Excel export. The module works on any chart of accounts.
The screenshots show the demo company. Mitchell Admin signs in, the products are the Drawer and the Table, and the Table is made on the work center Assembly 1. The demo database also has Shop Floor Control - Accounting installed, which is why the column Direct Labor holds figures.
Overview
The cost of production moves through five stages:
| Stage | What happens | Who acts | Hand-off |
|---|---|---|---|
| 1 | Set the manufacturing accounts of the company and check the cost classifications | Administrator | The production manager prepares the work centers |
| 2 | Set the cost per hour, the overhead cost type and the expense account of each work center | Production manager | Operators produce |
| 3 | Produce and close manufacturing orders. With perpetual valuation each order posts its consumption, its work-center time and its finished goods | Production operator | The cost accountant reads the cost |
| 4 | Read the Production Cost Report and the Production Cost Analysis, follow the entries of an order | Cost accountant | The administrator closes the period |
| 5 | Post the work-in-progress entry of the orders still in progress | Administrator |
| Role | What they do | Access right to assign |
|---|---|---|
| Administrator | Sets the manufacturing accounts and the cost classifications, posts the work-in-progress entry | Accounting / Administrator and Show Full Accounting Features |
| Production manager | Sets the costing fields of the work centers | Manufacturing / Administrator |
| Production operator | Produces and closes manufacturing orders; the entries of the order are posted without accounting rights | Manufacturing / User |
| Cost accountant | Reads the cost reports, opens the cost analysis of a product or an order, reads the entries of an order | Show Accounting Features - Readonly (or Basic) |
Setup (for the Administrator)
Installation
The module installs itself when the Manufacturing and accounting apps it builds on are installed. To switch it on from the settings:
- Open Manufacturing ‣ Configuration ‣ Settings.
- Tick Advanced MRP Accounting and click Save.
The module adds the folder Manufacturing Reports to the accounting reports, the Cost Analysis and Journal Entries buttons to manufacturing orders, and the section Manufacturing Accounts to the accounting settings.
Where to find the reports
Open Invoicing ‣ Reporting ‣ Manufacturing Reports. The folder holds the Production Cost Report.
Users who hold the accounting right but are neither Accounting / Administrator nor Manufacturing / Administrator also find the report under Manufacturing ‣ Reporting ‣ Production Cost Report.
The cost figures are open to the users who hold Show Accounting Features - Readonly or Basic. The administrator and the superuser hold the Show Accounting Features - Readonly right. A user who holds Accounting / Administrator alone sees the folder but is refused the figures.
Manufacturing accounts
The settings below appear for the users who hold the access right Show Full Accounting Features.
Open Invoicing ‣ Configuration ‣ Settings and go to the section Invoicing.
In Manufacturing Accounts, set the accounts of the company:
- Cost of Production is the account of the production location. With perpetual valuation it is debited with the components consumed and the work-center time of the manufacturing orders and credited with their finished goods, so it keeps only what an order did not pass on to its goods. While it is empty, manufacturing orders post no journal entry. With perpetual valuation an empty account is filled with the Production WIP Account; an account you set is never replaced. With periodic valuation leave it empty, or set the account that the inventory closing moves consumption and finished goods through.
- Production WIP Account is debited by the period-end work-in-progress entry with the components and the work-center time of the orders still in progress, and credited back on the reversal date.
- Production WIP Overhead Account is credited by the period-end work-in-progress entry with the work-center time of the orders in progress.
- Default Work Center Expense Account is proposed as the Expense Account of every new work center of the company. When a manufacturing order is done, the cost of its work-center time is credited to the Expense Account of the work center, else to the expense account of the finished product. A chart of accounts may provide this account.
Click Save.
The section Inventory Valuation next to it holds the Valuation of the company, Periodic (at closing) or Perpetual (at invoicing). The posting of the orders described in this guide happens with the perpetual valuation.
Note
Run the inventory closing of a date before you post the work-in-progress entry of that date. A closing computed afterwards for the same date books the components of the entry to stock variation.
Cost classifications
A cost classification is a column of the Production Cost Report. Each one is of the type Direct Labor or Manufacturing Overhead. The two classifications Direct Labor and Manufacturing Overhead exist from the start.
Open Invoicing ‣ Configuration ‣ Accounting ‣ Classification of Manufacturing Cost.
To add a column, click New, enter the Cost Name, an optional Description, and the Manufacturing Costs Type, then save. Drag the handle of a row to order the columns.
To hide a classification without deleting it, archive it.
Each work center names the classification that shows its time, see the chapter for the production manager. A classification belongs to one company, or to none and then it serves every company. The users who hold Accounting / Invoicing can change the classifications.
Access rights
Open Settings ‣ Users & Companies ‣ Users and give each person the access right of their role, as listed in the table of the Overview. Show Accounting Features - Readonly, Basic and Show Full Accounting Features are listed in the user form only when the developer mode is on. Show Full Accounting Features includes the other two.
Tasks for the production manager
Choose how the time of a work center is costed and reported
Open Manufacturing ‣ Configuration ‣ Work Centers and open a work center, for example Assembly 1.
Scroll to Costing Information.
Check the fields of the module:
- Cost per hour is the cost of the work center for each hour of machine time. The time of a work order multiplied by this rate is the machine cost of the order.
- Overhead Cost Type is the column of the Production Cost Report that shows this time. A new work center takes the first Manufacturing Overhead classification of its company.
- Expense Account receives the cost of the time of this work center when an order is done. A new work center takes the Default Work Center Expense Account of the company.
- Analytic Distribution appears when Analytic Accounting is on. It is the analytic account of the work center.
Click Save.
The fields Employee Hourly Cost and Direct Labor Cost Type of the same section belong to Shop Floor Control - Accounting.
Tasks for the cost accountant
What did each product cost to make in a period?
The Production Cost Report lists the products of the manufacturing orders finished in the period, with the cost of what went into them.
Open Invoicing ‣ Reporting ‣ Manufacturing Reports ‣ Production Cost Report.
Pick the period with the date button: This Month, This Quarter, This Financial Year, Last Month, Last Quarter, Last Financial Year, or Custom with a Start Date and an End Date and Apply.
Read the report. Each row is a product:
- Direct Material is the value of the components the orders consumed.
- Direct Labor is the labour of the classifications of the type Direct Labor, which Shop Floor Control - Accounting fills.
- Manufacturing Overhead is the time of the work centers at their Cost per hour, in the column of their Overhead Cost Type. With several classifications the report adds a column for each and a total.
- A column Extra Costs appears when an order has an extra unit cost, such as the service of a subcontractor.
- Total Cost, Total Quantity and Unit Cost close the row. The row Total adds the costs of all the products.
In the sample, the Table finished in the financial year cost 1,907.33 for 5 units: 1,415.00 of materials, 383.33 of labour and 109.00 of overhead, 381.47 for one unit.
A by-product takes the share of the cost that the bill of materials gives it, and the product made takes the rest.
Compare with another period. Open the button Comparison. Previous Period compares a month, a quarter or a custom range with the periods before it: enter how many and click Apply. Same Period Last Year compares with the same period of the years before; use it to compare a financial year with the one before. Each period is a block of columns, and the arrows show the change in percent against the previous block.
In the sample, the labour of the Drawer falls by 43.25 percent from October to November, and its unit cost by 24.96 percent.
Filter and display. The button Products limits the report to the products you pick. The button Display holds the option Break down semi-finished products: a semi-finished product consumed by an order is replaced by the materials, the work-center costs and the extra costs of the orders that made it, for the part consumed, with a row Difference to the consumed value of the product so that the total always equals the value consumed.
Export. Click Export XLSX to download the report, named Production Cost Report followed by the period. The button is shown while Comparison is No Comparison.
Where does the cost of a product come from, and is its unit cost moving?
In the Production Cost Report without comparison, click the name of a product, for example [FURN_9666] Table. The product form opens the same screen from its button Cost Analysis.
The Production Cost Analysis opens for the period of the report. Change the period with the date button.
Read the top of the screen: the quantity made, with the link to the manufacturing orders it comes from, the Total Cost and the Unit Cost. The graph draws the unit cost of each finished order, in the order of their dates.
In the sample, the unit cost of the Table falls from 395.10 for WH/MO/00013 to 361.33 for WH/MO/00017.
Scroll down to the tables. Each table lists the lines of the orders of the period:
- Direct Materials Costs: each material with its Actual Consumption Quantity, its Unit Cost, the Cost Share (%) of the product and the Total Cost, which is the quantity multiplied by the unit cost and the share.
- One table for each cost classification, here Direct Labor and Manufacturing Overhead: the Cost Name, the order, the Cost Share (%) and the Cost.
- Extra Costs, By products and Scraps when the orders have them. A scrapped component leaves the materials and is listed under Scraps.
The option Break down semi-finished products of Display works here as in the report.
In the sample, the order WH/MO/00017 consumed 283.00 of materials (Table Top 240.00, four Table Leg 40.00, Bolt 2.00, Screw 1.00), 58.33 of labour and 20.00 of machine time: 361.33 in total.
What did one manufacturing order cost?
The cost of an order is known once the order is done.
Open Manufacturing ‣ Operations ‣ Manufacturing Orders and open a done order, for example WH/MO/00017.
Click Cost Analysis. When the screen is too narrow for all the buttons, the button is under More.
The Production Cost Analysis shows that order only, with no period and no graph.
An order that is not done has no cost analysis yet: the message says that Cost Analysis is available once the manufacturing order is done.
The product form has the same button. Open Manufacturing ‣ Products ‣ Products, open a product and click Cost Analysis; it opens the analysis of the product.
Which entries did an order post?
With perpetual valuation a done order posts its consumption, the time of its work centers and its finished goods through the account of the production location, and the entries net to zero per order on that account. Each journal item carries the order, and an unbuild order carries its own.
The button Journal Entries of a manufacturing order and of an unbuild order lists every entry of it: the entries of its items and its period-end work-in-progress entries with their reversals. The button appears when the order has entries.
Open Invoicing ‣ Review ‣ Control ‣ Journal Items, open Group By and choose Manufacturing Order to see the production account per order, even when one entry covers several orders. The same list can be searched by Manufacturing Order and Unbuild Order.
On a journal entry, the tab Other Info shows the Manufacturing Order or the Unbuild Order the entry is about, for users who hold Manufacturing / User.
A company on periodic valuation has no entry per order, so these buttons stay hidden for its orders.
Tasks for the administrator at period end
Post the work-in-progress entry of the orders in progress
The entry puts the value of the components and of the work-center time of the orders that are not finished into the Production WIP Account, and reverses itself on a later date. The action needs Show Full Accounting Features.
Open Manufacturing ‣ Operations ‣ Manufacturing Orders and open the order.
In the gear menu next to the order number, choose Post WIP Accounting Entry.
Check the Journal, the Reference, the Date and the Reversal Date, then the lines. You can still edit the lines: amounts and accounts are posted as typed.
Click Post WIP.
The sample order is not started, so every line is 0.00. For an order in progress the lines carry the value of its components and of its work-center time. The entry is part of the Journal Entries of the order.
What happens when the consumption of a done order is corrected
When the quantity consumed of a component of a done order changes, or a component is added to it, the correction reaches the ledger and the finished goods:
- The change is shared among the finished goods of the order: each by-product takes its cost share, the product made takes the rest.
- The goods valued at FIFO or at average cost take their share into their value, so the goods still in stock carry it. Goods at a standard cost keep their standard; goods whose value was set by hand keep it.
- With perpetual valuation and an account on the production location, one entry moves the component back to stock or out of it and the goods in stock to or from the account of the production location. The entry is dated on the day the order was done when that date is still open, else today.
- What the goods in stock cannot carry stays on the account of the production location: goods already sold or consumed, goods at a standard cost, goods whose value was set by hand.
- With periodic valuation the goods are revalued without an entry.
- The chatter of the order names the change, the amount left on the account and the entry.
The person who corrects the consumption needs no accounting right.
Troubleshooting
| Symptom | What to check |
|---|---|
| The Production Cost Report is not in the menu | The user needs Show Accounting Features - Readonly or Basic. Accounting / Administrator alone shows the folder but not the figures. |
| The section Manufacturing Accounts is not in the settings | The user needs Show Full Accounting Features. |
| Post WIP Accounting Entry is not in the gear menu | The user needs Show Full Accounting Features, and the order must not be done. |
| Cost Analysis is not on a manufacturing order | The button is shown on done orders only, and to users who hold Show Accounting Features - Readonly or Basic. |
| Journal Entries is not on a manufacturing order | The order has no entry. Orders post entries with perpetual valuation and an account in Cost of Production. |
| The column Direct Labor is empty | The labour of employees comes from Shop Floor Control - Accounting. Without it the column has no figure. |
| The time of a work center is in the wrong column | Check the Overhead Cost Type of the work center. |
| Export XLSX is not shown | The button is shown while Comparison is No Comparison. |
FAQ
- Which orders does the Production Cost Report count?
- The orders that are done, finished within the period, of the companies you are allowed to read.
- Does the module work with periodic valuation?
- Yes for the reports. The orders post no entry of their own; the account in Cost of Production stays empty or is the account the inventory closing uses.
- Can I read the cost of an order before it is done?
- No. The cost analysis opens once the order is done.
- Does a correction of a done order change the report?
- Yes. The report shows the net quantity and value of the consumption.
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.