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) / SOP Order markdown - P...
Microsoft Dynamics GP (Archived)

SOP Order markdown - Prorate when transferring to invoice

(0) ShareShare
ReportReport
Posted on by Deepesh 65

If we have a discount entered as a markdown on a sales order how can we prorate it based on qty, when the order is transferred to an order. Currently in GP, say we have entered $50 as a discount on a line with a qty of 10. If we fulfill and transfer that line to 3 invoices of say 5, 3 and 2 qty. GP transfers the whole $50 to each invoice. So if the order was to give $50 discount on 10 qty, we end up gving $150 discount for the same qty. This looks like a bug. Does anyone know if GP can do this differently/correctly.

 

 

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    That's not how it works for me so I'm curious as to what field we are actually discussing here. 

    If I enter a line item on an Order in SOP Entry, quantity 10, unit price $100, discount $5 (the field is called Markdown in US) and transfer 5, I will invoice for $975, the discount calculating on the 5 transferred not on the 10 on the line.

    If you are talking about the Trade Discount field under the scrolling window then that will not pro-rate but instead transfer all at once, but it will not continue to transfer on the next invoice and so on...  I hardly ever see this field used as the accounting behind it is quite primitive but it also does not act as you are describing.

    I'm curious as to what you are doing as for me, it works like you want it to as far as I can see.

     

     

     

  • Deepesh Profile Picture
    Deepesh 65 on at

    You are right. It does calculate correctly. I double checked and the user was not looking at the extended price and its calculation.

    Thanks

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