Excel Item Import

Mar 05, 2006 1 Replies

Rate this thread:

Chico 20 years ago

Using 2006 Premier for Wholesale. I am trying to convert 1000 items I have in the items file to be a subitem of GN. I exported the items file to excel did a concatenate and added the prefix of GN: to the items names to make them subitems and imported back into QB. They imported fine as subitems but the original item number still remains. How do we get rid of this original item number?

Thanks, Chico

Vote

Mike Block - Tax Cut C.P.A. 20 years ago

Turn off the preference to confirm deletes. Then delete the newly added items. The old ones have associated entries so you cannot delete them. Then get something like Number Cruncher to do this.

Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!

formatting link

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required