Performing rollup

Glossary

Basics of using Ramco Enterprise Series web page

This page allows you to perform a rollup. Every rollup is identified by a session ID which is the Request ID. The request ID is automatically generated through the Numbering Class component.  Tell me more.

The “Perform Rollup” page appears.

Request ID.

A unique number identifying the request of the rollup (Alphanumeric, 18).

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

The system displays the following:

Status

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

Valid From Date

The date from which the rollup is valid from (Date Format). Mandatory.

Note: The valid date must be on or before the system date.

Item Org. Unit

Use the drop-down list box and select the organization unit where the costs are mapped to the login OU in the CIM.

Note: The system by default displays the first one occurring in the alphabetical order.

Include Scrap Factors

Use the drop-down list box to select from 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.

Note: The system by default displays “No” at the launch of the page.

Cost Type

Use the drop-down list box to select cost type. The values available for selection are the values predefined and taken from the “CSET Component”. It must have been mapped to the “CSET Component”.

Note: The system by default displays “Standard Rate” on the launch of the page.

Rollup 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”.

Note: The system by default displays the “Single Level” rollup option 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”.

Note: The system by default displays “All” on the launch of the page.

Consider Costs Item On

Use the drop-down list box to select the type of costs item that you want to consider. You can select from “Standard Cost”, “Last Purchase Price” and “Manual Entry”.

Note: The system by default displays “Last Purchase Price” 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 ”, “Average” and blank.

Note: The system by default displays “Average” on the launch of the page. 

Execute Online

Select the check box to perform the rollup online.

Source For Purchased and Subcontracted Items

Use the drop- down list box to select the source. You can select from “Purchased” and “Sub-contracted”.

Note: The system by default displays “Purchased” on the launch of the page.

Item Group

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.

To

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”.

Select All Items

Use the check-box to select all items to perform a rollup.

Note: The system by default displays the check box as unchecked on the launch of the page.

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 number 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 number 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 number entered in this field must be equal to or greater than the value entered in the “Item Variant From field”.

Desc.

A textual description of the item variant (Alphanumeric, 150).

 

 Ellipsis Facility Available.

The system displays the following in the “Search Results” group box:

Item Code

The code identifying the item.

 

Help Facility Available.

Item Variant

The number identifying the item variant.

Item Variant Desc.

A textual description of the item variant.

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

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Performing rollup – An overview

Activity Overview

If request ID is not entered by the user, 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 also conduct a search by entering in the item group, a range of codes and numbers. It is possible to 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.