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
Navigating the form
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:
|
Invoice status |
Filter records according to the following options:
|
Tabs
Tab |
Description |
---|---|
View all transactions that appear in the grid based on the Display and Invoice status filter settings. |
|
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:
|
Functions |
Open a menu with the following items:
|
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
Adjust transactions in projects
About automatic adjustment transactions
Configure settings for adjustment transactions
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).