Hi All,

Please suggest how to import sundry items into PO for Adagio (I have to many of them to key in manualy).

Thank you
Victor

Hello Victor,

How about just adding them on the fly when you want to place them on a PO? They'll all get added eventually.

Unless the program provides an import, there's no other way to get the data into its database. I guess you might be able to use some kind of Windows macro program to load the data, but that would probably take longer than just keying the items.

Where are the sundry items being imported from?

Hi Andrew,

Thank you for the quick response.
We were using Quick Books for raw material and service purchases prior to replacing our ACCPAC Plus with Adagio. It is list of about 2000 items that need to be reorganized using new naming convention, proper vendor info, etc.
Actually it's a good idea using macro. I still have Zippy, but not sure if creating items in IR (ACCPAC) will have integrity issues.
Please advice.


Thank you
Victor

Hi Victor

Having just done exactly this for a client yesterday, I can tell you that you will need access to ACCPAC Plus and Inventory Receipts (DOS), which is database compatible with POA. However, the data will have to have been initially created in IR.

IR has an import function which works well for sundry items. I would recommend creating one sundry item, exporting it with every field checked off, and using it as a template to build an import file. The date formats are tricky, and make sure not to use a quote (") in an item description if you are going to use CSV as your import format.

Actually, I used Zippy Import to import into IR. If you know how to use Zippy Import, it's much easier.

If you didn't create the data in IR (DOS), you can create a new database in IR, using the same item format, import into this new database, and then copy the IRITEM*.xxx files to the POA database.

I can assure you that there are no integrity issues when using IR to import sundry items.

Steve

Hi Steve,

Thank you. Very helpful. I know how to use Zippy Import and that's what i'll do.

Thank you again.
Victor