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…
Hi,
I am trying to export my sage spreadsheet to excel with the stipulation that all relevant cells populate with the spreadsheet formula as it is set up in the sage spreadsheet (i.e. an item's total amount contains a formula that is the sum of all…
Hello,
We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…
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…
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…
I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…
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…