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

Video

Procedure

• 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

Procedure

• 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