Does anyone know how to change (Qty Shipped Out Invoiced) field to zero. In the sales line table normally this field should be zero, but when we have backup orders, this field is filled with numbers. But that's the probelm, we cannot delete the sales order because of this. Any idea? Appreciate it!
0
Comments
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
invoice the order from Sales Order granule itself.
Senior Consultan
It does not matter whether you invoice directly from the sales order or you use the "get receipt line" function in the invoice form, the quantity in the sales order is always updated.
Have you customized anything in the sale order or sale posting routine?? We faced the similar problem due to wrong coding.
http://ssdynamics.co.in
In that case the system leaves the order in there. So you either change the qty to 7 before invoicing or otherwise you go in after and delete the order manually.
I appolgize but I should have asked the same questions I do with my clients:
1. Did you invoice everything you shipped? If so then Shipped Not Invoiced should be zero.
2. Assuming 1 is correct and the order is still there then when you try to manually delete it what is the EXACT error message you are getting?
Admnistration --> It Administrations --> Data Deletion --> Sales Documents --> delete invoiced sales orders
it is report 299
Do you have delete permissions?
However I would think that in reality there is a line on the order where there is a quantity outstanding. How many lines do you have. What is the quantity on each and what is the invoiced quantity on each? Any difference?
We do have one field callled Qty. Outstanding and the it is zero.
When I tried to delete the order, the error from the syste says: Qty shipped not invoiced must be zero in sales line document type='Order' Document no=xxxxxx, line no=xxxxx