Method Community

I'm not sure that the Accum B-Qty is being calculated correctly and here is an example to show why:

Create an item that is an hourly charge.

Create a time tracking entry for say 8 hrs.

Create an invoice for the 8 hours.

Add another time tracking entry for 4hrs.

Try to create an invoice.

Since the 4 hours to be invoiced is less than the 8 hours already invoiced, the app thinks that an invoice should not be created.

In the Recaulculate button actions (On the bidget/Contract screen) the script to calculate the Accum B-Qty filters time tracking entries to only include those with billable status of Billable instead of including HasBeenBilled as well, and I believe this is the source of the issue.

Hi Matt,

Hourly items are based on Billable AND Approved. The part you may be missing is the approved. If that does not help, try running a sync as we may rely on QB to get the updated Qty to be invoiced (it is calcualted there and sent back to us...I think).

Matt:

In the Recaulculate button actions (On the bidget/Contract screen) the script to calculate the Accum B-Qty filters time tracking entries to only include those with billable status of Billable instead of including HasBeenBilled as well, and I believe this is the source of the issue.

I don't quite agree with this. If something has already been invoiced why would you want it to be available to invoice again? This was done by design and I believe QB does something similar on it's end.

Please let me know if this helps.

Method_Valbon:

Hourly items are based on Billable AND Approved. The part you may be missing is the approved.

In the example, I was saving and approving the time tracking entries, I should have mentioned that. So, this is not the issue.

Method_Valbon:

If that does not help, try running a sync as we may rely on QB to get the updated Qty to be invoiced (it is calcualted there and sent back to us...I think).

I created and approved a time tracking entry for 8 hours, synced and then invoiced and synced again. I then looked at the "Ordered" quantity in Quickbooks and it showed 8 for the line. I then click the recalculate button, which changed the Accum B-Qty to 0 on the Budgets / Contract screen. It also changed the ordered quantity to 0. I'm not 100% sure, but it appears as though the Accum B-Qty value is being sent over to QB as the Ordered Qty.

Method_Valbon:

I don't quite agree with this. If something has already been invoiced why would you want it to be available to invoice again? This was done by design and I believe QB does something similar on it's end.

I agree that you don't want to invoice them again, but if my assumption above is correct, that the Accum B-Qty is being sent as the Ordered Qty you would want the Accum B-Qty to include the time that has already been invoiced because QB subtracts the Invoiced qty from the Ordered Qty to arrive at the remaining to be invoiced Qty.

Pro Services seems to do this as well. If 8 hours have already been invoiced and 6 more hours are added and approved in the time tracking, nothing will show up when you click the create invoice button.

Val,

Have you had a chance to look into this any further?