Update Open Billing Detail Records

With this utility, you can update your Open Billing Detail file from either your General Ledger Detail file or your Units Usage History file.

Normally, when establishing a project on the Basic Info tab of the Manage Project User Flow, you select the Billable Project check box (the default is selected) to enable the Manage Project Billing Information screen to be initialized. To compute billings, a transaction-based formula must exist on the Manage Project Billing Information screen. When you complete the Manage Project Billing Information screen, transactions, when posted, populate the Open Billing Detail file and subsequently can be included on a bill. However, if you do not initialize the Manage Project Billing Information screen with a transaction-based formula before posting transactions, Open Billing Detail is not updated, and transactions cannot appear on the bills. Use this utility to update your Open Billing Detail file for transactions that you posted before initializing the Manage Project Billing Information screen.

Before using this utility, initialize the Manage Project Billing Information screen for all projects that to be updated. Take care not to select transactions that have been billed manually. (Initialize these amounts on the Manage Billing History screen instead.) Therefore, it is important to know which transactions have been billed and which have not.

If you are posting labor at the summary level (if you selected the Post Labor Distribution to GL as Summary Entry check box on the Configure General Ledger Settings screen), your general ledger does not store the detailed information required to run this utility for timesheet data. In that case, you must enter labor information manually on the Manage Open Billing Detail screen.

You should exercise caution when using this utility. This utility does not check for transactions that have already been billed or for transactions that already exist in the Open Billing Detail file.  If you inadvertently run this utility for a project in error, the recovery from this error can be time consuming.