Hi @all
I am using the Unbilled Time report to see the estimated revenue of a project. I am using charge Based billing method for my projects. In that, I am using Time-based Rule for generating a charge. In this rule, we can define the rates in three methods,
1) Billing class-Billing rate card
2) Resources - Raet per employees
3) Service item rates
So In this report, I cannot access the Charge record data or any charge rules defined. The report only shows the amount column value by fetching the rate defined in the Service items and not from the per hour rate defined using Billing rate card or Resources rate from the time-based rule. This is my issue. I would like this amount column to reflect the amount column value based on the rate defined in the billing rate card or from the resource rate defined in the time-based rule. Is this possible to achieve in this report? I have also gone through the "project billing report" but I cannot bring the time transaction for the hours logged by the employee in that report.
This is the report I need, A WIP report(unbilled time report) with columns:-Time tracked, Employee, Subsidiary of the employee, Total expected revenue, rate of employe(from billing rate card or resource rate).
I have used charge saved search to build this report it works for me but this report will be accurate only when the charge record is created on a nightly basis so real-time visibility of data not achieved by this. I can force run the "Generate charge option" but I have a lot of projects so manually doing it is not a feasible solution for me.
I have one more question. Is it possible to trigger the "Generate charge option" via script (without a manual button click) so I don't need to wait for night to autorun this charge generation mechanism?
Thanks.