About expense-related cost price fields [AX 2012]

Updated: November 19, 2010

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

The following example illustrates the relationship between the fields in the Cost price group in the Expense transactions form.

To access the form, do the following: Click Project management and accounting > Inquiries > Transactions > Expense.

Example

The following assumptions apply to the example:

  • A company located in the United States has a customer located in France.

  • The expenses incurred are expressed in EUR, and the default currency of the company (known as "company currency" in the example) is USD.

  • A quantity of 10 units is purchased by the customer, at the price of EUR 50 per unit.

  • The exchange rate of EUR 100 is USD 120.

  • The local US tax rate is 3 percent.

    Field

    Formula

    Method

    Total

    Quantity

    10

    Quantity bought

    10

    Amount

    10 x 50 = 500

    Quantity x cost price per unit

    500

    Cost price

    1 x 50

    Price per unit

    500

    Tax included

    10 x 50 x .03.

    Quantity x cost price per unit x tax amount

    The local US tax amount on the total purchase.

    Amount

    10 x 50 x 1.2 + 3%

    Quantity x cost price per unit x exchange rate + tax amount

    USD 618 (local currency)

    Total cost amount

    10 x 50 x 1.2 + 3%

    Quantity x cost price per unit x exchange rate + tax amount

    USD 618 (default currency)


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

Community Additions

ADD
Show: