Export (0) Print
Expand All

About posting setup for project transactions [AX 2012]

Updated: August 6, 2014

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

Note Note

Do you use Project management and accounting in Microsoft Dynamics AX? We’d like to hear from you! Your survey invitation is here: http://go.microsoft.com/fwlink/?LinkId=506702

You can use posting setup to specify the accounts to which project transactions should be posted.

You can post transactions according to projects, project groups, and funding sources, or according to categories and category groups, or any combination of these criteria. When you create project groups, you define the search priority as Project-first or Category-first to determine which posting rules take precedence when the system searches for posting accounts.

You can set up ledger posting in cost price accounts either by transaction type or by project type.

The following table shows which cost price accounts are applied by the input from the transaction types that are available in Project management and accounting.

Posting type

Hour

Expenses

Item

Fee

On account

Cost

x

x

x

Payroll allocation

x

WIP cost value accounts

x

x

Item cost

x

WIP Cost value item accounts

x

Accrued loss

x

WIP accrued loss accounts

x

Intercompany cost

NoteNote

Projects for which timesheets are entered cannot have a ledger setting of No ledger or Never ledger.

x

The following table shows what accounts are applied by the input from the project types available in Project management and accounting.

Posting type

Fixed price

Time and material

Internal

Investment

Cost

Time

Cost

x

x

x

x

x

Payroll allocation

x

x

x

x

x

WIP cost value accounts

x

x

x

x

Item cost

x

x

x

x

WIP cost value item accounts

x

x

x

x

Accrued loss

x

x

WIP accrued loss accounts

x

x

Intercompany cost

NoteNote

Projects for which timesheets are entered cannot have a ledger setting of No ledger or Never ledger.

x

x

x

x

x

x

Set up ledger posting in sales price accounts by transaction type or by project type.

The following table shows which sales price accounts are applied by the input from the transaction types available in Project management and accounting.

Posting type

Hour

Expenses

Item

Fee

On account

Invoiced revenue

x

x

x

x

On-account invoiced revenue

x

Sales value and accrued value

x

x

x

x

WIP sales value accounts

x

x

x

x

Accrued revenue through production

x

WIP production accounts

x

Accrued revenue through profit

x

WIP profit accounts

x

On-account accrued revenue

x

WIP invoice on-account accounts

x

Subscription and accrued revenue

x

WIP subscription accounts

x

Intercompany revenue

NoteNote

Projects for which timesheets are entered cannot have a ledger setting of No ledger or Never ledger.

x

The following table shows which sales price accounts are applied by the input from the project types available in the Project management and accounting module.

Posting type

Fixed price

Time and material

Internal

Investment

Cost

Time

About invoiced revenue

x

On-account invoiced revenue

x

x

Sales value and accrued revenue

x

x

WIP sales value accounts

x

x

Accrued revenue through production

x

WIP production accounts

x

Accrued revenue through profit

x

WIP profit accounts

x

On-account accrued revenue

x

WIP invoice on-account accounts

x

x

Subscription and accrued revenue

x

WIP subscription accounts

x

Intercompany revenue

NoteNote

Projects for which timesheets are entered cannot have a ledger setting of No ledger or Never ledger.

x

x

x

x

x

x

Transactions are posted to specific ledger accounts as follows:

  • Project and category are specified on the transaction.

  • The project specifies whether project transactions defer to project or category when searching ledger posting rules for an account. This setting is inherited from the project group.

  • When a transaction is posted, Microsoft Dynamics AX searches through the configurations in the Ledger posting setup form. The system searches first for a posting combination that matches the specific project and category. If it does not find this combination, the search continues using the priorities listed earlier in this topic. The search continues until the least specific combination (Project - All/Category - All), is found. If no combination is found, an error will be reported when you try to post a transaction.

The available cost price accounts can be applied for the following combinations of project types and transaction types.

Cost price account

Project types

Transaction types

Cost 
(Profit & loss)

Time and material, Fixed-price, Investment, Cost, Internal, and Time

Hour, expense, and item, transactions

WIP - cost value 
(Balance)

Time and material, Fixed-price, Investment project, and Internal

Hour and expense transactions

Cost - item 
(Profit & loss)

Time and material, Fixed-price, Investment, and Internal

Item transactions

WIP - cost value - item

Time and material, Fixed-price, Investment, and Internal

Item transactions

Payroll allocation 
(Profit & loss)

Time and material, Fixed-price, Investment, Cost, Internal, and Time

Hour transactions

Intercompany cost

Time and material, Fixed-price, Investment, Cost, Internal, and Time

Hour transactions

The available sales price accounts can be applied for the following combinations of project types and transaction types.

Sales price account

Project types

Transaction types

Invoiced revenue 
(Profit & loss)

Time and material projects

Hour, expense, item, fee, and on-account transactions

Invoiced revenue - on-account 
(Profit & loss/Balance)

Time and material and Fixed-price projects

On-account transactions

Accrued revenue - sales value 
(Profit & loss)

Time and material and Fixed-price projects

Hour, expense, item, and fee transactions

WIP - sales value 
(Balance)

Time and material and Fixed-price projects

Hour, expense, item, and fee transactions

Accrued revenue - production 
(Profit & loss)

Fixed-price projects

Fee transactions

WIP - production 
(Balance)

Fixed-price projects

Fee transactions

Accrued revenue - profit 
(Profit & loss)

Fixed-price projects

Fee transactions

WIP - profit 
(Balance)

Fixed-price projects

Fee transactions

Accrued revenue - on-account 
(Profit & loss)

Fixed-price projects

On-account transactions

WIP - Invoiced - on-account 
(Balance)

Time and material and Fixed-price projects

On-account transactions

Accrued revenue - subscription

Time and material projects

Fee transactions

WIP - subscription

Time and material projects

Fee transactions

Intercompany revenue

Time and material, Fixed-price, Investment, Cost, Internal, and Time

Hour transactions

The following table outlines posting setup by project group or by category and indicates the priority for ledger accounts on an individual project.

Priority

Account priority

1

  • Project – Project, category

  • Category – Project, category

2

  • Project – Project, category group

  • Category – Project group, category

3

  • Project – Project, all categories

  • Category – All Projects, category

4

  • Project – Project group, category

  • Category – Project, category group

5

  • Project – Project group, category group

  • Category – Project group, category group

6

  • Project – Project group, all categories

  • Category – All projects, category group

7

  • Project – All projects, category

  • Category – Project, all categories

8

  • Project – All projects, category group

  • Category – Project group, all categories

9

  • Project – All projects, all categories

  • Category group – All projects, all categories


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft