Item 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 Project management and accounting > Inquiries > Transactions > Item.

Use this form to view all item transactions.

Tasks that use this form

View transaction adjustment history

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

Filters

Filter

Description

Display

Select an option to determine the columns that appear in the Overview grid:

  • Price – View the cost prices and sales prices of item transactions.

  • Ledger updates – View information that is posted to the general ledger in the sales currency. The Consumed cost field shows the consumed costs that are posted to Profit and loss and to WIP accounts. The Revenue field shows the revenue amount that has been accrued or invoiced and that is posted to Profit and loss accounts.

  • Line amount – View the sales amount. This is the quantity of transactions multiplied by the sales price per transaction.

Invoice status

Filter records according to the following options:

  • All – View all transactions.

  • Invoiced – View all transactions that have a transaction status of Invoiced, Selected for credit note, or Credit note proposal.

  • Chargeable – View all transactions that have not been invoiced for time-and-materials projects that have a chargeable line property and a transaction status of either Posted or Invoice proposal.

  • Nonchargeable – View all transactions that are not time-and-materials projects and that have been posted to projects. For time-and-materials projects, transactions are displayed only if they have a transaction status of Posted and a nonchargeable line property.

Tabs

Tab

Description

Overview tab

View all transactions that appear in the grid based on the Display and Invoice status filter settings.

General tab

View details about the selected transaction.

Financial dimensions

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

The tab is empty if financial dimensions have not been created.

Product dimensions

View the product dimensions that are set up on the selected item transaction.

Cost

View the consumed cost of the transactions after it has been posted to a general ledger account. You can also see whether the transaction has been posted to a Profit and loss account or a WIP account.

Sales

View details about the sales amount that is associated with the selected transaction in addition to the revenue and invoicing status for the transaction.

Buttons

Button

Description

Voucher

View all financial updates for the selected transaction.

Ledger updates

View all transactions that have been posted to a project-related account.

Inventory

Open a menu with the following items:

  • Transactions – View related transactions that have been posted to the inventory.

  • Dimensions display – Select inventory dimensions to appear in the form.

Functions

Open a menu with the following items:

  • Adjustments – Adjust the current transaction line.

  • Post costs – Select transactions on which to post costs.

  • Accrue revenue – Select transactions on which to accrue revenue.

  • Invoice proposals – Create an invoice for the selected transaction.

  • Select for credit note – Select the current transaction for a credit note.

Inquiries

Open a menu with the following items:

Invoice lines – View the invoice lines of the invoice proposal or invoice to which the transaction is attached. The project invoice proposal or invoice is shown only if an invoice proposal has been created or an invoice has been posted for the transaction.

Committed costs – View costs that are associated with items that your legal entity has committed to purchase from a vendor.

Adjustment trace – View the relation between the original transaction, the reversal transaction, and the new transactions. You can also see information about when the adjustment was made, who made it, and which fields in the transaction were changed.

Fields

Field

Description

Project date

The date when the transaction was posted to the project.

Project ID

The project to which the transaction is attached.

Activity number

The identification of the project activity.

Category

The project category to which the line is attached.

Item number

The item number that is attached to the item transaction.

Line property

The attribute that defines cost and sales percentages and options for revenue accrual and cost capitalization. For example, select Chargeable or Nonchargeable.

Quantity

The number of units that are associated with the transaction.

Cost amount

The cost amount of the transaction before any price adjustments, such as taxes or discounts, are reflected.

Cost price

The price per single unit of the item.

Total cost amount

The total cost amount of the transaction after any price adjustments have been made, such as for taxes or discounts.

Sales currency

The currency in which the project is invoiced.

Sales price

The sales price per unit that is invoiced to the customer.

Transaction status

The status of the transaction.

Transaction ID

The identification of the transaction.

Reference ID

A unique identifier that is assigned to the project transaction.

Adjustment reference ID

A unique identifier that is assigned to the project adjustment transaction.

Transaction voucher

The journal voucher or project for the selected transaction.

Description

A description of the transaction that was entered into the Description field when the journal was posted.

Transaction origin

The source of the transaction, such as an item journal.

Unit

The unit of measure for the item that was consumed, such as pieces, gallons, liters, yards, or meters.

Net amount

The sales amount for the transaction. This amount includes all applicable discounts.

Accrued amount

The amount of accrued revenue. This must be a positive number if the Accrued revenue check box is selected on the Sales tab, which signifies that revenue has been accrued.

Sales tax group

The sales tax group that is associated with this transaction. A sales tax group is a set of codes that are used to calculate tax for sales and purchases.

Item sales tax group

The item sales tax group that is associated with this transaction. An item sales tax group is a set of codes that are used to calculate tax for items.

Lot ID

The summary or lot identification for transactions that attached to the same inventory transaction.

Packing slip

The identification of the packing slip.

Adjustment number

The unique identifier that is assigned to the project adjustment transaction.

Main account

The ledger account to which lines related to this transaction are posted.

Voucher

The voucher number that is associated with this transaction in ledger.

Ledger status

The status of the transaction in the ledger, such as balance sheet or profit and loss.

Estimate date

The date when this transaction was processed by the estimate system.

Amount

The total cost price of the items on the current date.

Funding source

The funding source that is associated with the transaction.

Accrued revenue

A selected check box indicates that revenue from an item transaction has been accrued.

Consumed cost

The number of items multiplied by the cost price in local currency.

Note

This field is displayed when the Item transactions form was opened from the Project statements form, and Ledger updates is selected in the Display filter.

Revenue

The revenue that is posted to the general ledger. The amounts are either accrued revenue or invoiced revenue. If the transaction has not been invoiced, the amount in this field is zero.

Note

This field is displayed when the Item transactions form was opened from the Project statements form, and Ledger updates is selected in the Display filter.

See also

About accrued revenue

Configuring line properties

Adjust transactions in projects

About automatic adjustment transactions

About transaction types

Configure settings for adjustment transactions

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