1,970
*This post is locked for comments
unfortunately, there is not a way to exclude the price of cancelled items from the subtotal on an order.
Hi Leslie,
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
Hi 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,
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
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
I moved this post to the Microsoft Dynamics GP forum. Please let me know if you have any quesitons.
Microsoft Dynamics GP version 10
Sharon,
What Microsoft Dynamics Product are you using?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (