Recalculate lines..

yuppicide

Nav 3.10:

We had a problem where we were getting ready for our 2009 line of clothing. We created the item cards in Navision, for example one item had a price of $23. We entered some orders, but later on changed the price to $21.

Is there a way to recalculate lines on an order? Otherwise we have to go through every order to find the wrong prices. The only thing I could think to do was to create a new order with the same header, copy the document with recalculate lines checked off, go back to the original order and delete the lines and then copy the new document to it.. this way we can keep the same Sales Order number.

vijayanderson

Technical person has to run process report to update the price in each order

Regards,
Vijay

Savatage

or if your careful [-o<

run the sales line table from designer. filter the item # in question
then you'll be able to see all the lines & their prices. You can filter OUT the correct price & remaining are the sales line with the wrong prices. then just change them right down the list.

If this is something that happens alot you might want to think about creating a New SALES LINE REVIEW FORM or something add it to a function of the sales order form.

DaveT

Hi,

You can acheive this which a simple (but powerful) report. Loop through the sales line (filter as required) and validate either the No. or Quantity. Be careful as if a sales price does not exist then the sales line price can validate to zero. This is the same as going into each order and overtyping the No./Quantity.

Savatage

yuppicide wrote:

The only thing I could think to do was to create a new order with the same header, copy the document with recalculate lines checked off, go back to the original order and delete the lines and then copy the new document to it.. this way we can keep the same Sales Order number.

as I re-read...actually you could have just added the item again to the same order, bringing up the correct price and delete the sales line with the wrong price.

but a sales line form that lists all the items (editable) that you can filter on all in one shot, then change 1 price & F8 all the way down works too.