Invoicing Time Tickets Against Sales Orders

We're a consulting services business and want to use Sage 50 Quantum to track values of contracts we have from our customers, including original values, changes (change orders), invoices, and remaining amounts. It looks like we should be setting up each contract as a Job and then doing Sales Invoices. In Jobs, we can enter the original contract amount as Estimated Revenue, and changes as Change Orders. This shows us the current value of the contract. We typically bill clients based on time entered as Time Tickets. We can enter Time Tickets against a Job, but I don't see the connection/report that will show contract value, invoiced, and remaining amounts. How to do this? If we were to use Sale Orders to represent contracts, I can see how an invoice can "deduct" from the Sales Order if we use the "Apply to Sales Order" option. However, our Sales Orders would typically have a single line for the lump sum amount of the contract, but the invoices need to show detail by Activity Item. We don't break down contracts by Activity Items, but we do invoice that way. Therefore, it doesn't look like we can use the "Apply to Sales Order" option because our invoices need to have different lines than the Sales Orders. If we use the "Apply to Sales" option, I don't see how that amount hits the Job to show contract amount remaining. Any suggestions?

  • Hi Peter -- if you use the job estimated revenue as your contract value and then invoice by pulling in your time tickets then you should be able to use the Job Profitability report to see your estimated revenue (contract value) vs actual revenue (invoice value) and remaining (contract amount remaining).

  • in reply to compbiz

    Thanks for the reply! This might work. I see that we have to select the Job on every line of the invoice, or else the invoiced amounts do not show up as actual revenue in the Job Profitability report. It makes sense why the amounts wouldn't show up under the Job, but since the Time Tickets already have the Job selected, why do we have to select the Job again for the invoice lines when they are coming from those same Time Tickets?

  • in reply to Peter Urban

    If you're applying time tickets from the invoicing screen you shouldn't have to reenter the job ID

  • in reply to compbiz

    Hmmm... That's not what I'm seeing. I have the Time Tickets set as "Against a Job" and the correct Job is selected. The Job is set with the correct value 'For Customer'. When I create a new Sales Invoice, I select the Customer to which the Job belongs and then click 'Apply tickets/expenses'. I choose my tickets by using a date range filter and consolidate by Activity Item. All the correct Activity Items and quantities (hours) appear as invoice lines. However, the 'Job' column at the far right of the invoice lines is blank.

  • in reply to Peter Urban

    Ahhh... I see the reason. It's because I'm consolidating the Time Tickets by Activity Item. If I don't consolidate, the 'Job' column does get populated in the invoice lines. I suppose this is because some Time Tickets from an Activity Item can have different or no Job identified, so consolidating them clears the value. In my case, all my selected Time Tickets have the same Job, so it would be nice if that was recognized as a same value and automatically populated.