web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Custom quote with Margin and Accruals

(6) ShareShare
ReportReport
Posted on by 60
Hi Experts,
 
Currently our quoting is manual/excel-based and I'm trying to deploy it into Business Central. 
 
We get custom product specs (new product each time) from customers and send several vendors RFQs to quote us based on those specs. Vendor RFQ is handled by another dept. We select the best price, add our COGS and Margin and return the Sales Quote. Ideally we'd want to have some linkage between Vendor and Sales quotes (or capture both on the Sales quote) as well as capture the Final Product, Accruals and Margin in this process so it doesn't have to be re-entered at the order stage. 
 
How would you suggest to set up in this scenario? 
 
Thank you 
Illya
I have the same question (0)
  • Verified answer
    Grigorios Mavrogeorgis Profile Picture
    2,606 Super User 2026 Season 1 on at
    Hi,

    Standard BC does not handle this out of the box, but a light setup gets close.

    For the custom product, a generic or non-stock item template with the spec on the line description or an attached document works better than creating a new Item every time.

    For vendors, use Purchase Quotes, one per vendor, with a small customisation adding Sales Quote No. and Line No. to link them back. A FactBox on the Sales Quote showing related Purchase Quotes gives full visibility. Once the winning vendor is selected, the unit cost flows into the Sales Quote line, with margin and accrual fields alongside.

    The step most people miss is conversion. When the Sales Quote becomes a Sales Order, custom fields and the vendor choice do not move automatically. A small extension handles that, and the same logic can turn the winning Purchase Quote into a Purchase Order from the Sales Order.

    If every enquiry is really a small project with multiple vendors and accrued costs, BC Jobs (Projects) is a stronger fit. Each enquiry becomes a Job, with planning lines, job purchases, and built-in margin reporting.

    Light customisation on Sales and Purchase Quotes for simple cases, Jobs for anything more project-like.

     Tick the checkbox below to mark the answer as verified, if it helped resolve your question.
     
    Regards
    Gregory Mavrogeorgis
     
  • Suggested answer
    YUN ZHU Profile Picture
    102,123 Super User 2026 Season 1 on at
    Can you save it as an attachment in the Sales Quote? That way, you don't need to customize it.
     
     
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    17,911 Super User 2026 Season 1 on at
    Hello Illya,
    I’d keep this as a Sales Quote as the main customer-facing document, and use Purchase Quotes for the vendor RFQs; standard BC lets you convert a sales quote to an order and a purchase quote to a purchase order, but it does not give a strong out-of-the-box “many vendor RFQs linked to one sales quote” workspace, so for a clean process I’d use a quote/job or opportunity number as the common reference, store vendor quote PDFs/specs as attachments, and add custom fields/lines if you need to capture selected vendor, estimated cost, accruals, margin %, and final product spec before order creation. For the product itself, don’t create a permanent item for every one-off unless you really need inventory history by item; use a generic/non-stock/service item plus description/spec attachment, or create a proper item only when the quote is won. If this process is core to the business, a small customization is usually worth it: add a “Vendor RFQ comparison” page/table linked to the Sales Quote, then carry the winning cost/margin/accrual fields to the Sales Order when using Make Order.
    Regards,
    Oussama Sabbouh
  • Suggested answer
    AndrewThomas81 Profile Picture
    2,258 on at
    You could also consider adding a sales order dimension and attaching this to sales orders/purchase orders - this can then link multiple sales/purchase documents without any customisation
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • Suggested answer
    Nimsara Jayathilaka. Profile Picture
    5,133 Super User 2026 Season 1 on at
    Hi
    build your quote as a Project Task where you can estimate varying vendor costs, accruals, and margins using planning lines.
    You can deploy a AL extension that adds custom fields directly to the Sales Quote lines so the system automatically computes your final unit price and seamlessly transfers those exact variables to the resulting Sales Order and Purchase Order upon conversion.
  • Illya Stepanskyy Profile Picture
    60 on at
    Thanks Gregory
     
    The light set up with a small customization you suggested seems to be what we will want to do.
     
    To clarify, while the quoted product will be custom, it will become a sale/inventory item if approved by Customer and might receive repeat orders. So for this to function we would need a way to "save" the selected final item. I'm not too familiar with the Jobs/Project module but on a quick look it does a good job with accruals and costs.
     
    Attaching documents might be useful as well, and given the nature of these quotes, we have to attach some drawings anyway - so we may have to do the combination of item description with attachments. 
     
    If we do a generic or a non-stock item and end up not using it on any Sales, wouldn't it impede with our reporting, and also, I imagine we would need to find a way to convert the non-stock item into inventory item and have an automation copy all the data we used during quoting? 
     
    Thank you. 
     
     
  • Illya Stepanskyy Profile Picture
    60 on at
    YUN ZHU, attachments are possible but we are trying to optimize the amount of data we record in the system, so we don't have to re-do the full product once it's approved from quote to order. See my comment above as we will likely want to have a combo of product fields with attachments. 
     
    Thank you 
  • Illya Stepanskyy Profile Picture
    60 on at
    OussamsSabbouh, 
     
    This makes good sense to me but  see my comment above re making a permanent item out of a temp - I'm not sure if there is an automation or flow for that. 
     
    Thank you
  • Illya Stepanskyy Profile Picture
    60 on at
    AndrewThomas81,
     
    How would dimension help with this? Do you mean creating, for example, a "Quotes" dimension to and record quotes under SOs? It sounds like a good option but I'm a little worried about the reporting repercussions of this/ .
     
    Thank you
  • Verified answer
    OussamaSabbouh Profile Picture
    17,911 Super User 2026 Season 1 on at
    Hello Illya,
    I would model this as a quote-to-order process with a light customization, not pure standard BC. Use the Sales Quote as the customer-facing document, create one or more Purchase Quotes for the vendor RFQs, and link them back to the Sales Quote/Line using a custom field like Source Sales Quote No. / Line No. or a small custom “RFQ comparison” table. Standard BC supports sales quotes and purchase quotes, but it does not give a clean out-of-the-box “multiple vendor RFQs linked to one sales quote line with best-price selection” flow. For custom products, consider using Nonstock/Catalog Items or create the Item only when the quote is won, depending on how much history/reuse you need. Capture estimated vendor cost, landed/other COGS, accrual assumptions, margin %, and selected vendor on the sales quote line/custom table, then copy those fields forward when making the Sales Order so users do not re-enter them. Once the vendor is selected, convert the accepted Purchase Quote to a Purchase Order and keep the linkage for traceability. 
     Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,496 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 961 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 870 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans