Change dates in Table 7002

LBinDENMARK

Hi guy´s

I need to change all dates where Startdate = 01-03-12 to 01-04-12, I´ve tried to do a report, but Startdate is a key so Nav won´t allow ;-)

Please guide a little, I´m stock here, maybe it is becource it´s Monday;-)

mohana_cse06

What about Inserting new Lines with 01/04/2012?

LBinDENMARK

A new line is not what I would prefer. I also need to change previus lines Ending Dates, as the "old" price needs to be valid for one more month

mohana_cse06

Use RENAME like

RENAME(
  "Item No.","Sales Type","Sales Code",010412D,
  "Currency Code","Variant Code","Unit of Measure Code","Minimum Quantity");

in Sales Price - OnAfterGetRecord..

Dont forget to filters..