Customer Number Sequence is off

One of our employees has entered a new customer out of sequence. We did not find this out right away, so we have 3 additional new customers that have also been entered. We have customer orders, Shipments and Invoices against at least 1 of them. Is there any way to delete all of this data and go back to the correct sequence? I can fix the customers/orders that have no activity, but I am not sure how to fix the customer/order that has already been invoiced?Last Good Customer# 3442

Incorrect Customer#s:

4570 (CO#425.1946) - Shipped/Invoiced

4571 (CO#425.2052)4572 (CO#425.2111)

4573 (CO#425.2200)

Please advise if there is a way to delete these customers and go back using customer#3443?

Find more posts tagged with

Accepted answers

All comments

Jim Seiler

In my opinion, do not attempt a manual renumbering for a handful of customers. There is no systemic reason for concern. Is there a business process that is broken by the gap? If you need to fill the gap, try adding new customers using those "gap" numbers. Syteline does not care if there are gaps in numbering. Because we have been bought and sold twice in the last few years, we have a variety of customer numbers. The Customer number is just a unique identifier. As a matter of course, we avoid "smart" numbering systems in our shop. For us, it's a database philosophy.

However, you can check if your version of Syteline has a customer renumbering utility or search the Infor Knowledge Base for "renumber utility" or script. You may get lucky.

I have performed manual renumbering in SL ver 7.x (on-prem), across 12 sites, to fix an issue with integration with a new parent company's ERP, and I found cust_num in 500+ tables and changing it runs up against table constraints in nearly all of those tables. In my opinion, if you are not careful, you could "brick" Syteline — a very risky move.000000000000000000000000000000000000000000000000000

On our on-prem, 9.xx, installation, I found 536 tables with some form of cust_num columns using this query:

use master_App;
select TABLE_NAME,count(*) [Columns]
from information_Schema.COLUMNS
where column_name like '%cust%num%' or column_name like '%cust%no%'
Group by table_name
Order by table_namecust_num.

YMMV, but that's a lot, plus that does not include the ref_num/ref_no fields that may contain a

gnathan

We are On-Cloud and I have no access to a Sql Server. Thanks Jim. But need another solution.

Jim Seiler

Ok, understood. Perhaps, as I suggested, look through the knowledge base to see if there is a built-in utility or screen for the Cloud solution. Or put in an Infor ticket and ask if there is a reason to worry about the "gaps". Or try (in a pilot environment) backfilling the gaps with new customers. Why are contiguous customer numbers important to you? Syteline obviously isn't trying to control for that because it "let" your user do it, so there must not be controls on the screen, and there are no triggers or constraints to prevent it.

gnathan

Hi Jim, I have put in a ticket for this. The gap doesn't bother me, but my manager tried in Training to create one with a gap. The system creates these numbers automatically, so if we created the next number after the last good one, the system still thinks the last high number is the one it has to increment. This forces the lower numbers to be put in manually every time and since there are multiple users and there might be an issue. Thanks. Hope I tried to make some sense. :)

Jim Seiler

Totally makes sense. I do so much with SQL, on-prem, that I forget some of the challenges (and benefits!) with Cloud. Good luck!

gnathan

Thanks Jim.

Copyright © 2025 Infor. All rights reserved.