Use this screen to post milestone/percent complete bills. These are the bills residing in the Enter Milestone/Percent Complete Bills screen (Projects\Transactions\Billing). Note that only those bills with a status of "Selected" will be posted. "Selected" means the bill has been accepted for posting. After the posting process, these bills will still be retained in the Enter Milestone/Percent Complete Bills screen but will be used only for completing future milestone bills. Any bills with a status of "Unselected" will be retained in that screen. Posted and unposted bills can be differentiated by the presence of a company-wide invoice number that appears only on unposted records. In addition, the Current Amount Due field will be zero on posted bills.
Use this screen after you have entered and selected milestone percent complete bills for posting. You must print the bill and the milestone percent complete journal before you can post these bills.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to select the accounting period in which you want to post invoices. You can limit the invoices selected for posting by project, customer, invoice number, and bill user group.
Accounting Period
This non-editable field displays the option "One" because you can post to only one period at a time.
All invoices that have the fiscal year, period, and subperiod in the Enter Milestone/Percent Complete Bills screen (Projects\Transactions\Billing) up to and including the one entered in this field will be selected.
Enter, or use Lookup to select, the fiscal year to which the bills will be posted. The fiscal year selected must be open.
Period *
Enter, or use Lookup to select, the period to which the bills will be posted. The period selected must be open.
Subpd *
Enter, or use Lookup to select, the subperiod to which the bills will be posted. The subperiod selected must be open.
Projects *
Use this drop-down box to select the projects that you want to include in the process. The following options are available:
All - Select this option to include all available projects. The Start and End fields are disabled for this option.
One - Select this option to include only one project. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of projects. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the projects from the beginning of the available projects to a specific project in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the projects from a specific project to the end of all the available projects. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting project number for the range to post. If you select "One," "Range," or "To End," in the Projects Option field, you must enter a project number in this field. If you select "All" or "From Beginning" in the Projects Option field, this field will be inactive.
Enter, or use Lookup to select, an ending project number for the range to post. If you select "All," "Range," or "From Beginning" in the Projects Option field, you must enter a project number in this field. If you select "One" or "To End" in the Projects Option field, this field will be inactive.
Customers *
Use this drop-down box to select the customers that you want to include in the process. The following options are available:
All - Select this option to include all available customers. The Start and End fields are disabled for this option.
One - Select this option to include only one customer. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of customers. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the customers from the beginning of the available customers to a specific customer in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the customers from a specific customer to the end of all the available customers. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting customer number for the range to post. If you select "One," "Range," or "To End," in the Customers Option field, you must enter a customer number in this field. If you select "All" or "From Beginning" in the Customers Option field, this field will be inactive.
Enter, or use Lookup to select, an ending customer number for the range to post. If you select "All," "Range," or "From Beginning" in the Customers Option field, you must enter a customer number in this field. If you select "One" or "To End" in the Customers Option field, this field will be inactive.
Invoice Numbers *
Use this drop-down box to select the invoice numbers that you want to include in the process. The following options are available:
All - Select this option to include all available invoice numbers. The Start and End fields are disabled for this option.
One - Select this option to include only one invoice number. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of invoice numbers. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the invoice numbers from the beginning of the available invoice numbers to a specific invoice number in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the invoice numbers from a specific invoice number to the end of all the available invoice number. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting invoice number for the range to post. If you select "One," "Range," or "To End," in the Invoice Numbers Option field, you must enter a invoice number in this field. If you select "All" or "From Beginning" in the Invoice Numbers Option field, this field will be inactive.
Enter, or use Lookup to select, an ending invoice number for the range to post. If you select "All," "Range," or "From Beginning" in the Invoice Numbers Option field, you must enter a invoice number in this field. If you select "One" or "To End" in the Invoice Numbers Option field, this field will be inactive.
Bill User Groups *
Use this drop-down box to select the bill user groups that you want to include in the process. The following options are available:
All - Select this option to include all available bill user groups. The Start and End fields are disabled for this option.
One - Select this option to include only one bill user group. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of bill user groups. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the bill user groups from the beginning of the available bill user groups to a specific bill user group in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the bill user groups from a specific bill user group to the end of all the available bill user groups. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting bill user group for the range to post. If you select "One," "Range," or "To End," in the Bill User Groups Option field, you must enter a bill user group number in this field. If you select "All" or "From Beginning" in the Bill User Groups Option field, this field will be inactive.
Enter, or use Lookup to select, an ending bill user group for the range to post. If you select "All," "Range," or "From Beginning" in the Bill User Groups Option field, you must enter a bill user group in this field. If you select "One" or "To End" in the Bill User Groups Option field, this field will be inactive.
Use the field in this block to select the field on which you want to sort the Milestone/Percent Complete Journal.
1st Sort *
Use this drop-down box to select the order in which you want to sort the Milestone/Percent Complete Journal. The available options are: "Project," "Customer," "Invoice Number," and "Bill User Group."
* A red asterisk denotes a required field.
Changes to this screen update the following tables:
AR_DETL_HS (Accounts Receivable Detail History)
AR_HDR_HS (Accounts Receivable Header History)
FS_SUM ( Financial Statement summary)
GL_DETL (General Ledger Detail)
GL_POST_SUM (General Ledger Posting Summary)
MILESTONE_HDR_HS (Milestone Header History)
MILESTONE_LN_HS (Milestone Line History)
MILESTONE_INVC_HDR (Milestone Invoice Header)
MILESTONE_INVC_LN (Milestone Invoice Line)
PROJ_BILL_HS (Project Billing History)
REF_SUM (optional) (Reference Summary)