- APPS
- Shop Floor Control - Accounting 19.0
| Lines of Code | 771 |
| Technical name | viin_mrp_workorder_account |
| License | OPL-1 |
| Website | https://viindoo.com/apps/modules/19.0/viin_mrp_workorder_account |
| Read description for | v 18.0 |
| Required Apps | Manufacturing (mrp) Invoicing (account) Discuss (mail) Inventory (stock) Employees (hr) |
| Included Dependencies | Advanced MRP Accounting Shop Floor Control Viindoo Manufacturing Viindoo Base Viin Warehouse Web Gantt Viin Warehouse Accounting Viin Warehouse Accounting - Enterprise Presentation |
Shop floor labour in your product cost, priced person by person
For manufacturers that record operator time on the shop floor and cost their production in accounting
Book the labour, work in progress and analytic entries of Shop Floor Control in accounting.
Odoo 19.0 · Community Edition, Viindoo Cloud · OPL-1
Extends Shop Floor Control - see its documentation.
What changes for your team
Labour per work order, at each person's rate
Today: operator time is recorded at the machine, then priced by hand.
→ Every finished order shows its direct labour, one row per work order: the time of each person at their own hourly cost, frozen when the time line closes.
Work in progress per work center
Today: the value of components between consumption and receipt is tracked outside the system.
→ Each consumed component is booked on the work center's own analytic account and offset when the finished goods are received; the balance is what is still in progress. The work center line carries machine time plus labour, with the hours counted once.
A period-end entry that counts each component once
Today: components posted early are credited from stock again at period end, then corrected by hand.
→ The work-in-progress entry leaves out the components already posted with Post Consumption and moves their value into work in progress, under perpetual and periodic valuation.
Ready on day one
Installs with its two modules
It installs itself when both required modules are present, and every existing work center gets a direct-labour column on the cost report.
Standard cost includes the crew
Compute Price from BoM adds the planned employees of each operation at the work center's hourly cost per employee.
What the administrator sets first
The manufacturing accounts, Analytic Accounting, and a WIP analytic account on each work center to track. Work centers without one are not tracked.
What is included
Everything on this page, inside the reports, forms and dialogs of Manufacturing and Invoicing your teams already use. It adds no menu of its own.
Before you decide
Can a pay rise re-price finished work?
No. Each time line freezes the employee's hourly cost when it closes, or the work center's hourly cost per employee when the employee has none. Posted labour keeps its booked rate, even when the credited employee is corrected afterwards.
Two people at one machine: is the machine time counted twice?
No. The machine hours are counted once; the hours of each person go to labour.
Does it work when stock is valued periodically?
Yes. The work-in-progress lines and the period-end entry work under perpetual and periodic valuation.
Who sees the labour figures?
The cost report and the analytic items need Show Accounting Features - Readonly. The accounting settings and the period-end entry need Show Full Accounting Features, and the entry also needs Manufacturing / User to open the order. Grant these rights per person.
Does it assume a country's chart of accounts?
No. It books to the work-in-progress, stock valuation and production accounts your company configures, on any chart of accounts. Languages: English and Vietnamese.
Try it, then ask us
The Documentation tab covers the setup and each role's tasks. Live demo: v19demo-int.viindoo.com
Pre-sales & partnership
viindoo.com/contactusTechnical support
viindoo.com/ticketTechnical requirements
- Odoo version: 19.0
- Editions: Community Edition, Viindoo Cloud
- Required modules: Shop Floor Control, Advanced MRP Accounting
- License: OPL-1
- Languages: English, Vietnamese
Shop Floor Control - Accounting
Note
Extends Shop Floor Control - see its documentation. It also builds on Advanced MRP Accounting - see its documentation.
Who this guide is for. Cost accountants and accounting managers who read and book the cost of manufacturing, production managers who prepare work centers and operations, and the administrator who sets the module up.
Shop Floor Control - Accounting carries the labour credited to each employee on the shop floor into the cost of your manufacturing orders. The direct labour of every work order appears on the Production Cost Report at the hourly cost of the employees who did the work, the analytic entries of a work center include that labour, a work center can track the value of the components it consumes on its own analytic account, Compute Price from BoM adds the employees of each operation, and the period-end work-in-progress entry counts each component once.
The screenshots show the demo company. Mitchell Admin signs in, Marc Demo, Anita Oliver, Paul Williams and Jennie Fletcher are employees who are credited with time, and the Table Top is made from two Wood Panel on the work center Assembly 1.
Overview
The module adds no menu of its own. It makes the screens you already use for manufacturing and accounting carry the labour of the shop floor:
- Direct labour. The labour of a work order is the time of each closed time line multiplied by the hourly cost of the employee credited on that line. The hourly cost is frozen when the line closes, so a later change to an employee's hourly cost never re-prices finished work. An employee who has no hourly cost of their own is priced at the Employee Hourly Cost of the work center.
- Machine time. The cost of the work center itself is its Cost per hour multiplied by the machine hours. When several employees work at the same time, the machine hours are counted once, and the line holds the machine only: the labour is on the direct-labour line.
- Analytic accounts. A finished work order writes one analytic line on the Analytic Distribution of its work center, with the machine cost plus the labour. A work center that has a WIP Analytic Account also tracks the value of the components it consumes, until the finished products are received.
- Price from the bill of materials. The cost of an operation adds the planned employees to the work center: expected duration multiplied by the Employee Capacity of the operation multiplied by the Employee Hourly Cost of the work center.
- Period-end entry. The work-in-progress entry counts each component of an order in progress once, by where the accounts hold its value at the date of the entry, under perpetual and periodic valuation.
The work moves through four stages:
| Stage | What happens | Who acts | Hand-off |
|---|---|---|---|
| 1 | Install the module, turn on analytic accounting and set the manufacturing accounts | Administrator | The production manager prepares the work centers |
| 2 | Set the cost fields of the work centers and the employees of the operations, price a product from its bill of materials | Production manager | Operators record their time on the shop floor; the cost accountant reads the result |
| 3 | Read the direct labour on the Production Cost Report and follow labour and work in progress on the analytic items | Cost accountant | The accounting manager closes the period |
| 4 | Post the work-in-progress entry | Accounting manager |
| Role | What they do | Access right to assign |
|---|---|---|
| Administrator | Installs the module, turns on analytic accounting, sets the manufacturing accounts, assigns the access rights | Role / Administrator, and Show Full Accounting Features to see the accounting settings |
| Production manager | Edits work centers and operations, runs Compute Price from BoM | Manufacturing / Administrator |
| Cost accountant | Reads the Production Cost Report and the analytic items | Show Accounting Features - Readonly |
| Accounting manager | Posts the work-in-progress entry | Accounting / Administrator, Show Full Accounting Features and Manufacturing / User |
Setup (for the Administrator)
Installation
The module installs itself when Shop Floor Control and Advanced MRP Accounting are both installed. To get both from Shop Floor Control:
Open Manufacturing ‣ Configuration ‣ Settings.
In the section Operations, tick Shop Floor Control - Accounting. It installs Advanced MRP Accounting and the accounting apps it needs. The box is already ticked when the module is installed.
Click Save.
A work center always has a Direct Labor Cost Type: a work center created without one receives the first Direct Labor cost type of its company, and so does every work center that exists when the module is installed.
Accounting settings
The settings below appear for users who hold the access right Show Full Accounting Features.
Open Invoicing ‣ Configuration ‣ Settings.
In the section Manufacturing Accounts, set the accounts of manufacturing:
- Cost of Production is the account of the production location. The value of a component consumed by an order passes through it when the stock valuation is perpetual.
- Production WIP Account is the account the period-end entry debits.
- Production WIP Overhead Account is the account the period-end entry credits with the work center time and the labour.
The module works with both valuations of the field Valuation, Periodic (at closing) and Perpetual (at invoicing). The examples of this guide use the perpetual one.
In the section Analytics, tick Analytic Accounting. The fields Analytic Distribution and WIP Analytic Account of a work center appear for users who have this option.
Click Save.
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. The two accounting rights Show Accounting Features - Readonly and Show Full Accounting Features are listed in the user form only when the developer mode is on; the second includes the first. The administrator and the superuser hold Show Accounting Features - Readonly.
The accounting manager also needs Manufacturing / User: without it the manufacturing orders are closed to that person and the entry cannot be opened.
Tasks for the production manager
Choose where the labour of a work center is reported and tracked
Open Manufacturing ‣ Configuration ‣ Work Centers and open a work center, for example Assembly 1.
Scroll to Costing Information.
Check the fields that decide how the work center is costed:
- Cost per hour is the cost of the work center itself, and Overhead Cost Type is the column of the Production Cost Report that shows it.
- Employee Hourly Cost (per employee) is the hourly cost used for an employee who has no hourly cost of their own. It also prices the planned employees of an operation.
- Direct Labor Cost Type is the column of the Production Cost Report that shows the labour of this work center. It is Direct Labor by default. The columns are the cost classifications of Invoicing ‣ Configuration ‣ Classification of Manufacturing Cost.
- Analytic Distribution is the analytic account that receives the cost lines of the work center, including its labour.
- WIP Analytic Account is the analytic account that tracks the work in progress of this work center: the components it consumes, until the finished products are received. Leave it empty to not track it.
Click Save.
Price a product from its bill of materials
Compute Price from BoM adds the planned employees of each operation to the cost of the components and of the work centers. The cost of an operation is its expected duration multiplied by the Cost per hour of its work center, plus the same duration multiplied by its Employee Capacity and by the Employee Hourly Cost of the work center.
Open Manufacturing ‣ Configuration ‣ Operations and open an operation, for example Manual Assembly. Employee Capacity is the number of employees the operation needs, here 2, and Default Duration is 60:00 minutes.
Open Manufacturing ‣ Products ‣ Products and open the manufactured product, for example Table Top.
Next to Cost, click Compute Price from BoM.
The cost of the Table Top is 212.00:
- Components: 2 Wood Panel at 80.00, 160.00.
- Work center time: 1 hour on Assembly 1 at 12.00, 12.00.
- Employees: 1 hour for 2 employees at 20.00, 40.00.
An operation whose field Cost based on is Theorical time counts its labour on the plan in the same way when the order is costed: expected duration multiplied by the employees multiplied by the Employee Hourly Cost. An operation costed on Actual time counts the time lines of the employees.
Tasks for the cost accountant
Read the direct labour of finished orders
The labour of a work order is the time of each closed time line multiplied by the hourly cost of the employee credited on that line. That hourly cost is frozen when the line closes: a later change of an employee's hourly cost never re-prices work that is finished.
Open Invoicing ‣ Reporting ‣ Manufacturing Reports ‣ Production Cost Report. Users who hold the accounting right but are not Manufacturing administrators also find the same report under Manufacturing ‣ Reporting ‣ Production Cost Report.
Pick the period with the date button. The report lists the products of the orders finished in that period. The column Direct Labor is the labour of those orders, the column Manufacturing Overhead is the time of the work centers.
Click a product, for example Table, to open the Production Cost Analysis. In the section Direct Labor, each row is one work order of the finished order.
In the sample, the order WH/MO/00021 assembled the Table in 100 minutes. Paul Williams (hourly cost 15.00) and Jennie Fletcher (hourly cost 20.00) were each credited with the 100 minutes, so the Direct Labor row is 25.00 plus 33.33, 58.33. The time of the work center is counted once, 100 minutes at 12.00, and is the Manufacturing Overhead row, 20.00.
Note
An employee who has no hourly cost of their own is priced at the Employee Hourly Cost of the work center, and that rate is frozen on the time line when the line closes. To price an employee at their own rate, enter the Hourly Cost in the settings of the employee.
Once the labour of a work order has been posted to accounting, correcting the credited employee of one of its time lines does not re-price the line: it keeps the rate that was booked.
Follow labour and work in progress on analytic items
Open Invoicing ‣ Accounting ‣ Analytic Items. The list needs the option Analytic Accounting. The list opens with the filters From last fiscal year and P&L Accounts; remove P&L Accounts, because the lines of manufacturing carry no financial account.
Labour in the analytic entry of the work center. When a work order is finished, its work center writes one line for it on its Analytic Distribution, named [WC] followed by the order and the operation. The amount is the cost of the work center time plus the labour of the time lines at their frozen rates, and the quantity is the hours worked, counted once. A work center whose Cost per hour is zero still receives the labour line. When your manufacturing orders belong to projects through the application MRP Account Project, the analytic line of the order on the project carries the same amount.
Work in progress of the work center. When a component is consumed in a work order whose work center has a WIP Analytic Account, the consumption writes a line with the name starting with [Raw] on that account, with a negative amount. The component belongs to the operation that consumes it, or to the last operation of the order when its bill of materials line has no operation. When the finished product is received with a value, a line with the opposite amount offsets it. Until the receipt, the account holds the value of the components still in progress. These lines exist under both valuations.
Search the Description for the number of the order and for a component, for example WH/MO/00022 and Wood Panel.
In the sample, the work center line of WH/MO/00022 is -78.00 for 1.50 hours on the account Production: 18.00 for the 1.50 hours of the work center at 12.00, plus 60.00 of labour, 45.00 for Marc Demo (90 minutes at 30.00) and 15.00 for Anita Oliver (60 minutes at 15.00). The Wood Panel consumed by the order is -160.00 on the account Assembly 1 WIP, and the receipt of the finished products offsets it with 160.00: the value in progress of the order is zero.
When the consumption of a finished order is corrected afterwards, the lines of the work in progress follow it, so that the account stays at zero for that order.
Tasks for the accounting manager
Post the period-end work-in-progress entry
The period-end entry puts the value of the orders still in progress into the work-in-progress account. A component can reach accounting earlier, with Post Consumption on its work order. The entry takes that into account and does not count the component twice.
Open Manufacturing ‣ Operations ‣ Work Orders and open a work order that is in progress. Click Post Consumption to post the components already picked for it.
Open Manufacturing ‣ Operations ‣ Manufacturing Orders and open the order. In the gear menu, choose Post WIP Accounting Entry. The action needs Show Full Accounting Features.
Check the Journal, the Reference, the Date and the Reversal Date, then check the lines.
Click Post WIP. The entry is reversed on the Reversal Date, by default the next day.
In the sample, a Drawer Case Black of the order WH/MO/00009 was posted with Post Consumption (10.00) and the time of the order is 54.00. The lines read:
- WIP - Component Value: 0.00. The component is already posted, so the stock account is not credited again.
- WIP - Overhead: credit 54.00, the work center time plus the labour of the closed time lines up to the date.
- Manufacturing WIP followed by the order: debit 64.00 on the work-in-progress account.
- WIP - Posted Component Value: credit 10.00, on the account of the production location where the posted component sits, so that its value moves into work in progress.
Three cases are handled in the component lines:
- A component already posted with Post Consumption is taken off the credit of the stock accounts. When its posted value sits on an account other than the stock valuation account and the work-in-progress account, a line WIP - Posted Component Value moves that value into work in progress from the account that holds it.
- A component posted while the database had no stock valuation, for example before accounting was installed, never reached a stock account. It is not credited from stock either.
- A component that is still in stock at the date of the entry is credited from the stock account, as for any order in progress.
The wizard shows a notice above the lines when a component stays in stock only because the company has no stock closing up to the date of the entry while it has a later one: No stock closing up to this date is known for the components, so the entry keeps them in stock. If an earlier closing took them out of stock, adjust the lines before posting. The notice does not block the posting.
You can still edit the lines before you click Post WIP: the amounts and accounts are posted as typed.
Troubleshooting
| Symptom | What to check |
|---|---|
| The labour of an order is zero | The employee credited on the time lines has no Hourly Cost and the Employee Hourly Cost of the work center is zero. Enter one of them. Finished and posted lines keep the rate they were closed with. |
| The labour of a work center is not in the column you expect | The Direct Labor Cost Type of the work center decides the column of the Production Cost Report. |
| There is no WIP Analytic Account field on the work center | Analytic Accounting is off in the Invoicing settings. |
| A component has no work-in-progress line | The work center that consumes it has no WIP Analytic Account, or no work order consumes it. The offset line appears only after the finished products are received with a value. |
| The Analytic Items list is empty | Remove the filter P&L Accounts: the lines of manufacturing carry no financial account. |
| Post WIP Accounting Entry is not in the gear menu | The user needs Show Full Accounting Features, and Manufacturing / User to open the order. |
| The Production Cost Report is not in the menu | The user needs Show Accounting Features - Readonly or Show Full Accounting Features. |
FAQ
- Does a change of an employee's hourly cost change the labour of finished orders?
- No. The hourly cost is frozen on each time line when it closes.
- Are the hours of two employees working together added to the machine time?
- No. The machine time of the work center is counted once. The hours of each employee are in the labour.
- Does the module work when the company values its stock periodically?
- Yes. The work-in-progress entry counts each component once under perpetual and periodic valuation, by where the accounts hold its value at the date of the entry.
- Where do I change the account that receives the labour of a work center?
- The labour is on the Analytic Distribution of the work center, and in the Production Cost Report under its Direct Labor Cost Type.
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.