Edited* 40,000 items!

Are you talking about your current on-hand inventory?  If so, count back to zero, then import inventory receipts to the correct lot #'s (then do a GL entry to offset adjustment to purchases clearing). 

The "how to" for all this is too complex for a forum post.  While they are at it, have your Sage rep add a UDF to the tier entry table (flowing to IM_ItemCost) if you want your notes included.

Thank you for your response, yes current on-hand inventory. I will check with Sage Rep, although he told us there was pretty much no way to get around adjusting out the total inventory on-hand and re-receiving it to be able to assign a new lot number. Which for us, would be an excessively long task. Thanks again

To change the lot number you it is a two step process. First you have to adjust out all the current quantity on hand by lot and then adjust in the correct quantity on hand with the correct lot number. Now it would be easier if the current incorrect generic lot had the correct quantity, then you could first export the Item Costing file to Excel, change the lot number and then use that to import.  If you had a spreadsheet with the item number, lot number and quantity it would be a simple task.

Thank you so much! Excellent suggestion. 

That is what I was suggesting, but it doesn't have to take long. 

• Physical Count is a fast way to get everything to zero. 
• Use a VI import to bring in a receipt / adjustment to create the correct cost tiers (as BigLouie says, using a spreadsheet as the source), then post.  If your spreadsheet has the notes, and you create a UDF in the IM transaction tier table (with correct data flow), that can be brought in too.

Excellent! Makes sense when you break it down like that. It's also something we can do before our go live date as apposed to a scramble afterward. Thank you both for your suggestions and solutions! 

The VI import job can be tricky to set up, and so can the UDF flow, but your Sage Partner should be able to help with both.

Couple of notes, if you use Physical Count to bring everything to zero and the use VI and receipt/adjustment to bring back print out the Daily Transaction Register and see what GL accounts were hit. You might want to make a journal entry to clean things up if the off-set account for each transaction is different. 

Also if you can get the original notes out of Sage 50 and into a spreadsheet you should be able to come up with a formula to extras the data after the word Lot so you can create an import file.

Agreed.  Physical Count uses the IA account, so bringing in the inventory using an IA should offset the entry exactly (as long as the value is the same) but an Inventory Receipt uses Purchase Clearing, so a GL entry is required to fix that up for sure.  I generally recommend avoiding IA transactions whenever possible, but in this case, to create inventory, it might save a step.

Tip: purging zero quantity cost tiers after counting to zero can save some potential headaches later.