Manually Changing the Average Cost for an Item Step-by-Step

From any screen in the IN module:
 

1.  Type ACC for the Average Cost Change (ACC) field in the NEXT FUNCTION field. 
2. Type the item number in the first KEYS field. 
3. Type the warehouse identifier in the second KEYS field. 
4. Press ENTER to access the Average Cost Change (ACC) screen. 
5.  Type the new average cost in the NEW AVERAGE COST field. 
    Note: The value in this field must be entered in the format 1234567.1234, i.e, seven digits before the decimal place and four digits after the decimal place. 
6. Choose one of the following two options for providing the NCAS with the information about the account to which an average cost adjustment must be charged: 
    6a. Y Yes. If you enter a Y in the GL INDICATOR field, you must enter a specific accounting distribution to which the average cost adjustment is being charged. The company, account and center is entered in the GL COMPANY, GL ACCOUNT and the GL CENTER/GROUP ACCOUNT fields respectively. 
    6b. N No. If you enter an N in the GL INDICATOR field, you must enter the group account to which the average cost adjustment is being charged. Enter the group account in the GL CENTER/GROUP ACCOUNT field. If you choose this option, the NCAS charges the adjustment to the Inventory Adjustment account indicated by event ID E020 within that group account, with the company and center determined by the location code for your warehouse. 
7. Press ENTER to process the change. The ACC screen appears with information about the same item at other locations, indicating that the average cost change for your location has been accepted. 
    Note: The NCAS generates an adjusting entry to account for the change in the inventory asset value caused by the average cost change. Remember that the item warehouse value adjustment is calculated as follows: 

    Item Warehouse Value Adjustment = (New Cost - Old Cost) Current Item Warehouse Balance 
 
Accounting System Home Page | Information Guide Home Page | OSC Home Page