How do I renumber "Dimension Value ID" field in Dimension Value table ( NAV 2017)

ssmukhi

Hello, I entered some values in the Dimension Value Table. This created Dimension Value IDs since it is an autoincrement field. After discussing with our Accounting Manager, we decided to revise the Dimension Values since no data had been entered yet anyway. I deleted the dimension values and entered new ones. However, the Dimension Value ID autoincremented from the last Dimension Value entered even though that no longer exists. Example, I entered 10 Dimension Values, so now the Dimension Value ID is 10. I deleted the 10, so when I enter Dimension Values, the Dimension Value ID is 11. How do I get it to reset to 1 or to renumber them consecutively? Remember this is a fresh database so no transactions have been entered yet.

Juhl

Dont care about the id. Its for internal use.
It dosent matter!

You can reset it from sql or remove autoincrement property, compile and set it again on the table.
But never do this to a table with data in it.

Or make a copy of the company.

But again it doesn’t matter!!

Juhl

Dont care about the id. Its for internal use.
It dosent matter!

You can reset it from sql or remove autoincrement property, compile and set it again on the table.
But never do this to a table with data in it.

Or make a copy of the company.

But again it doesn’t matter!!

ssmukhi

Thanks for your reply.