Skip to Content
This question has been flagged
invoicetimesheetsalesorder
1 Reply
2509 Views
Avatar
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



Avatar
Discard
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!

Avatar
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:


Avatar
Discard
Steffen Graf
Author

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

Related Posts Replies Views Activity
Attach timesheet to invoice
invoice timesheet
Avatar
Avatar
Avatar
3
Feb 24
3059
Modify Print / Portal Invoice Template
invoice timesheet
Avatar
Avatar
1
Feb 23
3059
how to add to_invoice field on timesheet view on odoo 9
invoice timesheet
Avatar
0
Dec 17
2677
Invoice days based on the Timesheet
invoice timesheet
Avatar
Avatar
Avatar
Avatar
Avatar
4
Apr 16
8108
Create invoices based on timesheets
invoice timesheet
Avatar
0
Feb 16
4881