We have several individual companies in SAGE. I would like to export the general ledger detail from each company, at once, into one large excel file. Currently, I go into each company and export the data manually and it is very time consuming.
Is…
I want to take different reports and export them as live updating .csv file or other Excel compatible format. For example, there is a report at IC > Reports > On Hand Detail Report. I would like to be able to save a copy of the file locally to open with…
I need some help here. I have a Crystal report that contains a sub-report with a date field. My goal is to export the report from X3, go to Excel then to a pivot table and use this date field as a major sorting point. My issue is the date field (from…
When I export a report to excel, if the details of the report are not very long then the footer of the Report Form shows up in the middle of the data and overwrites the line.
If there is a lot of data, then I get three blank lines in the middle of the…
I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report.
Any & all help is greatly…
Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages .
As soon they click on export button the following error is received. generally user tends to run the…
I'm using Excel 2016, and just upgraded to Sage 50 Pro Accounting 2016 because the Sage sales guy said that it was compatible with Excel 2016. However, when doing "Open in Excel", it only shows the option of Excel 97 - 2007. After saving this .xls file…
Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled.
Thanks for your help!