Hello there!
Currently we use PMM for our MM Suites, and Lawson for GL. As it stands we are generating 5 monthly reports that show Receipt Accruals, Invoice Distribution, Issues Summary(stock items), GL Transactions, & Reconciliation. These go the acct user as a .CSV which is then uploaded to Access, and finally displayed in Excel using embedded Macros and Formula. There are 5 tabs, and each sheet represents the above mentioned reports.

We would like to automate this process. I am thinking of using Crystal to link the PMM dbases with Lawson in one giant report with the parameters needed. Has anyone had experience in using multiple data sources to produce one output? Data Warehouse'ing? I am interested to hear the struggles, or concerns...

I would like to publish this on Crystal Enterprise. We are currently running Lawson / UNIX / v8.03