Sage 100

Random web visitor asks: Is there a way to speed up the Sage renumber of inventory items using the utility? We have a large number and need to renumber them all and it's going to take longer than we can afford to be down for. I'm asking if they are on premium but even that may not guarantee a fast renumber. I don't think this could be done with pure SQL because of all the related tables. Anyone tackle something similar?

I've always processed them in batches of about 50. For one particular customer (Premium, if it matters) I ran tests, and the further into the list, the slower per item code it became. Also, the renumber screen has crashed on me when trying to renumber a big list. Smaller batches are my routine now. When asked about SQL magic doing the renumbering, I refused. I'd not risk missing the dot on an i or omit crossing a t (with manual SQL changes). If something goes wrong with the Sage utility, I can blame them.

It's does take a while to renumber. Suggest they break the project up into to multiple phases.

(And for Premium I switch the company database to Simple recovery model temporarily, then back to Full after processing... so the SQL log file does not grow to an insane size).

We have started the process on a weekend and revisit it. Of course not all clients are down for the weekend.

I'm currently working on a renumber of 1000 items. I'm going to start it after hours on Friday. On my system it took 7.5 hours.

@MicheleHerzog , never counted it out, but that sounds about right. I always try to be on the server when I run it to help keep that number down.

One of our customers has 40,000 inventory items. When a major vendor decides to change parts numbers, the customer has 3,000 to 5,000 items to change, so they can update standard prices from a spreadsheet. We recommend using Alias part numbers but this gets messy and confusing over time. Even with a bar code system Alias part numbers are difficult to manage. QuickBooks uses an internal inventoryKey (like the G/L AccountKey in Sage) and the renumber process is quick. With Sage 100 - 50 items per group is painful. I would like to hear a good alternative.

For that, UDF in CI_Item for the vendor's item #, then a vlookup to bring in the Sage item code. Import from there. Avoid the renumbering.

Sounds like one of my clients. They are in the process of renumbering a slew of items right now. Their company data folder is 45GB and it takes 2-3 hours to renumber just 5 items done on the server. They have JobOps also so it has to go into configurator and they are a heavy user of that. Just moved them to v2018 ADV from v2016 STD.