Vendor and Purchase Price List Management in Project Operations

Effective vendor and purchase price list management is essential for streamlined operations within Microsoft Dynamics 365 Project Operations. This blog provides an overview of how vendors and purchase price lists are managed, particularly for Lite deployment scenarios involving deal to proforma invoicing.

Vendors in Project Operations

In Project Operations, vendor accounts must have a relationship type of Vendor or Supplier. Only accounts with these relationship types can be selected as vendors on a subcontract.

Key Fields and Concepts on a Vendor Record

1. To create a vendor record, navigate to Projects> Vendors and click on "New" to create a new vendor

   
   

   

Please note that vendor should ideally be created in D365 F&O and synced into Project Ops through dual write.

1. Populate the below fields on the vendor record:

   • Company: Legal entity to which the vendor will be associated with.

   • Account name : Name of the vendor

   • Account number : Vendor account number

   • Currency : Set the required currency

   • Relationship type : Set up as “vendor”

   • Vendor group: Tag the correct vendor group ID

   
   

   

   
   

By default, the following fields and concepts on a vendor record are used for any subcontract created for the vendor:

• Payment Terms

• Bill to Contact

• Primary Contact

• Currency

• Current Purchase Price Lists

Associating Purchase Price Lists with Vendor Records

You can associate one or more purchase price lists with a vendor record. However, each purchase price list should have distinct date effectivity, as overlapping dates are not supported. This ensures clarity and avoids conflicts in pricing.

1. To tag a price list to vendor record, navigate to Vendor > Vendor account > Project Price Lists and click on "Add New Project Price Lists"

Purchase Price Lists in Project Operations

A price list where the Context field is set to Purchase is considered a purchase price list. These lists represent a catalog of purchase rates for time, expenses, and materials, similar to cost and sales price lists in Project Operations.

1. Navigate to Price Lists > General tab > Set "Context" field to "Purchase"

Key Concepts for Purchase Price Lists

• Date Effectivity: Each price list has a start date and end date that define its effective period.

• Currency: The currency specified on the price list header is used for expressing purchase prices for labor, expense categories, and products.

• Default Time Unit: This unit expresses labor prices for purchases. The value provided can be changed on individual role price rows.

Subcontract-Specific Purchase Price Lists

Purchase price lists can also be attached directly to subcontracts as project price lists. They are used to enter default prices on subcontract lines. Similar to vendor records, each attached purchase price list must have distinct date effectivity, and only price lists where the Context field is set to Purchase can be attached to subcontracts.