Inventory transactions (form)

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

Click Product information management > Common > Released products. On the Action Pane, click the Manage inventory tab. In the View group, click Transactions.

Use this form to view all issue transactions and receipt transactions that are associated with the selected product or product master. For product variants that are based on a product master, transactions are created for the product master.

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

The tabs and controls that were added to this form for the Warehouse management features in Microsoft Dynamics AX 2012 R3 are not described in this topic. For information about these features, see Warehouse management.

Tabs

Tab

Description

Overview

View a list of transactions.

General

View additional information about the transaction that is selected on the Overview tab.

Update

View information about the physical, ledger, financial, and settlement updates of the selected transaction.

Ledger

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

Reference

View account number references for both Procurement and sourcing and Accounts receivable.

Other

View or enter additional information about the selected transaction, such as additional update information, details about item returns, and system 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 advanced 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 advanced rule structures.

Inventory dimensions

View information about inventory dimensions for the selected product or product variant.

Buttons

Button

Description

Inventory

Open a menu that contains the following items:

  • Transactions in physical voucher – Open the Transactions in physical voucher form, where you can view the financial vouchers for the unrealized amount of the physical posting that is associated with the transaction. Physical postings can, for example, be in the form of product receipts.

  • Transactions in financial voucher – Open the Transactions in financial voucher form, where you can view the financial vouchers for the obtained amount of the financial posting that is associated with the transaction. Financial postings can, for example, be in the form of invoices.

  • Transactions for dimensions – Open the Inventory transactions form, where you can view transactions that use the same dimensions as the selected transaction.

  • Lot – Open the Lot form, where you can view receipt or issue transactions for the lot number that is associated with the transaction.

  • Settlements – Open the Settlements form, where you can view all settlements for the transaction.

  • Cost explorer – Open the Cost explorer form, where you can trace the origin of the cost price that is associated with the inventory transaction.

  • Trace – Open the Trace inventory dimensions form, where you can view receipts and issues for the inventory dimensions that are related to the selected transaction.

  • On-hand – Open the On-hand form, where you can view or adjust the on-hand quantity of the item.

  • Reservation – Open the Reservation form, where you can view reservations or reserve a quantity of the on-hand inventory.

  • Marking – Open the Marking form, where you can view markings for the selected transaction.

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

Ledger

Open a menu that contains the following items:

  • Physical voucher – Open the Voucher transactions form, where you can view the voucher transactions for physical transactions by journal number and posting date.

  • Financial voucher – Open the Voucher transactions form, where you can view the voucher transactions for financial transactions by journal number and posting date.

  • Unposted invoices – View any pending invoices that are associated with the transaction.

Functions

Open a menu that contains the following items:

  • Split – Split an open transaction into several transactions.

  • Summation – 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

The item configuration, which specifies an item that has specific characteristics.

Size

The size of the item.

Color

The color of the item.

Warehouse

The warehouse in which the item is stored.

Batch number

The batch number dimension of the item.

Serial number

The serial number dimension of the item.

Physical date

The date on which the items were received or picked.

Financial date

The date on which the items were invoice updated or cost accounted through production.

Reference

The origin of the transaction.

Number

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

Receipt status

The current status of the receipt transaction. If this field is empty, the transaction is an issue. The receipt statuses are as follows:

  • Purchased – The purchase order is invoiced.

  • Received – The purchase order is updated on a product receipt.

  • Registered – The item is registered. If the Registration requirements check box in the Item model groups form is selected, item receipts must be registered when the physical update occurs.

  • Arrived – The item is registered in a shipment.

  • Ordered – The purchase order is created.

  • Quotation receipt – A sales quotation that has a negative quantity has been sent to the customer for approval. A credit note has not yet been created for the sales quotation.

Issue status

The current status of the issue transaction. If this field is empty, the transaction is a receipt. The issue statuses are as follows:

  • Sold – The sales order is invoiced.

  • Deducted – All order lines have been delivered to the customer.

  • Picked – The sales order is updated on a picking list.

  • Reserved physical – The item is on hand and is reserved for a sales order.

  • Reserved ordered – The item is not on hand, but it is reserved from a purchase order.

  • On order – The sales order is created.

  • Quotation issue – The sales quotation has been sent to the customer for approval. The sales quotation is not yet a sales order.

Quantity

The quantity for the transaction, in inventory units. The quantity shows receipts and issues. Issues are indicated by a minus sign.

Cost amount

The inventory value for the quantity that is financially updated, such as in an invoice update.

Item number

The identifier of the item.

Type

The origin of the transaction.

Number

The customer or vendor account number.

Party

The name of the customer or vendor account.

Inventory reference

The production journal or output order from which the transaction is processed.

Inventory number

The inventory order number from which the transaction is processed.

