My VAT return report is not able to export in Excel, giving the error - Exception of type- 'System.OutofMemoryException' was thrown
Even Nominal code transaction reports also give the same error.
Is it an issue because of the sage data size?
My database has 55366 invoices.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
sage data size
-
brucedenney
- Site Admin
- Posts: 4656
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: sage data size
It is a memory error, using the 64bit version of 30.1 would, I expect resolve it.
I find export to excel to be very handy with small amounts of data, but with large amounts it is very very slow.
You might find it easier/faster to save one of the printable reports as csv/xls and open that.
I find export to excel to be very handy with small amounts of data, but with large amounts it is very very slow.
You might find it easier/faster to save one of the printable reports as csv/xls and open that.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: sage data size
I have version 29, 64 Bit
Could you please explain how I can save printable reports as csv/xls and open that?
Could you please explain how I can save printable reports as csv/xls and open that?
-
brucedenney
- Site Admin
- Posts: 4656
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: sage data size
There is no 64 bit version of Sage until V30
Go to the vat return you want to send to excel
Click on the print button in the bottom left
Select the report that has the data you want to get into excel.
Choose output to file
Press Run
Choose the format you want to save in csv/excel
open the file saved in excel.
Go to the vat return you want to send to excel
Click on the print button in the bottom left
Select the report that has the data you want to get into excel.
Choose output to file
Press Run
Choose the format you want to save in csv/excel
open the file saved in excel.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: sage data size
After press run, it is not giving option to choose the format. It is directly saving in .htm format.
-
brucedenney
- Site Admin
- Posts: 4656
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: sage data size
The default is html but there is a drop down to select other formats, this is the same for all reports.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: sage data size
For me I am not getting option to change format.
Login to access the files attached to this post.
-
brucedenney
- Site Admin
- Posts: 4656
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: sage data size
That windows appears not to have rendered correctly, suggests and issue with Windows
I wonder what that artefact does when you click on it (circled in Red)
I wonder what that artefact does when you click on it (circled in Red)
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: sage data size
When I click nothing is showing.
Re: sage data size
I have tried with other PC where I can get option for excel but getting error for data source.
Login to access the files attached to this post.
-
brucedenney
- Site Admin
- Posts: 4656
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: sage data size
I suggest you contact support, it appears Sage is not operating correctly.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Google [Bot] and 3 guests