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 / 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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans