Export (0) Print
Expand All

About cost prices, sales prices, and transfer prices in projects [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

In Microsoft Dynamics AX, you can use three types of prices in projects that you manage in Project management and accounting:

  • Cost prices – Set up cost prices for project hours and expenses. Cost prices do not apply to fees or subscriptions. Cost prices apply to all project types in Microsoft Dynamics AX.

  • Sales prices – Set up sales prices for project hours, expenses, fees, and subscriptions. Sales prices only apply to Time and material projects.

  • Transfer prices – Set up transfer prices for project hours and expenses. Transfer prices for hours are the sales prices that you charge a related legal entity for a project worker that the related legal entity borrows from your legal entity.

All three types of prices are applied when a transaction is entered into a journal.

NoteNote

Cost prices and sales prices for items are set up in Inventory management. For information about how to create item prices, see Item price (form).

When the system searches for a price in Microsoft Dynamics AX, the price that is selected is always the price that matches the most criteria.

For example, two prices have been created for a particular project. One price specifies an effective date and a project number. The other price specifies an effective date, a project number, and a specific worker. The price that specifies the worker as an additional criterion is selected.

The primary criterion for all price types is the effective date, or the date on which the price first applies. For sales prices, currency is also a mandatory criterion. After a price match is found by using these criteria, the secondary criteria are matched. In this matching, the price that has the most matching criteria is selected.

An effective date is required in the definition of every cost price. You can define a cost price for any combination of an effective date and the following additional criteria:

  • Project

  • Category

  • Worker

An effective date and a currency are required in the definition of every sales price. You can define a sales price for any combination of these criteria and the following additional criteria:

  • Project

  • Category

  • Worker

  • Pricing

  • Transfer price model

An effective date is required in the definition of every transfer price. You can define a transfer price for any combination of an effective date and the following additional criteria:

  • Borrowing legal entity

  • Transaction type

    NoteNote

    This control is not available in versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

  • Project

  • Worker

  • Category

  • Sales currency

  • Transfer price model

    NoteNote

    This control is not available in versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

  • Pricing

When the system searches for the price that should be applied for a transaction, the price that is selected is always the price that matches the most criteria.

For example, two prices have been created for a particular project. One price specifies an effective date and a project number. The other price specifies an effective date, a project number, and a specific worker. The price that specifies the worker as an additional criterion is selected.

Cost prices are set up for categories, projects, and workers. The following table displays the search priority for cost prices. Search matches have a priority from 1 to 8 in the table.

Priority

Project

Worker

Category

Effective date

1

x

x

x

x

2

x

x

x

3

x

x

x

4

x

x

x

5

x

x

6

x

x

7

x

x

8

x

Sales prices are set up for categories, workers, projects, transaction dates, and currencies. The following table displays the search priority for sales prices. Search matches have a priority from 1 to 8 in the table. The currency and the effective date are the primary criteria. When prices have been found that have the correct currency, the search continues for a project and then a worker. The system then searches for a category to find the most detailed match. The last criterion that the system searches for is the transaction date.

Priority

Category

Worker

Project

Currency

Effective date

1

x

x

x

x

x

2

x

x

x

x

3

x

x

x

x

4

x

x

x

5

x

x

x

x

6

x

x

x

7

x

x

x

8

x

x

Transfer prices are set up for workers, products, projects, legal entities, and categories. The following table displays the search priority for transfer prices. Search matches have a priority from 1 to 8 in the table.

Priority

Borrowing legal entity

Project

Worker and product

Category

Effective date

1

x

x

x

x

x

2

x

x

x

x

3

x

x

x

x

4

x

x

x

x

5

x

x

x

6

x

x

x

7

x

x

x

8

x

x


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