Project ID

The identifier of the project that generated the inventory transaction.

Lot ID

The lot number that is related to the transaction.

Reference lot

The reference to the lot ID.

Dimension No.

The unique number that identifies the inventory dimension values for the inventory transaction.

Receipt status

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

Issue status

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

Value open

A value of Yes indicates that the transaction is financially open.

Expected date

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

Inventory date

The date on which items were registered or picked.

Requested ship date

The date when the items must be shipped to meet the customer's requested receipt date.

Confirmed ship date

The date when the order will be shipped as confirmed.

Non-financial transfer

If this check box is selected, the transaction is related to a non-financial transfer. A non-financial transfer is a transfer between two inventory dimensions. Non-financial transfers are not financially tracked.

Transfer lot ID

The identifier of the transfer lot.

Physical voucher

The voucher number that is used when you post unrealized costs for items that are updated on a packing slip or a product receipt. The voucher number is based on the numbering convention that is used in General ledger.

Route

The route number of a specific subroute. This subroute is the active subroute that was overridden on the bill of materials (BOM) line. If this field is empty, the active subroute is used.

Packing slip

The packing slip number that is generated when an item is picked or received on a packing slip or product receipt.

Physical cost amount

The estimated physical inventory value of the inventory record.

Physical revenue

The physical revenue that is posted when the packing slip is updated.

Physically posted

If this check box is selected, the estimated value of the physical inventory that is associated with the inventory record is posted to General ledger.

Financially posted

If this check box is selected, the inventory value of the financially updated quantity that is associated with the inventory record is posted to General ledger.

Physical turnover posted

If this check box is selected, the deferred revenue of the estimated inventory value that is associated with the inventory record is posted to General ledger.

Tip

For a packing slip update, the accrued revenue of a transaction can be posted to General ledger. Select the Post to Deferred Revenue Account on Sales Delivery check box for the item model group that is associated with an item. Item model groups are configured in the Item model groups form.

Financial date

The date of the financial transaction. This date is the date on which the items are invoice updated or cost accounted through production.

Financial voucher

The voucher number that is used in invoice updating or costing.

Invoice

The invoice number that is saved when an invoice is updated for a sales order or a purchase order.

Adjustment

The adjustment of the cost amount. The adjustment can, for example, be the result of closing the inventory.

Profit and loss, posted amount

The sum of the amounts that have been offset and posted to the operating account, such as for posting inventory journals.

Unposted invoice

The identifier of an invoice that has not been posted for a purchase order that is associated with the inventory transaction.

Note

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

Financially closed

The date on which the transaction was financially closed, such as when the full quantity was financially settled.

Settled quantity

The quantity that has been financially settled.

Amount settled

The cost value that has been financially settled.

Posting - physical

The posting type for the estimated physical inventory value of the inventory record. The posting types are associated with an account and an offset account in General ledger. The corresponding account numbers are listed in the Accounts - physical field group.

Posting - financial

The posting type for the inventory value of the financially updated quantity. The posting types are associated with an account and an offset account in General ledger. The corresponding account numbers are listed in the Accounts - financial field group.

Posting - physical revenue

The posting type for the accrued physical revenue of the inventory record. The posting types are associated with an account and an offset account in General ledger. The corresponding account numbers are listed in the Accounts - physical revenue field group.

Unit

The unit of measure that is applied for the item quantity.

Unit price

The price per unit of the items on the transaction line.

Discount

The discount per unit of the items on the transaction line.

Discount percent

The discount percentage of the order line.

Note

If a discount is defined per unit of the items, the discount percentage is calculated after the discount per unit is subtracted.

Line amount

The amount of the transaction line after the discount has been subtracted.

Transaction currency

The currency that is associated with the transaction.

Currency

The currency that is associated with the item receipt.

Fixed receipt price value

The standard cost price for the transaction, converted to the cost value.

Category

The project category for the project that is used.

Packing slip

If this check box is selected, items on this transaction have been returned.

Invoice

If this check box is selected, items on this transaction 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 journals that have a journal type of Inventory adjustment or Transfer.

Status date

The date that is associated with the transaction's status.

Estimated time

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

Project ID

The identifier of the project that is associated with the transaction.

Activity number

The project activity that is associated with the transaction.

Category

The project category that is associated with the transaction.

Adjustment number

The project adjustment that is associated with the transaction.

Default financial dimensions

The default financial dimensions for the main account. When you select a financial dimension value, the Where the %1 dimension is used field group displays where the dimension is used in account structures and advanced rule structures.

Where the %1 dimension is used

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

Note

The name of the field depends on the selection in the Financial dimensions or Default financial dimensions field group.

Location

The location of the items inside a warehouse.

Pallet ID

The unique identifier of the pallet.

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