Topic Options
#7324 - 08/08/06 02:57 PM Change items fr OE to IC
Victor B. Offline
Adagio Scholar

Registered: 05/07/06
Posts: 97
Loc: Toronto, ON, Canada
Hi All,
I inherited ACCPAC with items set up in OE (Item 9 characters long). I converted ACCPAC to Adagio and want to activate IC (IC was not in use), increase inventory item length to 16 characters. Can this be done? If yes, how? We are using GL,OE,IC,AP,AR,PO (non MC company, lataest sp are installed).
Thank you.
Victor

Top
#7325 - 08/08/06 06:57 PM Re: Change items fr OE to IC
Douglas Dickie Online   content
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
One option would be to export the items from OE to a spreadsheet. Remove those data files OE no longer requires (search this form for a thread on how to do this). Setup an new IC with a 16 character item number. Modify the export items to make them 16 characters and import to the new IC database.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#7326 - 08/08/06 09:28 PM Re: Change items fr OE to IC
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4510
Loc: Wynnewood, PA
Doug's suggestion is not for the faint of heart.

There used to be an ACCPAC addon (it may still be for sale) that allowed for item number format change. You could run it on your data, but you will lose information that exists in Adagio but not ACCPAC, such as item notes and OE invoice history. If you are using IC 8.0B and not 6.8A or 8.0A, you would also lose item history. But it's worth considering.

You may want to get to know an Adagio consultant in your area. They could help you decide on a plan.

Top
#7327 - 08/08/06 10:54 PM Re: Change items fr OE to IC
Victor B. Offline
Adagio Scholar

Registered: 05/07/06
Posts: 97
Loc: Toronto, ON, Canada
Thank you gentlemen,

I am not afraid to loose the items in OE (not to many of them) and export -import option would be good solution. However, keeping the invoice history is important. We are using IC 8.0A.
Is additional information can help to find compromised solution?

Thanks again
Victor

Top
#7328 - 08/09/06 08:06 PM Re: Change items fr OE to IC
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4510
Loc: Wynnewood, PA
Sorry for repeating myself.

You may want to get to know an Adagio consultant in your area. They could help you decide on a plan.

What you are attempting to do is complicated and unique to your company. You need someone who can explain the pros and cons as it applies to your company. Unfortunately for you, that will probably cost money.

You could also contact a data repair service (Softrak itself offers the service). They can give you a quote for performing the conversion for you.


Edited by Steve Schwartz (08/09/06 08:07 PM)

Top
#7329 - 08/09/06 10:13 PM Re: Change items fr OE to IC
Douglas Dickie Online   content
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
What you need is someone to do a Item Format change for you. There is no utility for Adagio that does this. We did an Item format change for one of my clients earlier this year. If I recall the total cost was somewhere around $1400 (Canadian). We would be happy to provide you with the same service.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Douglas Dickie), 73 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70649 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30