*This post is locked for comments
Sharon,What Microsoft Dynamics Product are you using?
Microsoft Dynamics GP version 10
I moved this post to the Microsoft Dynamics GP forum. Please let me know if you have any quesitons.
Hi Sharon,
I gave this a try and my Extended Price did change. For example, I put a quantity of 3 in the invoice line. I changed the Billed Quantity to 1, the Qty Fulfilled to 1 and the Qty Canceled to 2. The extended cost reflected only 1 item. Where did I go wrong?
Kind regards,
Leslie
Hi Leslie,
Thanks for your response. We are cancelling quantity before we get to the point of invoicing. Document Type is Order not Invoice. For example, customer has ordered 2, which is entered in the Qty Ordered field. We don't have them in stock, so 2 go to Qty to Back Order field. Customer then cancels quantity of 1. We change Quantity to Back Order to 1 and put 1 to Quantity Canceled. The extended price on the line does not change for us and neither does the subtotal of the Order. I've tried reconciling the sales document, but it didn't update the price on the sales order.
I'm wondering if that is a kink in our system or if that's what it's supposed to do. If that's the intent of the system, I'd like to get some insight as to why.
Thanks for your help!
Sharon
This is the way SOP works. So long as it remains an Order, the extended amount will be the Order amount (2 in your example). When it is transferred to an invoice, only the qty to invoice goes over so you will have an invoice amount of qty 1. Order's aren't posted and cancelled items aren't allocated so the 'books' are not wrong at the Order stage. If the same thing happened on an invoice - The Invoice Qty was 1 and the qty cancelled was 1, the extended price would be $0. If this happened to be the invoice created by transferring our qty 2, cancelled 1 Order, you do not see the originally cancelled item on the invoice.
I hope this helps,
Thanks for the confirmation. I've been getting the question a lot as to why GP doesn't change the extended price for the line and the subtotal on an Order when quantity is cancelled. So I just wanted to make sure it wasn't something that wasn't working correctly in our system. Although the "books" are not wrong, it kind of throws users off that the extended price and subtotal do not change. And yes, I agree when quantity is cancelled on an invoice, it does change the extended price and subtotal. We typically do not cancel items on invoice though since we start with Orders and most of our Invoices are due to transferred Orders.
Thanks,
Sharon,
I'm with you on thinking this is odd behavior. I hope someone will pop in with some obscure setting that I don't know about. We can hope!
Did you ever figure out a way to exclude cancelled items from the order subtotal amount?
unfortunately, there is not a way to exclude the price of cancelled items from the subtotal on an order.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
