By using this website, you agree to our Terms of Use (click here)
Hoping someone could help with this. I've been trying to build T&M billing or allocation rule that picks up from the revenue budget qty and unit rate instead of dependent on the actual cost transaction. Is this possible? It seems like the only way to bill from revenue budget is with progress billing method. But the issue with progress billing is that it only picks up the pending invoice amt in the invoice. I need it to show the qty and unit rate as well. My example is below..it only works if i pick the account group COS and from PMTran. It doesn't seem to like account group REVENUE.
If you are pushing actual transactions into that account group with your allocation rule this should work.
You would need to have each allocation rule write the debit transactions to your "REVENUE" account. Under allocation settings.
The billing rule should just undo any transactions you have in that account linked to that project.
Just as a general question are you trying to have a fixed price project? So you quote for $10,000 and bill the customer $10,000?
@nsmith I tried doing the allocation first and then just do standard billing rule to pull from unbilled but it doesn't work either. Allocation will only pull in the budget if I use progress billing method as it appears and the problem with progress billing is only pulls the amt but not qty and unit price. So I attempted to do T&M allocation. see below. This doesn't work either. There's not a lot of documentations on allocation and billing allocation nor system validation to guide user through setting them up. It lets me pick whatever account group and it doesn't work with revenue nor budget numbers. In theory they should use T&M pulling from actual qty/cost incurred but they don't want the revenue billing to be based from cost. They want to bill independently based on budget qty and unit price when the task is completed. sounds simple but yet I can't seem to find a solution for this.
@jentran Did you manage to find a solution for it, as you cannot bring the quantity in from the Revenue Budget using a progress claim billing rule.
Using real cost transactions is the only driver for Allocation rule, so it will take the budget for the cost group not the Revenue group so that doesn't work for sure, and if that cost budget has no transaction but is in the revenue budget, it also wont be included. When they just want to invoice the revenue budget as is, it seems odd not to have anything here to do this easily. I am thinking we might need a customization to bring in the quantity for progress billing types.
@myobadvanced I decided to do standard billing to pick up from budget. set allocation rule and auto budget method to populate the revenue budget so it bills from revenue budget
In the Cost budget tab, there is a Unit Price field. You can create a T&M billing rule to calculate the billing based on Actual Quantity and Unit Price