From a recent email:
Our client needs to extract data from a variety of Dynamics GP payroll tables into a couple of files to send to their new 401 plan administrator. The required files need to be in a fixed-width file format. I have been thinking about possible tools that could do this job, such as SmartLists, SmartLists Builder, GP Report Writer, or perhaps a SQL view.
Your thoughts?
I’ve done this in the past several ways. Crystal would be the easiest – create one field that that has all the data, powered by a stored procedure. Then export the report to a text file.
Another possibility would be just to export the data directly from a stored procedure, either via cut and paste from the query window or by running a task that will create a text file; but those options are more techincal. If you create a Crystal report, any end user can do it.