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

Procedure

  1. Navigate to ProjectStream / Inventory / Products
  2. Edit an existing record or click New to add a new product

  • 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.

Procedure

  1. From an existing product, select the top navigation and pick Price List Items
  2. Click new 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.

Procedure

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

Still need help? Contact Us Contact Us