Welcome

Introduction to the wizard.

Method of cost value adjustment

Select a method of cost value adjustment from the following options:

• On-hand– Perform value adjustments for on-hand inventory using dimensions selected in the Select on-hand inventoryform.

• Transactions– Perform value adjustments for inventory transactions using the filter criteria set in the InventTransAdjustmentform.

Selection result

Review of items or item transactions selected for adjustment.

Functions for calculating adjustment amounts

Select a method for calculating adjustment amounts from the following options:

• Item cost price– Enter adjustment amount separately for each line in the Results of allocationpage.

• Fixed cost price–Enter the fixed cost price for the inventory unit after the adjustment in the Adjustment to fixed cost pricepage.

• Amount– Enter the increase or decrease in the quantity or cost price of the item in the Adjustment with amountpage.

• Value– Enter the total value of the quantity or cost price of the item after adjustment in the Adjustment to valuepage.

• Percent– Enter the percentage of positive on-hand inventory or total on-hand inventory that should be used when adjusting the total cost price for the selected item.

• From the ledger account– Choose ledger accounts or dimensions for calculating the allocation amount.

Results of allocation

Enter or modify the inventory transaction details based on the chosen method for calculating adjustment amounts, and the corresponding adjustment values.

Adjustment to fixed cost price

Enter the fixed cost price for the inventory item.

Adjustment with amount

Enter the increase or decrease in cost price or quantity in terms of the selected allocation principle.

Adjustment to value

Enter the total value of the cost price or quantity after adjustment, in terms of the allocation principle.

Percentage adjustment

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

Balance from ledger account or dimensions

Select the required balance from the ledger account to calculate the adjustment amount for the inventory item.

Note
You must select a ledger account with a debit balance to proceed to the Results of allocationpage.

Posting

View and set up specifications for posting the adjustments to inventory receipt transactions, as well as on-hand inventory value adjustments.

Finish

Close the wizard.

Inventory

Click Inventoryand open Dimensions displayto display the quantity itemization of the on-hand inventory in terms of the selected inventory dimensions.

< Back

Click to return to the previous wizard page.

Next >

Click to go to the next wizard page.

Cancel

Click to close the wizard.

Print

Click to print the adjustment details.

Finish

Click to launch the compilation process.

Select all

Click to select all the balance lines that are displayed.

Deselect all

Click to deselect all the balance lines that are displayed.

On-hand

The on-hand quantities for the item on the journal line.

Transactions

The related transactions in the inventory.

Item number

The unique identification code of the item.

Configuration

The unique identification code of the item configuration.

Size

The size of the item.

Color

The color of the item.

Site

The site to which the item belongs.

Warehouse

The unique identification code of the warehouse to which the item belongs.

Note
This and the following five fields are available only when you select the respective dimensions in the previous form.

Batch number

The batch number for the item.

Location

The location of the item in the warehouse.

Pallet ID

The unique pallet identification code used for shipping the item.

Serial number

The serial number of the item.

Custom decl. ID

The customs declaration number for the item.

Posted quantity

The quantity of the item in inventory units.

Posted value

The financial cost price of the item.

Date financial

The date of the transaction.

Note
This and the following two fields are available only when you select Transactionsin the Method of cost value adjustmentpage.

Storno

This check box is selected if the cost price adjustment posted in the ledger is reversed.

Cost amount

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

Amount for allocation

Enter or modify the total cost price for the item quantity.

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 the allocation principle from the following options:

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

• Value– Adjustment is performed proportionate to the value of the selected item.

Value

Enter the price for the selected item after the adjustment.

Percent

Enter the percentage used to adjust the total cost price for the selected item.

Adjust

Select the entity to apply the percentage to, from the following options:

• Positive on-hand inventory

• Inventory on-hand total

Ledger account

Select the ledger account, for which the balance must be determined to calculate the adjustment amount for the selected item.

Balance on the date

Select or modify the date on which the balance should be determined for the selected ledger account.

Balance account

Select to determine the ledger account balance.

Balance from ledger account and dimensions

Select to determine the ledger account balance using specific dimensions.

Focus

Select the specific dimension of the ledger account to determine the ledger account balance.

Note
This field is active only when you select the Balance from ledger account and dimensionsoption.

Select

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

Balance (debit)

The ledger account debit balance.

Balance (credit)

The ledger account credit balance.

Note
Balance (debit) and Balance (credit) fields are available only if you select the Balance accountoption from the Balance from ledger account or dimensionspage.

Dimension

The dimension code for the selected focus.

Note
The Amountand Dimensionfields are available only if you select the Balance accountoption from the Balance from ledger account or dimensionspage.

Amount

The ledger account balance for the dimension line.

Adjustment date

The date of the ledger transaction.

Amount for allocation

The total ledger account balance amount considered for adjustment.

(Posting)

Storno

Select this check box to post the cost of adjustment to the ledger account as a reverse adjustment.

Note
If you clear the check box, the adjustment to the ledger account will not be posted as reversed.

Specification

Select the posting adjustment transactions 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.

Update ledger

Select a parameter to post transactions in the ledger.

Note
If you do not select this parameter, the cost price will be adjusted in inventory transactions but no adjustments will be made in the ledger.

Note

Enter a note about the adjustment.

Corr. account profit/loss

Select this check box to post the cost price adjustments to profit or loss accounts that are indicated in the item posting profiles.

Note
If you clear this check box, you can post the cost price adjustments to the offset account specified in the Corr accountfield.

Corr. account

Select the offset account for posting the cost price adjustment.

Dimensions of corr. account

Select this check box to specify the dimensions for the offset account with the following priorities:

• During transaction adjustments – The first priority is the indicated dimension value. The second priority is the dimension value from the receipt transaction that is being adjusted. The third priority is the dimension value from the item card.

• During balance adjustments – The first priority is the indicated dimension value. The second priority is the dimension value from the item card.

  Note
  If you clear this check box, the adjustment transactions will be posted without dimensions.

Department

Select the department name for the adjustment.

Cost center

Select the cost center for the adjustment.

Purpose

Select the purpose for the adjustment.

Sum posted

The financial cost price of the posted amount.

Show ledger voucher list

The transactions that are posted in the ledger after closing the wizard.