🚀 go-pugleaf

Chris LeBlanc wrote:
> In the past duplicate inventory items were entered into quickbooks,
> using different variations of names.
> Quickbooks says I can't delete inventory items if they are used within
> transactions, unless I manually change those transactions.
> This dates back to early 1996, so manually changing these is not really
> an option.

There's a fairly simple solution.  For each of your inventory items,
decide which of the multiple variations is the one you want to use. 
Open the ITEM list, double-click an item that you DON'T want (or click
once and click EDIT at the bottom of the window).  Then change the name
of this item that you DON'T want to the exact name of the item that you
DO want.  QB will ask if you want to MERGE the 2 items; say "YES".  All
references to the "old" item will be converted to the correct
description.  Repeat as needed.

The same technique works for customers, vendors, and GL accounts.

-- 
Vernon (Vern) Paige
Paige@CanadaMail.com

Chris - 
In v.5 - If 4 will not work I am sure someone will correct me.

The number of transactions may not be as great as you think. Take a look
at the item report in inventory. Repair the short list to match the long
list and you can delete the 'short list' name. This of course only works
if the long list item name is not too bad.

I went through it with a Quicken file. Once the name is not in use you
can delete it.  Sometimes it takes a couple of double checks to get
every instance where you used the Wrong one.

Even an afternoon spent cleaning is better than recreating and
export/importing data. 
Good Luck
Sue
Chris LeBlanc wrote:
> 
> Hi folks,
> 
> I was hoping someone could help me get around a long a tedious task.
> 
> PROBLEM :
> In the past duplicate inventory items were entered into quickbooks,
> using different variations of names.
> The variations were used in different invoices/PO's.
> Now we have a really messed up Inventory list.
> 
> Quickbooks says I can't delete inventory items if they are used within
> transactions, unless I manually change those transactions.
> 
> This dates back to early 1996, so manually changing these is not really
> an option.
> 
> WHAT I NEED!
> 
> I need to know if there is a way around this, if so how.
> Should I close my current company profile, start a new company profile
> and proceed to import my data files?  In which case I could delete
> unused items?
> 
> I'm not really that familiar with the actual accounting process.  How
> would a change like this effect the overall picture with all the
> different accounts?
> 
> Well I hope someone out there can help me because I would hate to see
> myself manually editing thousands of Invoices/PO's just to get the
> inventory back in line.
> 
> Thanks in advance
> 
> Chris
> Please respond by e-mail
> 
> --
> Chris LeBlanc ---------- Home : (613)723-3426
> 28 Inverness Ave ------ Work : (613)829-6597
> Nepean, ON
> K2E 6N7
> 
> E-mail : cleblanc@doncaster.on.ca
> Home   : Http://doncaster.on.ca/%7Ecleblanc/website/main.html