Find Out if No. Series are in use ...

elTorito

Exists any way for look if the No. Series in the G/L are in use?
We have a lot of No. Series where i thinks that are not in used. But I'm not sure. I have try Delete No. Series for look if they make an error that could not delete it because are in use, but, alle the No. Series can be delete without ask if are in used or not.

Okay. Its Only a Reference Table. Buit perhaps anybody knows a little Tipp for find it out if are a No Serie in use or not.

Thanks.

Tommy_Schou

Well.. You could look at the No. series and at the fields "Last date used" and "Last No. used". If these are both blank... well.. maybe it hasn't been used!

pdj

Or you could make a small job that goes through all fields related to the no. series table. (Using the system table called "Field")
Then using RecordRef and FieldRef you could check if they are all used.

I guess you should ignore tables that end with Entry - otherwise it would take ages 8)

pdj

Couldn't help it. (Needed a short break :oops: )

Variables:
Name     DataType   Subtype
Field    Record     Field
NoSeries Record     No. Series
RecRef   RecordRef
FldRef   FieldRef

OnRun()
Field.SETRANGE(Field.RelationTableNo,DATABASE::"No. Series");
IF Field.FIND('-') THEN
  REPEAT
    RecRef.OPEN(Field.TableNo);
    IF STRPOS(RecRef.NAME,'Entry') = 0 THEN
      IF RecRef.FIND('-') THEN
        REPEAT
          FldRef := RecRef.FIELD(Field."No.");
          IF NoSeries.GET(FldRef.VALUE) THEN
            NoSeries.MARK(TRUE);
        UNTIL RecRef.NEXT = 0;
  UNTIL Field.NEXT = 0;
MESSAGE('Any record NOT marked is NOT referenced from any field with a table relation to it.');
FORM.RUN(0,NoSeries);

Tommy_Schou

Get back to work dude!

elTorito

Tommy Schou wrote:

Well.. You could look at the No. series and at the fields "Last date used" and "Last No. used". If these are both blank... well.. maybe it hasn't been used!

Hmm Well. But if i Make New Item oder New Vendor ... and Set Manually No. then the Date and LastNr Getted, will don't change.

elTorito

pdj wrote:

Or you could make a small job that goes through all fields related to the no. series table. (Using the system table called "Field")
Then using RecordRef and FieldRef you could check if they are all used.

I guess you should ignore tables that end with Entry - otherwise it would take ages 8)

Hmmpf. ... I can't find System Table "Field" :?: :roll:
What Id's have the System Tables ?

Thanks


Peter

law

You cannot see it in Object Designer. Make a list form on table 2000000041 (Field).

elTorito

law wrote:

You cannot see it in Object Designer. Make a list form on table 2000000041 (Field).

Thanks. Now I'm Trying with the Code from Peter.
I create a new No. Serie but it doesn't seem to Mark it.
But it's a good base, perhaps i must experiment a little bit.

Thanks you.
Peter

pdj

elTorito wrote:

I create a new No. Serie but it doesn't seem to Mark it.

That was the entire point, wasn't it?
The code marks the No. Series that are used. So if you create a new one and don't have used it anywhere it will not be marked.