Timesheet does not match to salesorder

invoice timesheet salesorder

1 Odgovori

4599 Prikazi

Steffen Graf

Hello Odooers,

we have sent out some invoices based on timesheets.

Now I have got feedback from our customers: The sum of delivered hours listed in timesheets does not match the sum listed in the corresponding salesorder/invoice. What happened there?

Please have a look in the attached screenshot.

NOTE: I know - the value displayed in the smart button is rounded off. But when I klick on it I will get all recorded hours. For example: The Delivered value is 8,50 hours - the recorded hours will sum up to 9:15 hours.

Thank you

Steffen

Warwick Grace

I came here looking for an answer as I had a similar issue... I thought I had everything set up correctly, but the delivered quantities weren't being reflected in the sales order at all even though I could see timesheet entries that appeared to be tied back to the sales order lines...

What I had done wrong was I had updated the invoice policy on the service product after I had set them as invoice items in the project. Odoo doesn't like apply retroactive changes like this, so I had to remove everything from the project and sales order, and then re-add them again; then I was able to timesheet and have it accurately reflect on the sales order!

Ricardo Gross

Best Answer

In Timesheets App, switch to the "List view" and if inactive, activate the column "sales order item" and check for time entries without correspondence:

This error can occur when projects are created manually without sales order items and can also be checked by activating the column directly in the Timesheets entries from Tasks:

Steffen Graf

Avtor

Hello Ricardo,

Thank you for your response. With the help of your tips, I was able to correct the faulty invoices. However, I haven't been able to determine the exact source of the errors yet.

In today's billing run, two invoices were incorrect:

One invoice, or its corresponding timesheet, had a booking without a sales order item.
In the other timesheet, everything seemed fine. However, I identified a booking line that was considered in the timesheet but not in the invoice. Without knowing the exact internals, I would say that the corresponding record was corrupt.
Before the next billing run, I will make sure to check all time entries in the Timesheets app more thoroughly. Alternatively, we might consider changing the process so that only approved time entries are invoiced. This way, I can correct any arising bookings directly.

Best regards,
Steffen

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi

Related Posts	Odgovori	Prikazi
Attach timesheet to invoice invoice timesheet	3 feb. 24	5869
Modify Print / Portal Invoice Template invoice timesheet	1 feb. 23	5000
how to add to_invoice field on timesheet view on odoo 9 invoice timesheet	0 dec. 17	4198
Invoice days based on the Timesheet invoice timesheet	4 apr. 16	10065
Create invoices based on timesheets invoice timesheet	0 feb. 16	6930

This question has been flagged

Enjoying the discussion? Don't just read, join in!