MAUC Correction by Item (whina1231m000)

Use this session to correct moving-average unit cost (MAUC) values for individual items.

You can correct the MAUC values by:

You can replace the incorrect MAUC value with the standard valuation price or the most recent purchase price, and update the MAUC value only if the difference between the existing MAUC value and the newly calculated MAUC value has exceeded the percentage that you can specify in this session.

MAUC values can become incorrect for, for example, the following reasons:

  • Incorrect prices entered on purchase orders.
  • Receipt of return orders without original order attached.
  • Items that are fast-moving become slow-moving. This causes the inventory value to differ too much from the actual market value.

Field Information

MAUC Correction by
MAUC Correction by

Specify whether moving-average unit cost (MAUC) correction must be performed for an item/warehouse or an item/ warehouse valuation group combination:

  • Warehouse

    The MAUC is corrected for the selected item present in the selected warehouse.

  • Warehouse Valuation Group

    The MAUC is corrected for the selected item present in the warehouses that belong to the selected warehouse valuation group.

Selection
Item

The item for which you want to correct the moving-average unit cost (MAUC).

Enterprise Unit

The enterprise unit of the item for which you want to correct the MAUC. You can select one of the enterprise units present for the selected warehouse valuation group.

The warehouses of the selected warehouse valuation group can belong to different enterprise units.

For example, warehouse valuation group X includes warehouses A, B, and C. Warehouse A belongs to enterprise unit EU1, warehouses B and C belong to enterprise unit EU2. If you select EU2, the MAUC is corrected for the items stored in warehouses B and C, which belong to EU2.

This field is unavailable if:

  • MAUC correction is by Warehouse.
  • In the Items (tcibd0501m000) session, the Standard Costs at Level field is not set to Enterprise Unit.
  • No item is specified in the Item field in the current session.
Project

The project of the item for which you want to correct the MAUC.

Warehouse

The warehouse related to the selected item for which you want to correct the moving-average unit cost (MAUC).

Warehouse Valuation Group

The warehouse valuation group related to the selected item for which you want to correct the moving-average unit cost (MAUC).

Options
Only Warehouses with Valuation by Warehouse Valuation Group

If this check box is selected, the MAUC is only created for warehouses which have the Valuation by Warehouse Valuation Group check box selected in the Item Data by Warehouse (whwmd2510m000) session.

Only Item/Warehouse-combinations with valuation method MAUC

If this check box is selected, the MAUC is only created for item/warehouse combinations for which the Moving Average Unit Cost (MAUC) valuation method is defined in the Item Data by Warehouse (whwmd2510m000) session.

Include Service Reject Warehouses

If this check box is selected, the MAUC is also calculated for items related to service reject warehouses that are within the specified item/warehouse range.

Print
Success Report

If this check box is selected, the newly calculated MAUC values are printed.

The report displays the following data:

  • Item
  • Warehouse
  • Revaluation order
  • Inventory
  • Current MAUC, both per unit and total value per item/warehouse.
  • New MAUC, both per unit and total value per item/warehouse.
  • Percentage expressing the difference between the current and the new MAUC value.
Note: If the Cost Details check box is selected, the current MAUC, the new MAUC, and the difference percentage per cost component are also printed.

If this check box is selected, a report is printed that displays the current MAUC, the new MAUC, and the difference percentage per cost component.

Error Report

If this check box is selected, an error report on the MAUC correction process for the selected items is printed.

Settings
Reason

The code that indicates the reason for the correction.

Currency

The currency that is printed on the report if you select the Success Report check box. For warehouses, the local currency of the selected warehouse is taken as the default value for this field. For warehouse valuation groups, the reference currency is selected by default.

MAUC
Current MAUC

The current MAUC value for the selected item and warehouse. For item/warehouse valuation group combinations, the current MAUC is not displayed.

Current MAUH

The current MAUH value for the selected item and warehouse. For item/warehouse valuation group combinations, the current MAUH is not displayed.

The Moving Average Unit Hours (MAUH) is based on the actual production hours of an item. Similar to MAUC, the MAUH is the average hours value for each unit of the current inventory and is calculated based on the same formula.

New MAUC

The new, corrected MAUC value for the selected item/warehouse or warehouse valuation group. This value must be equal to the sum of the MAUC values entered for the cost components of the item in the MAUC Correction Cost Details (whina1131m000) session. If this value is not equal to the sum of the cost component values and you click Process, an error message is displayed.

New MAUH

The new, corrected MAUH value for the selected item/warehouse or warehouse valuation group. This value must be equal to the sum of the MAUH values entered for the cost components of the item in the MAUC Correction Cost Details (whina1131m000) session. If this value is not equal to the sum of the cost component values and you click Process, an error message is displayed.

Cost Details

Access the MAUC Correction Cost Details (whina1131m000) session to view and maintain the MAUC by cost component.

Related topics