Perform Rollup

This page allows you to perform rollup. Every rollup is identified by an ID, which is the Request ID. Tell me more

Select the “Perform Rollup” activity under the “Cost Rollup” business component.

The “Perform Rollup” page appears.

The system displays the following:

Status

The status of the request ID It could be “Exploded with Errors”, “Exploded’ “Routing with Errors”, “Routing complete”, “Rolled-up with errors”, “Rolled up” and blank.

Enter the following fields:

Request ID

A unique number identifying the request of the rollup (Alphanumeric, 18). The Request ID entered must not be in “Deleted” or “Partially Updated” or “Updated” or “Scheduled” or “Rolled up” status.

Note: The “Request ID” entered can be an existing request id in which case the request ID will not be auto generated. The request ID field must not be empty.

Enter the following fields

Valid From Date

The date from which the rollup is valid from (Date Format). Mandatory. The system date is defaulted on launch of the page.

Note: The valid date must be the same or before the system date. The date field must not be empty.

Item OU	Use the drop-down list box and select the item organization unit to perform the rollup. The item organization units must have been defined in the “Item Administration” component and mapped to the login OU in the CIM. The system displays the first OU occurring in the alphabetical order by default on the launch of the page.
Include Scrap Factors	Use the drop-down list box to select the values whether to include the scrap factors. You can select from “Yes” or “No”.
	Yes – indicates that the scrap factors should be included.
	No – indicates that the scrap factors should not be included.
	The system displays “No” by default on the launch of the page.
Cost Type	Use the drop-down list box to select the cost type. The values defined in the “CSET” component will be available for selection. Based on the number of alternate rates defined, the alternate rates will be available for selection along with the Standard Rate. The system displays “Standard Rate” by default on the launch of the page.
Roll Up Option	Use the drop-down list box to select the type of rollup option that you want to execute. You can select from “Single Level” or “Multi Level”. The system displays “Single Level” rollup option by default on the launch of the page.
Process	Use the drop-down list box to select the type of process that you want to execute on the costs. You can select from “Explosion”, “Processing”, “Rollup” and “All”. The system displays “All” by default on the launch of the page.
Consider Item Costs on	Use the drop-down list box to select the type of costs item that you want to consider. You can select from “Costing Method”, “Last Purchase Price” and “Manual Entry”. The system displays “Costing Method” by default on the launch of the page.
Basis	Use the drop-down list box to select the basis on which you want to perform the rollup. You can select from “Maximum”, “Minimum” and “Average”. The system displays “Average” by default on the launch of the page.
Execute Online	Select the check box to perform the rollup online. The system defaults it unchecked on the launch of the page.

The system displays the following

Costing Basis	The value identifying the costing basis on which you want to perform the rollup. The displayed value must have been defined in the “MCOX” component. The value of the costing basis must be the same as the value in the request ID.
Basis for Surcharge	The basis for the surcharge amount. It could be “Flat” or “Percentage”. The displayed value must be the stored value in the “Set Parameters”.

Enter the following details in the “Search Criteria” group box:

Item Group Code	A number identifying the item group (Alphanumeric, 25).
Item Code From	The starting code number in the range of code numbers identifying the item code that you want to retrieve for rollup (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the item codes that are similar to the value entered here.

Note: The number entered in this field must be before the value entered in the “To” field.

The ending code number in the range of code numbers identifying the item code that you want to retrieve for rollup (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the code numbers that are similar to the value entered here.

Note: The number entered in this field must be equal to or greater than the value entered in the “Item Code From field”.

Item Variant Description	A textual description of the item variant (Alphanumeric, 150).
	Zoom Facility Available.
Item Variant From	The starting number in the range of numbers identifying the item variant that you want to retrieve for rollup (Alphanumeric, 18). You can enter the item variant in full or specify it partially using the “*” character. The system retrieves all the item variants that are similar to the value entered here.

Note: The item variant entered in this field must be before the value entered in the “To” field.

To	The ending number in the range of numbers identifying the item variant that you want to retrieve for rollup (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the numbers that are similar to the value entered here.

Note: The item variant entered in this field must be equal to or greater or after the value entered in the “Item Variant From field”.

Click the “Search” push button to retrieve the search results based on the values entered.
Enter the following fields in the “Search Criteria” group box:

Item Code

A unique number identifying the item for which you want to perform the rollup (Alphanumeric, 18). Mandatory. The item code must have been defined in the “Item Administration” component.

Note: If the item variant is specified, the item code must also be specified. The item code and variant combination should be a valid combination.

Item Variant Code

A unique number identifying the item variant for which you want to perform the rollup (Alphanumeric, 18). Mandatory. The item variant must have been defined in the “Item Administration” component.

Note: The item code and variant combination should be a valid combination. The item variant field must not be empty.

The system displays the following:

Surcharge	A number identifying the surcharge amount charged on the item.
Item Variant Description	A textual description of the item variant.

Click the “Get Items Where Used” push button to get the all the finished products that is using the given item as input.

The system checks if the request ID exists. The system also checks the status of the request ID if it is in the “Exploded With Errors” status.

Click the “Perform Rollup” push button to perform the rollup of the costs.

The system saves all the details and performs the rollup of the costs.

To proceed, carry out the following

Select the “Item Cost Entry” link at the bottom of the page if you want to fetch the standard costs of purchased / subcontracted items.
Select the “View Exceptions” link at the bottom of the page to view the exceptions, if any, occurring during the rollup process.
Select the “View Costs on Rollup” link at the bottom of the page to view the costs after rollup.
Select the “Additional Cost Burden” link at the bottom of the page to create the cost burden for selected cost elements.
Select the “Attach Notes” to attach any notes regarding the rollup.
Select the “Collaborate” link at the bottom of the page to record or to view the observations or comments or discussions regarding the document.

Perform Rollup – An overview

The request ID is automatically generated through the Numbering Class component, the request ID gets generated on invoking the task ‘Perform Rollup’. You can enter mandatory fields and also conduct a search to retrieve item for which you want to perform a rollup. You can select to execute the rollup online. The request is stored in the backend and it is later taken up in a batch process and scheduled whenever required. You can select the item org unit from which items are to be selected, you can include the scrap factors, select the cost type, the rollup option, the type of process on the costs, the items costs considered on, the type of basis to perform the rollup and the source for purchased and sub-contracted items. You can enter the item code and the item variant directly in the ML. This page also allows you to get the items wherever they are used. You can perform the rollup based on the selections made. The system conducts the rollup based on all the values selected and retrieved.