Edit Standard Cost Revaluation

Unified Glossary

This page allows you to modify or delete a standard cost revaluation transaction. Tell me more

The “Edit Standard Cost Revaluation” page appears.

The system displays the following:

Status

The status of the standard cost revaluation transaction. All transactions except those in “Authorized” and “Deleted” status can be modified.

Transaction No.

A unique number identifying the standard cost revaluation transaction.

Transaction Date

The date on which the standard cost revaluation transaction took place (Date Format). Mandatory. Ensure that this date is not greater than the current system date and the last closed financial period. The system sets this date to the current system date by default.

Ref. Doc. No.

The number identifying the reference document based on which the transaction is recorded. (Alphanumeric, 18).

Ref. Doc. Source Point

The location or organizational unit from where the reference document has been raised (Alphanumeric, 16).

Usage For A/C Code

Use the drop-down list box to select the account code to be credited for the value of the item corrected through the standard cost revaluation transaction. All the account codes defined for the standard cost revaluation transaction type in the “Account Rule Definition” component will be displayed here. The system also displays “Blank” as one of the values and sets this field with the value as defined in the created transaction by default.

Note: If the account code is not mapped to any cost center, then the usage for usage cost center must be blank. If the account code is mapped to even one of the cost centers, the usage for cost center must be retrieved from the “Cost Center Rule Definition” component.

Usage For CC

Use the drop-down list box to select the cost center for the standard cost revaluation transaction. All the cost centers defined for the standard cost revaluation transaction type in the “Cost Center Rule Definition” component will be displayed here. The system also displays “Blank” as one of the values and sets this field with the value as defined in the created transaction by default.

The system displays the following in the “Reason For Return” group box:

Reason Code

The code identifying the reason for returning   the standard cost revaluation transaction.

Item Code

The unique code identifying the item (Alphanumeric, 32). Mandatory.

Help facility available.

Note: If the item is of non-stockable type such as capital, model, kit, service or reference item or if the item type is not allowed in the specified warehouse, then the standard cost revaluation transaction cannot be generated. For sundry item types, the item/variant must be stockable. Else, the system displays an error message.

Variant Code

Variant code of the item (Alphanumeric, 8). Ensure that the variant code is entered if the item is variant enabled.

Help facility available.

The system displays the following in the “Item Information” multiline:

Item Variant Desc.

A textual description of the item variant.

 

Zoom facility available

Current Std. Cost

The standard cost of the item as defined in the “Maintain Item – Basic Information” activity of the “Item Administration” component.

New Std. Cost

The new standard cost of the item (Integer). Mandatory. Ensure that the value entered in this field is greater than zero. This value must not be equal to the current standard cost.

The system displays the following in the “Item Information” multiline:

Stock UOM

The unit of measurement in which the item is stocked in the warehouse.

Current Stock Qty.

The total quantity of stock available across all the warehouses in an OU. The system retrieves the total quantity of stock available in all the non-capital warehouses for the login OU. The system retrieves the stock details only for those items for which the “Valuated” parameter is set.

Current Stock Value

The value of the stock, calculated as the product of current stock quantity and current standard cost.

Note: If the costing method of the items is other than standard cost, then the system retrieves the value of the stock from the “Stock Maintenance” component for the item variant in the login OU and displays it in the current stock value field.

New Stock Value

The revised value of the stock, calculated as the product of current stock quantity and new standard cost. If the costing method is other than standard cost, then new stock value will be the same as the current stock value.

Diff. In Value

The difference in value, calculated as the difference between new stock value and current stock value. If the difference in value is obtained as negative after calculation, the system displays the value preceded by a minus or negative sign.

Note: If the difference in value is positive, then the transaction type will be positive std. cost revaluation (SCR). If the difference in value is negative, then the transaction type will be negative (SCR).

Usage For A/C Code

Use the drop-down list box to select the account code to be credited for the value of the item corrected through the standard cost revaluation transaction. All the account codes defined for the standard cost revaluation transaction type in the “Account Rule Definition” component will be displayed here. The system displays the value as chosen in the header in all the rows of the multiline by default.

