Viewing CMAV details for the part

This page enables you to view the cumulative moving average value of the part. The system will compute the CMAV details for the part each time the part count is affected due to stock transactions such as stock issue, stock receipt, stock return, stock status conversion, opening balance and stock correction. The CMAV details will be displayed for the selected part for a period of one year.

The CMAV details will be computed only for the parts in stock status “Accepted”.

Click the hyperlinked “CMAV” value of the part in the “View Material Count and Location Information” page.

The “View CMAV Information” page appears.

The system displays the following:

Date Format

The format in which the date fields are displayed in this page. This format is displayed from the “User Preferences” business component based on the login user ID. In case the format is not defined, the system displays the date format from the “Enterprise Modeling” business component by default.

The system displays the following in the “Part details” group box:

Part #	The number identifying the part, for which the details are displayed.
Part Description	The textual description of the part.
CMAV	The total cumulative moving average value of the part.
Stock UOM	The unit of measurement in which the part is stocked in the inventory.
Part Type	The type of the part. The part could be of type “Raw Material”, “Component”, “Expendable”, “Tool”, “Consumable”, “Kit” or “Miscellaneous”.
Part Control Type	The method by which the part is controlled in the warehouse, which could be “Serial controlled” or “Lot controlled” or “Serial & lot controlled” or “None”.
Part Category	The category of the part.
From Date	The starting date in the range of dates from which the CMAV details are displayed. The system displays the date one year earlier than the current date.
To Date	The ending date in the range of dates till when the CMAV details are displayed. The system displays the current date.

The system displays the following in the “CMAV Details” multiline:

Transaction Date	The date, on which the transaction document that has caused an increase or decrease of the part count in the inventory, attains “Confirmed”, “Authorized” or “Moved” status.
Transaction Type	The type of the stock transaction, which could be opening balance, stock receipt, goods receipt, repair receipt, stock issue, stock return, stock correction or stock status conversion.

If the transaction type is:

Goods receipt or repair receipt, the transaction date will be the date on which the document attains “Moved” status.
Opening balance, the transaction date will be the date on which the opening balance document attains “Authorized” status.
Any one of the stock receipt, stock issue, stock return, stock correction or stock status conversion, the transaction date will be the date on which the respective document attains “Confirmed” status.

Transaction #	The number identifying the transaction document.
Warehouse #	The code identifying the warehouse in which there is an increase or decrease of the part count.
Transaction Quantity	The transaction quantity of the part.
Transaction Value	The value of the transaction quantity.
Opening Balance Qty	The opening balance quantity of the part, before the transaction.
Opening Balance Value	The value of the opening balance quantity.
Opening CMAV	The cumulative moving average value of the opening balance quantity.
Closing Balance Qty	The closing balance quantity of the part, after the transaction.
Closing Balance Value	The value of the closing balance quantity.

Note: The closing balance quantity and the closing balance value will be computed by adding or subtracting the opening balance quantity/value, with the transaction quantity/value, based on the type of transaction that has affected the part count.

Closing CMAV

The cumulative moving average value for the closing balance quantity.

Note: The system retrieves 100 records at a time in the multiline.

Click the "Previous" pushbutton to view the set of records existing prior to the set of records currently displayed in the multiline.
Click the "Next" pushbutton to view the set of records existing next to the set of records currently displayed in the multiline.