Use this screen to maintain unit prices for items. Unit prices are identified by item for the designated project and Contract Line Item Number (CLIN). The system uses unit prices and price increments to compute unit-based billings and revenue for projects with unit-based revenue formulas. You can also enter this information for a given date or unit range. The information entered in this screen is stored in the CLIN_PRICE_SCH table.
To enter pricing information for a given project, CLIN, item, and revision, use Find or Query to select a valid record. You must have already entered the project, CLIN, item, and revision combination in the CLIN Information screen (Projects » Project Setup » Unit Pricing) and its Link to Items subtask.
Initialize this screen after entering CLIN information and linking it to items, and before generating automatic invoices.
This non-editable field displays the selected project for which you want to enter unit pricing information. The description of the project displays to the right of the field.
This non-editable field displays the currency code linked with the project, CLIN, and item number in the CLIN Information screen (Projects » Project Setup » Unit Pricing).
This non-editable field displays the CLIN number of the selected project. The non-editable, unlabeled field to the right displays the description of the CLIN.
This non-editable field displays the country code linked to this project and CLIN. If the currency code matches your company's functional currency, this field is not required.
This non-editable field displays the item of the selected project.
This non-editable field displays the revision of the selected item.
This non-editable field displays the item type of the selected project. The non-editable field below and to the left displays the item description of the selected project.
This non-editable field displays the selling unit of measure of the selected item.
This table stores unit prices by unit number and date range. Invoices generated automatically will reflect the unit price based on unit usage date or unit number billed depending on the values entered here. There must be no gaps in the unit quantities or date ranges. Therefore, consecutive quantities from .0001 to 9,999,999,999.9999 must exist in this table for each date range.
Enter the first item for which the unit price is valid. For each new date range, the From Qty must begin with .0001. Pressing the Tab key will default in this value.
Enter the last item for which the unit price is valid. Consecutive quantities from .0001 to 9,999,999,999.9999 must exist for a given date range before you can enter a new date range. Pressing the Tab key will default in this value.
Enter the price per unit that should be charged for the given units. This price is in the currency displayed in the header of this screen. You can enter up to four numbers to the right of the decimal point.
Enter the starting date on which this unit price should be charged. This is a required field.
Enter the ending date on which this unit price should be charged. If the consecutive quantities for a given date range do not extend from .0001 to 9,999,999,999.9999, you must enter additional lines for the date range until it has met this validation. This is a required field.
Click this button to bring up the Cost Information subtask.
Click this button to bring up the Warranty Costs subtask.
Click this button to bring up the Defaults subtask.
The following validations occur in the table window:
The unit price must be greater than 0.00.
Consecutive quantities from .0001 to 9,999,999,999.9999 must exist for each date range. If a unit price is in effect for a given number of units, you must add additional lines to expand the number of units to these parameters. For example, if a particular unit price is in effect for the first 100 units, the From and To quantities entered on the first line of the table window should be ".0001" to "100.0000." Add a second line to the table reflecting the price increase for all units after number 100.0000. The From Qty on this line should be number "100.0001," and the To Qty should be 9,999,999,999.9999. There must be no gaps in the unit number.
There must be no overlap in the date range. If the .0001 to 9,999,999,999.9999 unit quantity validation has been met, the Starting Date of the following line must be later than the Ending Date of the previous line.
There must be no gap in the date range. If the To Qty does not equal 9,999,999,999.9999, the start date and end date of the next line must equal the start date and end date of the previous line. If the To Qty does equal 9,999,999,999.9999, and there is an additional line, the start date of the next line must be one day later than the end date of the previous line.
This screen updates the following tables:
CLIN_PRICE_SCH
PROJ_CLIN_PROD
CLIN_WARR_CST_SCH
PROJ_CLIN_PROD