Hello, I have a client that I am moving from Small Business Financials 9.0 to Dynamics GP Version 10. I have perfromed a test upgrade of there data and the customer has come back to me with one main feature that SBF has that GP does not.
My client exports out their GL Trial Balance (General Ledger) to Excel for their Auditors to review. I first showed the client that they could export that report to file saving it as a Comma Delimited file but they did not like the fact that it lost formatting.
My second step was to show them the SSRS Export to Excel. They like this format better but do not like the fact that all data in this report is exported out in a Text format. The SBF report exports out dates and formulas in its spreadsheet.
At this point, I am searching for other alternatives. Can the SSRS General Ledger report be modified to export out formulas? Should I be looking at creating a Trial Balance Report in FRx and exporting it out in formatted Excel?
One last question. In the GP Origianl Reports List there are 7 Reports that start with Excel. Four of these reports are GL Trial Balance Reports. In the window to modify these reports there are specific cell references. What are these reports and is there a way to use them in GP?
Any help will be greatly appreciated.
*This post is locked for comments
I have the same question (0)
