Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Calculation on Sales Quote based on Purchase Quote

(0) ShareShare
ReportReport
Posted on by 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

  • hkusulja Profile Picture
    hkusulja 50 on at
    RE: Calculation on Sales Quote based on Purchase Quote

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculation on Sales Quote based on Purchase Quote

    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
    RE: Calculation on Sales Quote based on Purchase Quote

    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 Microsoft Employee on at
    RE: Calculation on Sales Quote based on Purchase Quote

    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

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans