Edit

Quote, order, and invoice tables

Dynamics 365 Sales supports robust quote, sales order (order), and invoice building. You can build a quote by selecting products directly from the product catalog, specifying the price list (such as wholesale or retail), and entering the requested number of units. If you have permission, you can also apply discounts. The system supports multiple pricing models, such as wholesale versus retail, and you can discount by line item based on volume or manual override. In addition, you can apply overall discounts to the whole quote.

A quote is a formal offer for products or services proposed at specific prices and related payment terms that you send to a prospective customer. You can create a quote, save it as a draft, and specify whether it's active (presented to the customer) or closed (completed, either as an order or not). A quote can have a due date (when it was promised to the customer), effective dates (when it must be accepted or rejected by), and the requested delivery dates. In addition, a quote can contain many "ship to" addresses (by line item) or a "will call" setting for items to be picked up by the customer.

If you create a quote from an opportunity, Dynamics 365 Sales uses the products associated with the opportunity as the basis for the draft. When you convert a quote to an order, you can keep the opportunity open or close it. If you close it, the final revenue amount is recorded.

You can associate a quote with the following tables:

  • One or more products and one price list

  • One or more competitors

  • An opportunity

  • A customer

  • One or more notes and attachments

  • One or more customer addresses

    The quote detail (quote product) entity represents a line item in a quote. Each quote can have multiple quote detail (quote product) records.

    The quote close activity entity represents an activity that is generated when a quote is closed.

    A sales order (entity name: order) is a quote that a customer accepts. When you fulfill the order, you close the order and mark the status as fulfilled. For more information, see Sample: Fulfill a sales order.

    Note

    You can't set the status of multiple orders to fulfilled at one go.

    An invoice is an order that you bill.

Quote table
Quote Product (QuoteDetail) table
Quote Close (QuoteClose) table
Order (SalesOrder) table
Order Product (SalesOrderDetail) table
Order Close (OrderClose) table
Invoice table
Invoice Product (InvoiceDetail) table
Sample: Set Negative Prices in Opportunities, Quotes, and Sales Orders
Sample: Process Quotes, Sales Orders and Invoices
Sample: Fulfill a Sales Order
Opportunity Tables
Sales Tables
Set default price level for opportunity, quote, order, invoice

  • Last updated on