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.
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.
You are right. It does calculate correctly. I double checked and the user was not looking at the extended price and its calculation.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13