Project Billing Preparation: Billing Limits

The following sections explain how you can set up billing limits for pro forma invoices.

Configuring Billing Limits

On the Projects Preferences (PM101000) form, you select the way the system controls [1]janice.paganiniSorry if this is a dumb question, but are there actually multiple billing limits, as we are saying here and in the bullets, or is there one billing limit that is applicable? If there's one, we should be saying "If the billing limit is exceeded" in the bullets.2025/02/1518:16:37-05:00the billing limits in the Validate T&M Revenue Budget Limits box. The following options are available:

  • Ignore: If the billing limits are exceeded, the system will[2]janice.paganini will2025/02/1518:08:42-05:00 shows a warning message for the pro forma invoice on the Pro Forma Invoices (PM307000) form, but the pro forma invoice can still be removed from hold and released.
  • Validate (default): If the billing limits are exceeded, the system shows an error message and blocks the processing until the pro forma invoice amount is within [3]janice.paganiniHere we are talking about the limit in the singular form, although previously (list intro and beginning of bullets), we were talking about billing LIMITS.2025/02/1518:20:59-05:00the limit. That is, you will be able to[4]janice.paganiniwill be able to2025/02/1518:21:47-05:00[5]janice.paganiniinsert2025/02/1518:21:47-05:00can save this pro forma invoice only with the On Hold status[6]janice.paganiniinsert2025/02/1518:21:17-05:00. To remove it from hold and release it, you and[7]janice.paganini and2025/02/1518:21:19-05:00 have to adjust it to fit [8]janice.paganiniSame2025/02/1518:23:28-05:00the limit in order to remove this pro forma invoice from hold and release it[9]janice.paganini in order to remove this pro forma invoice from h.. 2025/02/1518:23:17-05:00.

To enable[10]janice.paganinienable2025/02/1518:28:51-05:00[11]janice.paganiniinsert2025/02/1518:28:51-05:00turn on the billing limit control for pro forma invoices of a particular project, you select [12]janice.paganiniinsert2025/02/1518:29:03-05:00the Use T&M Revenue Budget Limits check box on the Summary tab of the Projects (PM301000) form. Then on the Revenue Budget tab, you define [13]janice.paganiniinsert2025/02/1518:29:30-05:00the billing limit amounts for [14]janice.paganiniinsert2025/02/1518:29:37-05:00the revenue budget lines of the project. For each revenue budget line for which you have decided to limit the billed amounts, you select the Limit Amount check box and specify the maximum billing amount in the Maximum Amount column. The system will validate these limit amounts in the pro forma invoices created for the project.

Applying Limits to Pro Forma Invoices

If a time and material line is linked to a progress billing line, the system calculates the maximum amount that is currently available for billing the customer based on the billing limit amount of the corresponding revenue budget line that is related to the selected revenue task. For[15]janice.paganiniFor2025/02/1520:34:55-05:00[16]janice.paganiniinsert2025/02/1520:34:55-05:00If the time and material line[17]janice.paganiniinsert2025/02/1520:35:01-05:00 hass with[18]janice.paganinis with2025/02/1520:35:00-05:00 no revenue task specified, the system calculates the maximum billable amount based on the project task in these[19]janice.paganinithese2025/02/1520:35:10-05:00[20]janice.paganiniinsert2025/02/1520:35:10-05:00this lines[21]janice.paganinis2025/02/1520:35:15-05:00.

On the Time and Material tab of the Pro Forma Invoices form, the system applies the billing limit amounts to the pro forma invoice lines as a running total, starting from the first line in the table. The [22]janice.paganiniAs I mentioned in PM_30_70_00.dita, a period needs to be added after "Max" in this name and in "Max Limit Amount." Would you please submit a CR?2025/02/1520:44:54-05:00Max Available Amount is a running total that the system calculates for each line, starting from the topmost one, that has a nonzero Max Limit Amount by using the following formula[23]janice.paganiniinsert2025/02/1520:50:41-05:00.: [24]janice.paganini: 2025/02/1520:50:38-05:00

[25]janice.paganiniInstead use codeblock tags 2025/02/1520:50:26-05:00

Max Available Amount = Max Limit Amount - (Actual Amount + (Draft Invoice Amount - SUM(Amount to Invoice)) + SUM(Amount to Invoice from Above)). [26]janice.paganini. 2025/02/1520:49:27-05:00[27]AVinsert2025/02/0510:45:39+01:00

[28]janice.paganiniLists must be introduced with complete thoughts. If this does not work, replace it with another complete thought. You could say "The formula contains the following parameters:" instead.2025/02/1520:58:07-05:00

In this formula[29]janice.paganiniinsert2025/02/1520:52:45-05:00, the parameters have the following meanings:

  • Actual Amount: The Actual Amount of the corresponding revenue budget line on the Revenue Budget tab of the Projects (PM301000) form.[30]janice.paganini.2025/02/1521:01:11-05:00
  • Draft Invoice Amount: The Draft Invoice Amount of the corresponding revenue budget line on the Revenue Budget tab of the Projects (PM301000) form.
  • Amount to Invoice: The Amount to Invoice of each line of the pro forma invoice on the Time and Material tab that corresponds to the same revenue budget line
  • Amount to Invoice from Above: The Amount to Invoice of each line of the pro forma invoice on the Time and Material tab that corresponds to the same revenue budget line and is located above the current line on the Time and Material tab

For each line of the pro forma invoice, the system subtracts the Amount to Invoice from the Max Available Amount and uses the reduced amount as the available limit for the next line. Pro forma invoice lines for which the Over-Limit Amount is nonzero exceed the limit.

If no billing limit amount is defined for the revenue budget line of the project—that is, if the Max Limit Amount is [31]janice.paganinisurround2025/02/1521:07:28-05:000—the Max Available Amount of each corresponding pro forma invoice line is [32]janice.paganinisurround2025/02/1521:07:40-05:000.

On the Time and Material tab of the Pro Forma Invoices form, you can rearrange lines in the table by dragging them to the appropriate positions, causing the system to apply the limit amounts to the needed lines of the invoice. You can also add to a pro forma invoice adjustment lines that do not originate from project transactions. Such lines are also included in the limit application and can decrease or increase the limit total.