(RUS) Wizard for cost value adjustment of inventory transactions or entire on-hand inventory (form) [AX 2012]

Updated: February 4, 2014

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Use this form to adjust the inventory value after financial updates or to adjust the cost value of the entire on-hand inventory.

  1. Click Inventory management > Periodic > Closing and adjustment.

  2. Select a transaction that has a transaction type of Closing accounts.

    NoteNote

    You must select a transaction only if you want to use the On-hand method of cost value adjustment.

  3. Click Adjustment > Wizard.

The following tables provide descriptions for the controls in this form.

Page

Description

Welcome

The introduction to the wizard form.

Method of cost value adjustment

Select a cost value adjustment method from the following options:

  • On-hand – Perform cost value adjustments for on-hand inventory by using the dimensions specified in the Select on-hand inventory form.

  • Transactions – Perform cost value adjustments for inventory transactions by using a query.

Selection result

Review the items or item transactions that are selected for adjustment.

Functions for calculating adjustment amounts

Select a method to use to calculate adjustment amounts, from the following options:

  • Item cost price – After adjustment, the item cost price is equal to the standard price that is specified in the Price field on the Manage costs FastTab in the Released product details form.

  • Fixed cost price – After adjustment, the item cost price is adjusted to that of the unit price.

    NoteNote

    The value of the adjustment, which is the difference between the current and target cost values, is displayed in the Edit now field in the On-hand form, based on the selected adjustment method. You can modify the adjustment value in the Edit now field.

  • Amount – After adjustment, the total cost value is increased or decreased by the specified amount, in proportion to the quantity or cost price of the on-hand inventory.

  • Value – The value to which you want to adjust is allocated to all transactions in accordance with the allocation principle.

  • Percent – The inventory value is adjusted by a percentage value.

  • From ledger account – The balance in the specified ledger account and dimensions on a specific date is used as the adjustment value.

Results of allocation

Update the inventory transaction details, based on the chosen method that is used to calculate adjustment amounts and the adjustment values.

Adjustment to fixed cost price

Enter the fixed cost price for the inventory item. After adjustment, the item cost price is adjusted to that of the unit price.

Adjustment with amount

Enter the increase or decrease in the inventory cost value in accordance with the allocation principle that is selected in the Allocation principle field. After adjustment, the total cost value is increased or decreased by the specified amount, in proportion to the quantity or cost price of the on-hand inventory.

Adjustment to value

Enter the total inventory value after adjustment, in terms of the allocation principle.

Percentage adjustment

Enter the percentage value that is used to adjust the total cost value for the selected item.

Balance from ledger account or dimensions

Specify a ledger account or dimensions to calculate the adjustment amount.

NoteNote

The Results of allocation page is opened only when you select a ledger account with a debit balance.

Posting

Specify how the adjustment transactions or the entire on-hand inventory adjustment is posted.

Finish

Select the Show ledger voucher list check box to view the transactions in the Voucher transactions form after the cost value adjustments are performed.

Button

Description

Inventory

Open a menu with the following option:

  • Dimensions display – Open the Dimensions display form, where you can select the inventory dimensions for the transactions.

< Back

Go to the previous page of the wizard form.

Next >

Go to the next page of the wizard form.

Cancel

Close the form.

Select all

Select all the balance lines that are displayed. The Select check box for each balance line is selected.

Deselect all

Clear the Select check box for all the balance lines that are displayed.

Functions

Open a menu with the following option:

  • Charges code – Open the Charges code form, where you can select a charges code that is applied to the selected adjustment lines.

Field

Description

On-hand

Select this option to adjust the selected on-hand inventories.

Transactions

Select this option to indicate that the inventory transactions are used for cost value adjustment.

Date financial

The transaction date.

Item number

The unique identification code of the item.

Storno

A selected check box indicates that the cost price adjustment posted in the ledger is reversed.

Posted quantity

The quantity of the item that is posted.

Posted value

The financial cost amount of the item that is posted.

Cost amount

The amount of the posted cost price adjustments for the item.

Price

Enter the fixed cost price per unit for the item.

Amount

Enter the increase or decrease in the total price or quantity of the selected item.

Allocation principle

Select an allocation principle from the following options:

  • Value – Adjustment is performed on the posted cost value of the item.

  • Quantity – Adjustment is performed on the quantity of the selected item.

Value

Enter the value for the selected item after the adjustment.

Percent

Enter the percentage that is used to adjust the total cost value of the selected transactions.

Main account

Select the main account for which the balance must be determined to calculate the adjustment amount for the selected transactions.

Balance on the date

Select or modify the date on which the balance is determined for the selected main account.

Balance account

Select this option to indicate that the main account balance is determined.

Balance from ledger account and dimensions

Select this option to indicate that the main account balance is determined by using specific dimensions.

Dimension set

Select a dimension set. For more information, see Financial dimension sets (form).

Select

Select this check box to include a line of the balance amount in the adjustment calculation.

Balance (debit)

The debit balance amount in the main account.

NoteNote

This field is available only when you select the Balance account option on the Balance from ledger account or dimensions page.

Balance (credit)

The credit balance amount in the main account.

NoteNote

This field is available only when you select the Balance account option on the Balance from ledger account or dimensions page.

Amount 
(On the Balance from ledger account or dimensions page)

The main account balance for the dimension line.

Charges code

Select the charges code for the item.

Amount for allocation

The total main account balance amount that is used for adjustment.

Adjustment date

Select the date on which the transaction is posted.

Amount for allocation 
(On the Posting page)

The total amount for allocation.

Storno 
(On the Posting page)

Select this check box to indicate that the cost price adjustment transaction that is posted to the main account is reversed.

Specification

Select how transaction adjustments are posted, from the following options:

  • Total – Post adjustments for all items that have same settings in the posting profile.

  • Item group – Post adjustments for all the items, based on the item group.

  • Item number – Post adjustments for each item.

Note

Enter a note about the adjustment.

Corr. account profit/loss

Select this check box to post the cost price adjustments to the profit or loss accounts that are indicated in the item posting profiles. If you clear this check box, the cost price adjustments are posted to the offset account specified in the Corr. account field. When the adjustment is posted by using this form, Corr. account is defined in the following ways:

  • If the charges code is selected in the Results of allocation grid, and a value is displayed in the Corr. account field, or the Corr. account profit/loss check box is selected, then the cost adjustment amount is posted to the Corr. account that is specified in Charges code form.

  • If the charges code is not specified in the Results of allocation grid, and a value is displayed in the Corr. account field, then the cost adjustment is posted to the specified Corr. account.

  • If the Corr. account profit/loss check box is selected, and the charge is not specified, then the cost adjustment is posted to the profit or loss account that is specified in the Posting form.

Corr. account

Select the offset account to which the cost price adjustment is posted.

NoteNote

You can also specify dimension for the selected offset account.

Show ledger voucher list

Select this check box to view the transactions that are posted in the ledger after you close the wizard.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: