Fixed asset value model inventory transactions (form)

  • Article

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

Click Fixed assets > Common > Fixed assets > Fixed assets. Select a fixed asset. On the Action Pane, click Value models. Select a value model. Click Inventory > Inventory transactions.

Use this form to view and analyze inventory transactions for an asset. Only asset transactions from purchase orders and the inventory journal for fixed assets can be viewed and analyzed.

You can view the following information about the physical and financial part of an inventory transaction:

  • Inventory update

  • Ledger update

  • Voucher numbers

  • Dates

  • Lot numbers

  • References

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

Tabs

Tab

Description

Overview

View and modify a list of inventory transactions for the asset.

General

View and modify inventory transactions for the record that is selected on the Overview tab.

Update

View and enter physical, financial, settlement, and ledger information for the selected transaction.

Ledger

View the posting and account information that is attached to the ledger account for the selected transaction.

Reference

View the account number references.

Other

Enter or view additional information about the transaction, such as update information, details about item returns, and system, bill of materials (BOM), and project information.

Financial dimensions - financial

View information about financial dimensions for financial transactions, such as the default dimensions and where the dimensions are used in account structures and account rule structures.

Financial dimensions - physical

View information about financial dimensions for physical transactions, such as the default dimensions and where the dimensions are used in account structures and account rule structures.

Inventory dimensions

View information about inventory dimension for the selected inventory transaction.

Buttons

Button

Description

Inventory

View related transactions in the inventory.

Ledger

View attached ledger transactions.

Functions

Click Functions > Split to divide an open transaction into several transactions. Click Functions > Summation to group several transactions that share the same lot number into a single transaction.

Configuration details

View the configuration variables for the selected item.

Fields

Field

Description

Configuration

Select an item configuration to specify an item with specific attributes.

Size

Specify the item size.

Color

Specify the item color.

Site

Specify the site where the item is located.

Warehouse

Enter the warehouse in which you store items.

Batch number

Enter the batch number dimension.

Serial number

The serial number dimension.

Physical date

The date when the items were received or picked on a packing slip (physical transaction).

Financial date

The date when the item invoices or cost accounting for the items was updated through production (financial transaction).

Reference

The module that generated the transaction.

Number

The number of the reference type specified in the Reference field.

Receipt

The current receipt status for receipt transactions. If this field is empty, the transaction is an issue.

Issue

The current issue status for issue transactions. If this field is empty, the transaction is a receipt.

Quantity

The quantity, in inventory units, for the transaction. The quantity shows receipts and issues. Issues will show a minus sign.

Cost amount

The cost of the inventory transaction, in the accounting currency.

Item number

The item identifier.

Party

The name of the origin reference.

Inventory reference

The inventory reference type that was used for processing the transaction.

Inventory number

The inventory order number processing the transaction.

Project ID

The identifier for the project that generated the inventory transaction.

Lot ID

The lot identifier that is referred to.

Reference lot

The reference for the item to the inventory transactions.

Dimension No.

The identifier of the inventory dimensions.

Value open

If selected, the transaction has not been posted to the general ledger.

Receipt status

The current receipt status for receipt transactions. If this field is empty, the transaction is an issue.

Issue status

The current issue status for issue transactions. If this field is empty, the transaction is a receipt.

Expected date

The date of the expected transaction, such as the delivery date for a sales order.

Inventory date

The date when items are registered or picked.

Requested ship date

The date on which the selling company should ship the item in order to meet the customer’s requested receipt date.

Confirmed ship date

The date on which the selling company confirms that the order will be shipped.

Non-financial transfer

If selected, the inventory transaction has not updated the general ledger.

Transfer lot ID

The identifier of the transfer lot.

Physical voucher

The voucher number that is used when you post floating items, which are packing slip-updated items. The voucher number refers to the ledger voucher number.

Route

The routing number of a specific sub route. The active sub route was overridden on the BOM line. If the field is blank, the active sub route is used.

