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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Calculation on Sales Q...
Small and medium business | Business Central, N...
Suggested Answer

Calculation on Sales Quote based on Purchase Quote

(0) ShareShare
ReportReport
Posted on by hkusulja 50

Hello, I am new to BC and now using SaaS with v20.

Is it possible somehow to connect purchase quote (from vendor) with sales quote (to customer) with line items?

In the business of reselling, it is needed to be connected to show the same items / quantities, but to also have "deal calculation", based on "sales price" and "cost price".

If not, I may want to manually enter the sales price on the sales quote, but also the cost price on sales quote. However, after showing the "cost price" on sales quote, it is read only, so I cannot have simple profit calculation on per line item basis, nor per whole sales document (deal) document.

Any suggestions for using fast "calculations" with purchase and sales prices in BC? or should I revert manually to doing it simple in excel? I am trying to move this info also to ERP / BC.

Thank you

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hrvoje,

    The Purchase Quote and Sales Quote documents are not linked. Purchase Order and Sales Order can be linked for Drop Shipments, Special Orders, or applying a Reservation.

    You can reflect on the Sales Line the Unit Cost of the Item, though non-editable. You could open the Statistics page to show Gross Profit. If you are trying to link a Purchase Quote specifically, then I would contact your Partner who can write an extension to add this custom link and related information.

    Hope this helps.

    Thanks,

    Steve

  • hkusulja Profile Picture
    hkusulja 50 on at

    Thank you for reply.

    In my case, probably making "cost" field on sales quote > line item as visible and editable would be enough.

    How to make "cost" field editable on sales quote line items?

    From where does the value comes from and how it is used on sales quote?

    Thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hrvoje,

    I am not a developer but you will need to ask a developer to assist to make the field editable on the page. Also, the value of any Items Cost that appear on a Sales Document, pulls from the Unit Cost field on the Item Card. This should be valid since it is being updated continuously. I would consider playing in CRONUS the Quote process and then decide. I have never had to expose the Unit Cost field and would not recommend it, when creating a quote since the Unit Cost on a quote is temporary, depending on the Costing Method of the Item (unless Standard Cost).

    Hope this helps.

    Thanks,

    Steve

  • hkusulja Profile Picture
    hkusulja 50 on at

    This info sales quote - line item (sales price, cost price) is not enough from Item card, and needs to be manually entered directly on the sales quote.

    So, my case is creating a custom (inline) directly on Sales Quote with manually written sales price and cost price for having fast profit calculation (per line item basis) and total one.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans