Publicado Fri, 25 Jan 2019 13:00:37 GMT por John DeLaat

I created a PO Form that uses automatic numbering, after testing and verifying everything works ok, the customer want to reset the automatic numbering to a value, I go into the dialog but the values are greyed out for start value and next value.  Where do I change this?

Publicado Fri, 25 Jan 2019 14:26:48 GMT por Josef Zayats

John, if you have DW Premise AND are familar with MSQQL data manipiulation, below is a way to reset Automatyic Numbering, otherwise your only choice is to create a different numbering group and re-assign it to all dialogs as required.

Here is how you change Automatic numbering in MSSQL:

1. Find out the value of the Automatic NumberingGroup SettingID - this is column setid in table dwsystem.dbo.DWFCSettings - just search the table for name=yourAutoNumberingGroup name and find out corresponding setid

2, Search table dwsystem.dbo.DWSequence for column settingsid=setid found in step1 and change value of column nextNumber for the row.to a desired number

That will reset the next number.

Publicado Fri, 25 Jan 2019 15:00:46 GMT por John DeLaat

Thanks Josef!

You must be signed in to post in this forum.