Maintain Product Data

Maintaining Product Data is performed using the out-of-box Dynamics 365 Product Catalog.  As Microsoft continues to update the Dynamics product, Product data has to currently be maintained in the classic web user interface.

Create a Product



  1. Navigate to ProjectStream / Inventory / Products
  2. Edit an existing record or click New to add a new product
  3. Add product information (* for required fields)

  • Item Number:  Enter a unique Item Number for this Product.
  • Item Description:  Enter a Description for this Product
  • Product Class:  Select a valid Product Class for this item.  Primarily used for categorization but also enhances integration functionality to the designated back office Financial system.
  • Default Site:  Select a valid Site Location as the Default Site for this Product.
  • Sales Tax Option:  Valid selections are Taxable, Nontaxable, or based on the Customer Delivery address.
  • Sales Tax Schedule:  The schedule that will be used when the sales tax option is set to Taxable.
  • Purchase Tax Option:  Valid selections are Taxable, Nontaxable, or based on the Vendor Purchase address.
  • Purchase Tax Schedule:  The schedule that will be used when Purchase Tax Option is set to Taxable.
  • Unit / Qty:
    • Unit Group:  represents a Unit of Measure schedule for this product.  A product can have multiple units of measure (e.g. primary unit of measure = Each,  case = 24).
    • Default Unit:  the default unit of measure for this product
    • Quantity:  the current quantity on hand for this product.  On-hand quantities are increased or decreased from various transactions in the system.  (E.g. non Project PO for materials will increase the quantity on-hand)
  • Cost/Price
    • Standard Cost:  Standard Cost of the item for reporting purposes only. ProjectStream currently only supports Average Cost inventory valuation method.
    • Current Cost:  The current Cost of the item. This value is updated automatically with the last purchased cost. Value can be overwritten.
    • Average Cost:  Calculated by the system. Provides weighted average cost of inventory on hand.
  • Purchasing Data:
    • Primary Vendor:  Select the Primary Vendor for this product.  Used in planning and reporting functionality.
    • Purchasing UoM:  Select the default purchasing Unit of Measure for this product.
    • Item Vendors:  Multiple vendor records may be maintained from the Item Vendors record (in the left side navigation).
  • ProjectStream Data:
    • Profit Type:  Determines how products will be priced when added to project budgets.
      • Price / Rate:  Will use standard CRM Price List functionality.  Please see standard CRM documentation for explanation of the various pricing methods available.  ProjectStream supports all pricing methods in CRM.
      • Markup %:  Unit Price is calculated from Unit Cost.  Unit Price = Unit Cost + (Unit Cost x Markup %)
      • Margin %:  Unit Price is calculated from Unit Price.  Unit Price = Unit Cost / (1 - Margin%)
      • None:  Unit Price will be set to 0.
    • GL Accounts:
      • Inventory GL:  Account used for GL distribution when a change to Inventory Asset Amount is posted. (e.g. non project purchase order)
      • Variance GL:  Account used for GL distribution when an adjustment transaction is made against this product
      • COGS/Expense GL:  Account used for GL distribution when a job cost transaction is posted from either purchase transaction or inventory usage transaction
      • Revenue GL Account:  Account used for GL distribution when a Project Invoice is created for this product.

Maintain Price List


  1. From an existing product, select the top navigation and select Related / Price List Items
  2. Click + New Price List Item  to add to a new product price list
  3. Complete the Product Price list information

  • Price List:  Select an existing price list.  Price lists can be maintained separately and default price lists can be established on Customer records and Projects.  
  • Product:  Product is automatically populated from the product you are editing
  • Unit:  Enter the unit of measure for this Price List Item
  • Pricing Method:  
    • Currency Amount:  Price List Amount
    • Percent of List:  Percentage x Product List Price
    • Percent Markup: - Current Cost:  (Percentage x Current Cost) + Current Cost
    • Percent Margin: - Current Cost:  (Current Cost / (1 - Percentage))
    • Percent Markup: - Standard Cost:   (Percentage x Standard Cost) + Standard Cost
    • Percent Margin: - Standard Cost:  (Standard Cost / (1 - Percentage))

Maintain Product Locations

One or more product locations can be maintained for a product.  Product Locations can be added from the Product record, and can also be added on-the-fly during adjustment and transfer transactions.  The procedure below covers how to add locations from the product record.


  1. From and existing product, navigate to the Locations tab
  2. Click + New Product Location to add a new product location
  3. Select the location to associate with the product

Still need help? Contact Us Contact Us