Exporting from old database and imorting into new database

[troy00]

Hello,

I am setting up a new company/database and I need to export all the AP/AR/GL batches/transactions from the OLD company and then import all the AP/AR/GL batches/transactions into the NEW company.

Additional background info - we are changing our fiscal calendar (was Aug-Jul, will now be Jan-Dec). The new company has the fiscal year in line with calendar year and the old company is fiscal year is not.

I have managed to pull the data from the old company, but cannot get it into the new one. I am sure someone has done this countless time and can offer their assistance as I am definitely missing something to get it to work.

I am running Accpac 5.5 on SQL.

Thanks is advance,

Troy

 

[ramam1]

Are you moving the entire company over or just parts of it?

 

[troy00]

The entire company

 

[ettienne]

You only need to change the GL, the change in fiscal calendar has no effect on AP & AR. I have done this countless times and written a macro to automate the process. What part are you stuck with?

 

[troy00]

I am stuck with getting the data back into the new company, but I believe your macro would also be very helpful. Would it be possible if you could send me a copy - I think would definitely work with what I am trying to accomplish.

Thank you.

 

[ettienne]

For a fee, this is what I do for a living.

 

[troy00]

Ahhh...I see

I will PM you should I get to that point. Until then, I will continue to see if there are other solutions/options available.

 

[Laura717]

Hello Troy,

Our company just went through this last year, including the fiscal change.
I did manage to get everything imported but the A/P,A/R subledgers were the most difficult. I may not have done the most efficient way, but it did work, as follows:

For the GL: Since moving to a calandar year, I decided to leave the detailed transactions in the old company and just bring over the trial balances for each month of the previous year. We were May - April moving over to Jan - Dec. I actually only brought over May - Dec trial balances. I exported them from the old company, changed the year and period in the actual excel export and then imported into the new company. I'll assume you have all of the set-up finished (I actually exported and imported most of the set-up).

For the A/P and A/R subledgers (again all set-up complete): The only way I could get this to work was to export each invoice batch separetly from the old company that still had outstanding invoices/receivables. I then cut and pasted them all into one batch, edited the period and imported the final file back into Accpac. We obviously minimized the number of transactions in anticipation of the changeover. This may not be possible for a company with a larger number of transactions. I chose this method to more easily verify I had the right subledger amounts. note* I posted the subledger batches, but deleted the GL batches since I was bringing over the TB separately.

I was not able to find an easier method for the subledgers.

I hope this was helpful.

Laura

 

[troy00]

Thanks Laura - I was thinking about doing it that way as well. It is very easy to switch between databases should I need previous detailed information.

Although right now, I am playing with a couple of different methods of exporting which include all the details - and so far, it's looking positive. Just have to do some more testing.

Thanks again for your insight. It is much appreciated.

Troy

 

[ettienne]

You don't need to do AP & AR, that's just a waste of time.