Global Update / Rename

madm

I wish to extend prices in our Item Price Table. In order to set an ending date, we use this table by putting in a starting date with price, followed by another starting date at 0 - this then flags up when entering sales prices up.

We wish to extend our prices, and therefore require to extend the zero prices..

If i was to use the Item Price change batch job, then this would create new prices, which I dont want.

I thought about setting a report up to modify the starting date, however i am having problems doing this, as the report runs through, but does not actually modify..

Could this be due to when we change a starting date, then it RENAMES rather than changes? If so, how would i go about globally updating the starting dates?

Thanks

kriki

You are changing 1 of the primary key fields.
In this case if you do a MODIFY, Navision will give an error saying the record does not exist.
In this case it is better to RENAME the record if this record has other records attached to it (eg. in case of a payment terms and you change the code. In this case everywhere the old code is used, it has to be changed in the new code.
If this is not the case, it is faster to DELETE the old record and INSERT the new record.