I have many item IDs that have been used for years that are incorrect. So there have been many duplicate item IDs or similar item IDs that identify the same item. The only current solution is to inactivate the previous and incorrect item ID and use the new and correct one. However, by doing so, I lose all the history of that item ID. Or at least have to look at the inactive items history instead of the new one if I need to go back and look at the history.
The best solution for this would be to make it so 2 separate item IDs (that both have been used in invoices and p.o's in the past) can be merged. Both historys are combined, but you choose which item ID number to keep and the other one is deleted (but not its history since it is merged). This allows me to keep the amount of item IDs I have in sage down, which actually helps my inventory run much faster and more smoothly. In order for this to work, the item ID that is kept, would have to automotically apply to every invoice, P.O, S/O, etc. that the deleted item ID was attached to. Which is possible in the coding of Sage50.
CAROL badgerbearing@safelink.net
