Sage 100

What do any of you use for extracting GL balances from Peachtree for importing into MAS (conversion)? Not seeing anything useful in the standard or Crystal reports available.

Just the ending balances? I believe the last Peachtree conversion I did, they previewed trial balance, then were able to export the report to Excel.

So you just did that 12+ times, and had to figure the difference yourself? I'm trying to get last year so they can do a comparative if they want.

I thought there was a spoke on the data migrator to export peachtree. But it all depends on the version

Then I am confused on your end game. I thought you wanted ending/beginning balances for ONE journal entry. For my last Peachtree conversion, They were able to generate a report with all the transactions for the year. We then exported that report into Excel. I cleaned up the JE's, ensured that they netted to zero, then imported into GJ entry using VI with VI changing the JE # when appropriate. Had a lot of lines, but all the monthly balances populated properly.

I get confused on my end game sometimes, too. I found a report I modified that I think will work, with some cleanup in Excel.

Isn't data migrator just another name for VI? What exactly is the value of data migrator? What can it do better (more) than just Excel and VI? Call me DM clueless.

It is the extraction of data that data migratory is good for. Totally agree that VI is the way to import