Is it possible to have item information automatically transfer from one database to another.

I have multiple companies setup but they all carry the same items. I am looking for an easier way to do the item setup rather then enter it into each company.

Only with custom programming, or Export/Import.

 Thanks Jay, I figured as much, was hoping their was a 3rd party app already out there.

From what I understand it is generally not a good idea to write directly to the accpac datatables.

It should just be a simple matter of exporting all records from the item tables and importing them in another, doing the selection based on audtdate and audttime and running it every hour or so.

I do alot of extraction from the tables, but dont do insertions into them.

It's curious that you have multiple companies that need close to real-time synchronization of the items.  Most people are happy with once a week.

 They are retail companies and items come and go on a daily basis. Hourly would be an extreme, but it shoudl be atleast a nightly routine.

Do you see problems with insertions to the item tables?

Absolutely.  You have ICITEM, ICUNIT, ICILOC, ICPRIC, ICPRICD, and maybe a couple others to worry about.  I would write this application to sweep a "master" company for items that had been modified each day, then insert/update in each of the other companies using regular Accpac views.  I/C Items is one place you can't cheat the business logic.   That being said, it shouldn't be a very complex macro to write, you should check with your Accpac business partner.

 Thanks Jay,

I will talk to them and see what they have to say.