REVERSE PREVIOUS BILLINGS

Use this screen to reverse, or void, standard bills that have already been posted. You can also rebill the same transactions from the original invoice along with any new transactions that have been posted to Open Billing Detail. Note that this utility reverses or voids standard bills only; manually entered bills such as project product bills, customer product bills, milestone percent complete bills, or manual bills are not eligible. In addition, you cannot use this utility to reverse or void progress payment bills.

Use this screen whenever you need to create reversing bills for bills that have already been posted.

Select Rebill Option

Use the check box to reverse a bill. If you do not select this check box, the bill will be voided and the transactions cannot be billed again. If you select this check box, you can make adjustments to the bill and rebill.

Rebill these transactions

Select this check box to rebill the transactions from the original bill. This means that the transactions from the original bill, including units, will be inserted back into Open Billing Detail when the reverse bill is posted. Any new transactions that have been posted to Open Billing Detail, in addition to the original transactions, can be included on the rebill.

If a WAWF project invoice is reversed with the Rebill these transactions check box cleared, the invoice is voided. You cannot submit WAWF files if the total invoice amount is less than zero. There is no need to redistribute any over ceiling or retainage amounts for this type of invoice.

If a WAWF project invoice is reversed with the Rebill these transactions check box selected, the invoice is reversed. Again, you cannot submit WAWF files if the total invoice amount is less than zero, so there is no need to redistribute any over ceiling or retainage amounts. Because the Rebill these transactions check box is selected, the invoice transactions are updated in Open Billing Detail when the reverse invoice is posted via the Post Standard Bills screen (Projects » Billing » Post Billings). You must use the Calculate Billings screen (Projects » Billing » Calculate Billings) to create the invoice again, at which time the WAWF_XXX fields are updated with any over ceiling and retainage amounts. You may need to modify the WAWF file in order to submit an accurate net invoice amount. For example:

You post a standard invoice in the amount of $1,500.00.
You create a WAWF file and submit it to the paying office.
The paying office disburses you a check/EFT in the amount of $1,500.00.
You determine there were costs on the invoice that should not have been invoiced and reverse the bill with the Rebill these transactions check box selected. This creates a -$1,500.00 receivable amount that cannot be transferred to the paying office because the total invoice amount is less than 0.00.
You place the transactions that should not have been billed on Hold and recalculate the invoice in the following period. This results in an invoice amount of $2,900.00 (new billable transactions exist in the following period).
You create a WAWF file.
You edit the WAWF file to net the total invoice amount to $1,400.00. The $1,400.00 represents the current invoice amount of $2,900.00 (includes transactions previously invoiced) minus the previously paid invoice of $1,500.00.

Select Invoice ID

Enter, or use to select, a valid invoice ID. Note that this invoice ID is the company-wide invoice ID and not the project-specific bill number.

When you click the Calculate icon on the toolbar, the system provides a warning if more than one invoice has been found with the entered ID. This occurs if you have a bill that has been shared by multiple customers. All invoices with this invoice ID will be reversed if you continue.

Concurrent processing is not allowed. In other words, one user cannot calculate a reversing bill while another user is calculating a standard bill for the same project. Costpoint can contain only one type of bill (standard or reversing) in the unposted bill files.

This program automatically generates a bill in the Edit Standard Bills screen (Projects » Billing » Edit Billings) that contains the same transactions from the original bill but with inverse amounts. These inverse transactions supporting the reverse bill are not in Open Billing Detail. You cannot edit reversing bills; you can only delete them. In addition, when you calculate reversing bills, the system automatically assigned them a status of Void if they are not being rebilled or Reverse if the rebill option has been selected. You cannot change this status in the Edit Standard Bills or Select Bills for Posting screen (Projects » Billing » Edit Billings). Therefore, you cannot calculate a standard bill for this project until the reversing bill has been posted or deleted.

If you reverse a bill with the rebill option, the transactions are inserted from the original bill back into Open Billing Detail when the reversed bill is posted. You can combine these transactions with additional transactions to produce a revised bill. If you reverse a bill without the rebill option, an inverse bill is generated with no transactions inserted into Open Billing Detail. The sole purpose is to void the original bill.

Reversing bills carry the same invoice ID and bill number as the bill that they are reversing. When transactions that have been reversed are re-billed, the invoice ID and bill number on which they originally appeared are not re-used and should not be re-set.

Assign New Invoice ID

Select this check box to assign a new invoice ID to the reversing invoice. If you do not select this check box, the system will assign the invoice number of the original bill to the reversing bill created by this process.

If you choose to use the original invoice number in the reversing bill, the system will zero out the amounts in the BILL_INVC_HDR_HS table and the related transactional detail in the BILLING_DETL_HIST tables. This may cause a problem with the Create IWO Allocations screen (Projects » Inter-Company Work Orders) because it relies on the BILLING_DETL_HIST table to obtain data for the IWO allocations. The IWO process will incorporate the positive amounts in the calculation but will not have access to the negative amounts because the system will zero out the invoice amounts rather than create negative values in the tables. If you are using the billing history tables for either one of these processes, you should select the Assign New Invoice ID check box.

Calculate

Click this icon on the toolbar to execute the reverse billings process.

Table Information

Changes to this screen update the following tables:

BILL_EDIT_DETL

BILL_EDIT_INVC_HDR

OPEN_BILLING_DETL

REVERSE PREVIOUS BILLINGS

Select Rebill Option

Rebill these transactions

If a WAWF project invoice is reversed with the Rebill these transactions check box cleared, the invoice is voided. You cannot submit WAWF files if the total invoice amount is less than zero. There is no need to redistribute any over ceiling or retainage amounts for this type of invoice.

You post a standard invoice in the amount of $1,500.00.

You create a WAWF file and submit it to the paying office.

The paying office disburses you a check/EFT in the amount of $1,500.00.

You place the transactions that should not have been billed on Hold and recalculate the invoice in the following period. This results in an invoice amount of $2,900.00 (new billable transactions exist in the following period).

You create a WAWF file.

You edit the WAWF file to net the total invoice amount to $1,400.00. The $1,400.00 represents the current invoice amount of $2,900.00 (includes transactions previously invoiced) minus the previously paid invoice of $1,500.00.

Select Invoice ID

Assign New Invoice ID

Calculate

Table Information