Sage 100

Customer imported a number of incorrect Alias items (not sure if they are general, customer, vendor) and now wants to get rid of them. Short of DFDM and/or manual deletion is there any other trick (or catch) that I'm overlooking. I'm aware that I most likely could export the entire alias file, manually remove the problem records, reimport. Or at least I think I can. Am I overlooking anything else?

Export, scrub, reinitialize, and reimport was going to be my suggestion. Unfortunatley VI has no functionality for removing records, and there is no delete/renumber/purge utility for item aliases.

If there are a lot of rows you want to clear, I would; 1) Extract all rows from IM_AliasItem into an Excel worksheet, 2) Backup and then Initialize the IM_AliasItem file, 3) Trim the list of Alias records in Excel to what you want, 4) Import the Alias items via VI.

Thanks - that's along the lines of what I was thinking.

This is one area in which Sage Premium comes in handy. You could simply go into SQL Server Management Studio, open the table, and delete the line you wanted; either through a script of one row at a time like you do in Excel.

Could you import a blank record for the incorrect items? I think this has worked for me in other imports.