[rosse Contributions: 0Level 1☆]

We have enabled auto numbering for work orders.

Now we have a need to set the number based on some rules and we set the override checkbox and the script is setting the number correctly.

But now the internal id of the work order is not sequential.

It is jumping by 100's.

Has anyone noticed this issue?

Any work arounds?

I don't see an option to disable auto numbering for transactions.
This is a cached copy. Click here to see the original post.

[khultquist Contributions: 0Level 1☆]

The internalid of the work order should be sequential with all transactions (including Sales Orders, Invoices, etc). Do you mean the tranid?

Maybe post some screenshots of what you are encountering.

[pcutler Contributions: 0Level 1☆]

The auto-generated numbers feature creates an additional numbering schema that is separate from internal IDs. Internal IDs have never been guaranteed to be sequential or even in order (more recently created records are sometimes assigned lower internal IDs).

[rosse Contributions: 0Level 1☆]

Thanks Khultquist & Pcutler!

For us, we have only one type of transaction, so the internal id seems to be sequential.

After enabling auto-numbering feature, setting the tranid by script confuses the system and the internal id becomes random with a big gap in between the generated internal id's.

We were setting tranid for informational purpose and we decided not to set the tranid and use a custom field instead.

This helped to have the internal ids sequential. 🙂

[Author]

Posts