Adjust transactions (form) (Inventory)

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

Click Inventory management > Periodic > Closing and adjustment. Select Adjustment and then select Transactions.

Use this form to adjust the financial value of the selected transaction.

Note

If you adjust a transaction, the overall inventory value of the item is changed.

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

Fields

Field

Description

Date financial

Displays the original financial date of the selected inventory transaction.

Item number

Displays the unique item number returned from the select criteria. This is a unique user-defined code that is assigned when items are created. We recommend avoiding special characters or spaces in the item number.

Item numbers can be system generated by linking the item number to a number sequence. For more information, see Number sequences (list page).

Posted quantity

Quantity of on-hand inventory as of the inventory close date selected before opening the Adjustment of on-hand inventory form. This value is non-editable.

Posted value

Total inventory value of the financial updates for the item that was posted in the general ledger module. This value is based on the inventory close date selected before opening the Adjustment of on-hand inventory form. The value is negative if items that have only been physically received in inventory and have already been sold or invoice-updated. The field appears when you total the Financial cost amount for all transactions with the status Purchased or Sold.

Adjustment

The Adjustment field shows the amount that the Posted value field has been changed with. In other words, the cost amount representing the change of the posted value.

Edit now

Enter the value by which the item receipt is to be adjusted.

Buttons

Button

Description

Select

Select which transactions you want to adjust. You can select a transaction only one time. If you want another selection, you must first delete the selected transactions.

Delete

Delete the current selection.

Adjustment

Automatically assign a value to the Edit now field based on various criteria. If you click Adjustment, all selected item receipts are adjusted according to the method that you select:

  • Item cost price – The cost price is adjusted to the item cost price for the individual item. The item cost price is specified in the Base price field in the Released product details form.

  • Fixed cost price – Enter a fixed cost price that is not checked against the item cost price used for individual items.

  • Amount – Enter the amount by which the item is to be adjusted. This is allocated to all transactions according to the selected allocation principle. If you select Value as the principle, the amount is allocated proportionally according to the value of the transactions. If you select Quantity as the principle, the amount is allocated proportionally according to the transactions' quantity.

  • Value – Specify the value to which you want to adjust. The value is allocated to all transactions according to the selected allocation principle. If you select Value as the principle, the amount is allocated proportionally according to the value of the transactions. If you select Quantity as the principle, the amount is allocated proportionally according to the transactions' quantity.

  • Percent – You can adjust the cost price by any percentage. All transactions are adjusted to the cost price assigned to them plus the given percentage.

If you use different adjustment methods in the same selection, the value in the Edit now field will always be set according to the latest adjustment.

Inventory

Click Inventory > Dimensions display to select which inventory dimensions to display in the transaction journal.

Post

Opens a form where you can update the adjustments and change the cost value indicated in the Posted value field.

The posting date you decide must be later than the date financial on the transaction adjustment journal.

Your choice of Total, Item Group, or Item will determine the level of detail posted to the general ledger accounts.

If you select Update ledger, the general ledger accounts related to the open transactions of the on-hand inventory will be updated.

Note lets you enter a note pertaining to this particular adjustment of on-hand inventory.

Print

Print a journal when you have finished changing cost prices. This journal contains the information found in the Adjust transactions form.

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