Packing slip

The packing slip number, when an item is picked or received on a sales or purchasing packing slip.

Physical cost amount

The floating physical inventory value of the inventory record in connection with, for example, updating packing slips. An example of a floating value is a physical cost amount that has not been financially updated in the general ledger.

Physical revenue

The physical revenue that is posted in connection with updating the packing slip.

Physically posted

If selected, inventory quantities are updated.

Financially posted

If selected, the voucher has been posted to the general ledger.

Physical turnover posted

If selected, the voucher has been physically posted.

Financial voucher

The voucher number that is used when updating invoices or costing. The voucher number refers to the ledger voucher number.

Invoice

The invoice number, when an order or vendor invoice is updated.

Financial cost amount

The inventory value for the financial quantity that was updated in connection with, for example, updating invoices.

Adjustment

Any adjustment of the cost that results from, for example, a closing of inventory.

Profit and loss, posted amount

Amounts that have been offset and posted to the operating account in connection with, for example, posting inventory journals.

Unposted invoice

The identifier of the unposted invoice that is connected to the selected purchase order inventory transaction.

Note

Information is displayed in this field only if the receipt status is Received or the issue status is Deducted.

Financially closed

The date when the financial transaction was closed or when the full quantity was settled.

Settled quantity

The quantity that has been financially settled.

Amount settled

The cost value that has been financially settled.

Physical posting

The transaction type of the ledger account that is used for physical posting.

Physical offset

The transaction type of the ledger offset account that is used for physical posting.

Balance sheet posting

The transaction type of the balance sheet account that is used.

Profit and loss posting

The transaction type of the profit and loss account that is used.

Turnover posting

The transaction type of the ledger account that is used for turnover posting.

Offset

The transaction type of the ledger offset account that is used for turnover posting.

Ledger account ( Accounts - physical )

The ledger account that is used for physical posting.

Offset account ( Accounts - physical )

The ledger offset account that is used for physical posting.

Ledger account ( Accounts - financial )

The ledger account that is used for financial posting.

Offset account ( Accounts - financial )

The ledger offset account that is used for financial posting.

Ledger account ( Accounts - physical revenue )

The ledger account that is used for physical revenue posting.

Offset account ( Accounts - physical revenue )

The ledger offset account that is used for physical revenue posting.

Type

The ledger account transaction type.

Quantity

The quantity of the item.

Unit

The number of items.

Unit price

The unit price of the selected item.

Discount

The discount amount for the selected item.

Discount percent

The discount percentage for the selected item.

Line amount

The line amount for the selected item.

Transaction currency

The transaction currency for the selected item.

Currency

The currency that is associated with the item receipt.

Fixed receipt price value

The standard cost price for the transaction that is converted to the cost value.

Category

The project category for the project that is used.

Packing slip or product receipt return

If selected, the transaction involves goods that have been returned on a packing slip.

Invoice return

If selected, the transaction involves goods that have been returned on a credit note.

Return lot ID

The lot number of a returned item. The return lot number is used on credit notes in Accounts receivable or in inventory journals that have a type of Transfer or Gain/Loss.

Status date

The date that is associated with the status of the transaction.

Estimated time

The scheduling time for inventory transactions, with regard to job-scheduled productions.

Activity number

The activity number for the inventory transaction.

Adjustment number

The project adjustment reference.

Financial dimensions - financial

The default financial dimensions for the selected item.

Where the %1 dimension is used

( Financial dimensions - financial tab)

The account structures and account rule structures that use the financial dimensions that you selected in the Financial dimensions - financial field group.

Financial dimensions - physical

The default physical financial dimensions for the selected item.

Where the %1 dimension is used

( Financial dimensions - physical tab)

The account structures and account rule structures that use the physical financial dimensions that you selected in the Financial dimensions - physical field group.

Location

The location inside a warehouse.

Pallet ID

The unique identifier for the pallet (Serial Shipping Container Code).

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