Usage For CC

Use the drop-down list box to select the cost center for the standard cost revaluation transaction. All the cost centers defined for the standard cost revaluation transaction type in the “Cost Center Rule Definition” component will be displayed here. The system displays the value as chosen in the header in all the rows of the multiline by default.

The system displays the message “Transaction updated successfully”. The system sets the status of the transaction as “Active” on successful submit of all modified details, if the status is “Returned” on launch of the page.

The system sets the status of the transaction as “Draft” if analysis/sub analysis code is defined for atleast one of the account codes. Else, the system sets the status of the transaction as “Active”.

The system sets the status of the transaction as “Active” in the following cases:

The system parameter “Analysis/Sub analysis Code applicable” is set as “No”. If the parameter is set as “Yes”, then account codes must have been mapped to the analysis/ sub analysis codes. The costing method of all the items is non-standard cost.

If the costing method of atleast one of the items is standard cost, then the system performs the following:

The system retrieves the item account group from the “Item Administration” component. The system retrieves the account codes from the “Account Rule Definition” component if the item has item account group defined. Else the item code is to be retrieved. If the system parameter “Std. Cost Revaluation based on Revaluation Account” is set as “Yes”, the system retrieves the revaluation account from the “Account Rule Definition” (ARD) component. Else, the system retrieves the stock adjustment account from the ARD.

The system checks whether the account code s mapped to any of the cost centers. If so, the cost center code is retrieves and the system updates the “Cost Center Rule Definition” component.

The system sets the transaction as “Authorized”. The system saves the loin id of the user and the date of creation along with the modification details. If the standard cost revaluation is positive, the system debits the stock account and credits the revaluation account or adjustment account depending on whether the “Std. cost revaluation based on revaluation account” is set as “Yes” or “No”. If the standard cost revaluation is negative, the system credits the stock account and debits the revaluation account or adjustment account depending on whether the “Std. cost revaluation based on revaluation account” is set as “Yes” or “No”.

The system checks whether the system parameter "Prevent Transactions during Period Closing" is set as “Yes”. If so, transactions must be recorded for the closed financial period. Else, the system displays an error message.

The system adjusts the new stock value in the finance book to which the warehouse is associated. If more than one warehouse is associated with the finance book, then the system calculates the sum of all stock values for the warehouses and adjusts the cumulative value in the finance book.

The system updates the new standard cost of the item variant in the “Item Administration” component with which the “Stock Adjustment” component is interacting. The system saves the login id of the user and the current system date in the last modified by and last modified date fields in the corresponding pages.

The system sets the status of the transaction as ”Deleted”.

The system deletes the details of the selected transaction and saves the login id of the user and the date of creation along with the modification details.

The system displays the following:

Created By

The login id  of the person who created the standard cost revaluation transaction.

Created Date

The date on which the standard cost revaluation transaction was created.

Last Modified By

The login id of the person who last modified the standard cost revaluation transaction .

Last Modified Date

The date on which the standard cost revaluation transaction was last modified.

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Edit Standard Cost Revaluation – An Overview

Activity overview

Stock adjustment is performed when there is a discrepancy between the system stock and actual physical stock and the reason for the discrepancy cannot be ascertained. This page allows you to modify the standard cost created using the “Create & Authorize Std. Cost Revaluation” page for items with std. cost valuation method. However, this page is applicable for all items irrespective of costing methods but for standard cost items, the stock value will be adjusted to the new stock value after revaluation and necessary financial postings will be performed.

You can modify only those standard cost revaluation transactions that are not in “Authorized” or “Deleted” status. You can modify the new standard cost for the item. This value will be applicable throughout the OU. The system calculates the new stock value as the product of new standard cost and quantity. You can also modify the account code and cost center to be credited for the standard cost revaluation transaction.

Standard cost revaluation transaction can be created and authorized based on the permissions granted to the user. The user must have the requisite “Authorize” permissions to authorize the std. cost revaluation transaction.