About vendor payment retention for projects [AX 2012]

Updated: October 16, 2012

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

Your organization might want to retain a portion of payments to vendors who work on projects for your organization. For example, you might want to make sure that the products from a subcontract vendor meet your expectations before you pay the vendor.

When you negotiate purchases for projects with vendors, you can specify the vendor retention terms that include the percentage or amount to retain. As a vendor delivers items and services, you deduct the specified retention percentage or amount from your payment to the vendor. When the project is completed or reaches an interim stage specified in the contract with the vendor, you release the retained amount and create a payment to the vendor.

Before you can set up retention terms for a project, you must complete the following prerequisites:

The following example shows how a percentage of a vendor invoice amount is retained based on the percentage that is complete for a project.

Create a purchase order for 10 units of an item. The cost per unit is USD 100, and the total amount of the purchase order is 1,000. The number of units will be delivered in three stages with the following schedule:

  • Phase 1: 5 units, or 50 percent of the project

  • Phase 2: 3 units, or 80 percent of the project in total

  • Phase 3: 2 units, or 100 percent of the project

The following table lists the retention terms.

Percentage of units delivered

Percentage to retain

Percentage to release










The transactions result in the following amounts:

  • Phase 1:

    • The amount payable is 5 x 100, or 500.

    • 20 percent of the amount, or 100, is retained and will be released at a later stage.

    • The amount that is paid to the vendor is 400.

  • Phase 2:

    • The amount payable is 3 x 100, or 300.

    • 10 percent of the amount, or 30, is retained.

    • 10 percent of the 100 that was retained in Phase 1, or 10, is released.

    • The amount that is paid to the vendor is 280. This amount consists of 300 less the 30 retention plus the 10 that was released from the Phase 1 retention.

  • Phase 3:

    • The amount payable is 2 x 100, or 200.

    • No amount is retained.

    • The amount that is released is 120. This amount consists of the 100 that was retained in Phase 1, less the 10 from Phase 1 that was released in Phase 2, plus the 30 that was retained in Phase 2.

    • The amount that is paid to the vendor is 320. This amount consists of the retained amount of 120 plus the 200 for completion of Phase 3.

The total amount that is paid to the vendor after the three phases are completed is 1,000, which is the total amount of the purchase order (400 + 280 + 320).

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

Community Additions