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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Discount incorrect
Microsoft Dynamics CRM (Archived)

Discount incorrect

(0) ShareShare
ReportReport
Posted on by John Bock 1,375

We had a partner set up some products so we could show different type of discounts on line items on a quote.

We enter the Unit as the default Primary Unit.
Quantity of 1
and the Manual Discount Amount

An example is we enter a qty of 1 and a manual discount amount of $100.00.  After saving and closing it shows that line item as having a $2.00 Price Per Unit a quantity of 1 and an extended amount of ($98.00)  In order for us to have this come out as $100.00 discount we have to enter a manual discount of $102.00.  And it shows the $2.00 price per unit on the quote.

I have looked everywhere that I'm familiar with and can't find anywhere the $2.00 price per unit or why it's doing what it is doing.

Thanks,

John

*This post is locked for comments

I have the same question (0)
  • Neil Benson Profile Picture
    Neil Benson 7,369 User Group Leader on at

    A product appears on a price list as a price list item, and it's the price list item that gets added to the quote (as a quote product). So the $2 unit price of the quote product is configured on the price list item -- you'll need to look in the relevant price list to find the price list item and adjust the price to $0.

    Regards, Neil

  • John Bock Profile Picture
    John Bock 1,375 on at

    I can't seem to figure out how to paste a print screen here.

    I've gone to the only price list we have, looking at the price list item the amount under the pricing section is 0.00.

    Any other thoughts?

    Thanks,

    John

  • Neil Benson Profile Picture
    Neil Benson 7,369 User Group Leader on at

    If the price of the Price List Item for this product on all price lists is $0, and the are no Discount Lists then there could be some JavaScript on the Quote Product form?

    Neil

  • John Bock Profile Picture
    John Bock 1,375 on at

     Not seeing any JavaScript on the form either.

  • Miguel Domingos Profile Picture
    Miguel Domingos 1,200 on at

    Maybe thats a database inconsistency.

    Try to run this script in your database and modify it to only list your quote by name. If you get a total price of 2 for your quote is because there is a product linein the database that isn't being shown and in that case you have to decide what do you want to do with that product line.

    select quoteDetailBase.quoteid, sum(quoteDetailExtensionBase.oni_rc) as oni_rc,

    sum(quoteDetailExtensionBase.oni_tcvrc) as oni_tcvrc,

    sum(quoteDetailBase.tax) as oni_nrc,

    sum(quoteDetailExtensionBase.oni_tcv) as oni_tcv

    into #tmp1

    from quoteDetailBase

    inner join quoteDetailExtensionBase on quoteDetailBase.quotedetailid = quoteDetailExtensionBase.quotedetailid

    inner join quoteBase on quoteBase.quoteid = quoteDetailBase.quoteid

    group by quoteDetailBase.quoteid

     

    select

    quoteextensionbase.quoteid,quotebase.name,

    quoteextensionbase.oni_rc as oni_rc,

    quoteextensionbase.oni_tcvrc as oni_tcvrc,

    quoteextensionbase.oni_nrc as oni_nrc,

    quoteextensionbase.oni_tcv as oni_tcv,'',

    #tmp1.oni_rc as rcsum,

    #tmp1.oni_tcvrc as tcvrcsum,

    #tmp1.oni_nrc as nrcsum,

    #tmp1.oni_tcv as tcvsum

    from #tmp1

    inner join quoteextensionbase on #tmp1.quoteid = quoteextensionbase.quoteid

    inner join quotebase on quotebase.quoteid = quoteextensionbase.quoteid

    where (quoteextensionbase.oni_rc <> #tmp1.oni_rc )

    or (quoteextensionbase.oni_tcvrc <> #tmp1.oni_tcvrc)

    or (quoteextensionbase.oni_nrc <> #tmp1.oni_nrc)

    or (quoteextensionbase.oni_tcv <> #tmp1.oni_tcv)

    drop table #tmp1

    go
  • Miguel Domingos Profile Picture
    Miguel Domingos 1,200 on at

    Maybe thats a database inconsistency.

    Try to run this script in your database and modify it to only list your quote by name. If you get a total price of 2 for your quote is because there is a product linein the database that isn't being shown and in that case you have to decide what do you want to do with that product line.

    select quoteDetailBase.quoteid, sum(quoteDetailBase.priceperunit) as priceperunit

    into #tmp1

    from quoteDetailBase

    inner join quoteDetailExtensionBase on quoteDetailBase.quotedetailid = quoteDetailExtensionBase.quotedetailid

    inner join quoteBase on quoteBase.quoteid = quoteDetailBase.quoteid

    group by quoteDetailBase.quoteid

     

    select

    quoteextensionbase.quoteid,quotebase.name,

    quotebase.priceperunit as priceperunit,

    #tmp1.priceprunit as priceperunitsum

    from #tmp1

    inner join quoteextensionbase on #tmp1.quoteid = quoteextensionbase.quoteid

    inner join quotebase on quotebase.quoteid = quoteextensionbase.quoteid

    where (quotebase.priceperunit <> #tmp1.priceperunit )

     

    drop table #tmp1

    go
  • Miguel Domingos Profile Picture
    Miguel Domingos 1,200 on at

    try the script on my second reply. the first one was submited by accident.

  • John Bock Profile Picture
    John Bock 1,375 on at

     Miguel,

     Thanks for the suggestions, although I'm not sure I understand it when I try to run you're first query I receive the following errors

    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'oni_rc'.
    Msg 207, Level 16, State 1, Line 3
    Invalid column name 'oni_tcvrc'.
    Msg 207, Level 16, State 1, Line 7
    Invalid column name 'oni_tcv'.

    When I run the second query I receive the following error as I only have access to the views.

    Msg 229, Level 14, State 5, Line 1
    The SELECT permission was denied on the object 'QuoteBase', database 'IBS_MSCRM', schema 'dbo'.
    Msg 208, Level 16, State 0, Line 13
    Invalid object name '#tmp1'.
     

    Thanks,
    John

  • John Bock Profile Picture
    John Bock 1,375 on at

     Even logged in as the SA account I receive the permission denied error using your most recent query suggestion.

    John

  • Miguel Domingos Profile Picture
    Miguel Domingos 1,200 on at

    As I said before use the script in my second reply not the script in the first reply. The scripts are different!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans