Skip to content

How do I see what has been done on a project and the hours it has taken?

A project is the code that groups several production orders: a building job, a long job, an installation. With it, the ERP can tell you in one go what has been done, how many hours worked it has taken, what it has cost and what has been invoiced. They are in Production → Projects and Production → Hours worked.

What is a project for management purposes?

A project is a code typed in the header of a production order: ‘JOB.123’ or ‘JOB.123.PHASE1’. All the orders with that code are brought together under it.

There is no project file to fill in beforehand. The project is created when you type it on the order, with its higher levels: if you type ‘JOB.123.PHASE1’ and nothing existed, ‘JOB’, ‘JOB.123’ and ‘JOB.123.PHASE1’ are all created at once.

The code is hierarchical and the dots mark the levels. That has a practical consequence worth understanding from the start: a project’s figures always include those of the projects below it. ‘JOB.123’ adds up its own plus those of ‘JOB.123.PHASE1’; ‘JOB’ adds up everything that starts with ‘JOB’.

And it is the same code as the ‘Project’ cost accounting dimension. If the company has cost accounting turned on, that same code will also group the accounting journal lines. If it doesn’t, the project works just the same for management: you don’t need to turn anything on or maintain a separate master file.

What does the projects screen show?

Production → Projects lists the projects as a tree, with each level indented under its parent. For each one you see:

At the top, four figures summarise what is being listed. Only the top-level projects in the list are counted, precisely because a parent already includes what its children have: adding them again would count the same work twice.

You can filter by text (code or name), by prefix —type ‘JOB’ and you see only that branch— and by dates, which limit the orders: the figures are calculated with those that fall within the period. The Show projects without orders box also shows the codes that exist but don’t have any order yet; by default they aren’t shown.

When you click a row, the project details open: its figures, the subprojects below it, its orders —click to open each one— and its hours split by worker. The Back button returns to the list.

How do I read the cost, the amount, the invoiced figure and the margin?

They are four different figures and each one answers a question:

Two comparisons you make automatically when you see them together. Amount against cost tells you whether the job pays. Amount against invoiced tells you how much is left to collect of what has already been agreed: if the invoiced figure is much lower, there is work done without being invoiced.

What are hours worked and what aren’t they?

Hours worked are those someone logged on a production report: an hours line, with its worker, its date and its actual hours. They are what happened.

They aren’t the same as an order’s quoted hours. When you put ‘40 h of assembly’ on an order, that is what the customer is going to be charged; nobody has worked yet. Those hours don’t appear on this screen. They appear here when the day’s report is made and someone logs the ones that were really done.

The practical consequence is that the two figures may not match, and that is the whole point: you quoted 40 and you are at 52, or the other way round. When you close the order, if you leave the adjustment to what was carried out ticked, the order takes on the hours actually worked.

A report that only logs hours, without producing anything, is normal and counts just the same.

How do I filter and export the hours?

Production → Hours worked lists each entry with its date, the report, the worker, the order, the project, the description, the hours, the cost per hour and the cost. From the row you can open the report, the order or the project.

By default it shows the current month. You can filter by dates —the date is that of the work, not that of the report—, by worker, by project and by free text (report number, description or worker name). The This month button goes back to the starting period.

The footer of the list and the figures at the top are always for the whole filter, not for the page you are looking at: if there are 400 entries and the screen shows 25, the total is still that of the 400.

On the right, By worker splits those same hours among the people who did them, with their cost and how many reports each one worked on.

Export CSV downloads all the rows in the filter, not just the page, in a file that Excel opens in columns. It has a final row with the totals. If the filter brings more entries than fit in one download, the program says so and you just need to narrow the dates further.

Where does the cost of an hour come from?

From the *worker*’s record, if it is filled in: their cost per hour. It is the normal route and the one to use, because not all hours are worth the same.

If the worker has no cost per hour, the cost of the line’s hours item is used, which is its purchase price. That way there is always a figure to value with, even if nobody has filled anything in.

That is why the Cost/h column can vary between two lines of the same item: it doesn’t depend on the item, it depends on who worked. How that data is maintained is in who the workers are and how they are maintained.

More about Production