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 GP (Archived) / Extended Price
Microsoft Dynamics GP (Archived)

Extended Price

(0) ShareShare
ReportReport
Posted on by Waleed Tibi 1,290

Dear All,

We use trade discount in the sales invoice, is there any way to get the discounted price from the smart list>>sales line items ?. The invoice may contain more than one item.

I have to double check the sales commission which is paid by item, and it will be helpful if i can get the extended price (after the discount).

Thank you

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    You could use the Markdown field on each line? (Instead of the Trade Discount field).

    Other than that you are probably looking at implementing Extended Pricing.

    Ian.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Waleed,

    GP actually stores the trade discount on a line item basis - you can add the column called Trade Discount Amount or Originating Trade Discount Amount to see it.  However, you will need to do the math (Extended Cost - Trade Discount) on your own, as GP does not calculate or store that.  Or, if you have SmartList Builder, you can create a custom SmartList that will do the math for you.  

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 GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans