Combine a Dimension Code Value

rsfairbanks

Hello,

We have 2 dimension 1 code values that are essentially the same, and users are getting confused over which to use. We cannot block one as it prevents the item cost adjust report from running.

Are there any problems if we delete one value, and then rename the other as that one. i.e delete VAL1, then remane VAL2 as VAL1.

Regards


Any comments as to whether the proposed solution would work?

Marije_Brummel

Sorry, it does not work that way. If you delete a dimension value, the default dimensions are deleted.

What you can try to do is:

1. Export table 349 Dimension Value
2. Remove the code in the OnDelete Trigger of that table
3. Perform the rename action
4. Restore the table
5. Test the database

This sould be done in a test database first and I give to warranty.

Suc6.

Mark

rsfairbanks

Mark,

Thanks for that, but can I not delete the value with DELETE(FALSE) so it does not run the trigger?


Regards
Richard

Marije_Brummel

Yes you can if you program a report or a codeunit.

Please set the right filters or you will be deleting all dimension values.

Greetsz,

Marq