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
CSV report giving different info to pdf version
CSV report giving different info to pdf version
Hello Bruce
We are running on SAGE 50 v 21.5.9.201
Every month we run aged debtors/creditors analysis detailed report
When we view it on pdf all figures are correct
When we then export it to CSV some of the brought forward balances change
We cannot work out why
Would you be able to shed any light on it please
Thanks
Jim
We are running on SAGE 50 v 21.5.9.201
Every month we run aged debtors/creditors analysis detailed report
When we view it on pdf all figures are correct
When we then export it to CSV some of the brought forward balances change
We cannot work out why
Would you be able to shed any light on it please
Thanks
Jim
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: CSV report giving different info to pdf version
Does this happen if you use the demo data?
Can you give me an example so I can reproduce the issue?
Can you give me an example so I can reproduce the issue?
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: CSV report giving different info to pdf version
Hi Bruce
Our practise SAGE has no info in it so its not easy to replicate in that
Our aged debtors detailed list will be 400+ lines
So there is quite a lot of info
Whats the easiest way for us to share some of this info with you
As mentioned when we run aged debtors in pdf info is all good
When we export to csv on some lines the brought forward is not totalling correctly
Maybe 1 in 10 of the brought forwards are too low
So the final total on csv vs pdf do not balance
Our practise SAGE has no info in it so its not easy to replicate in that
Our aged debtors detailed list will be 400+ lines
So there is quite a lot of info
Whats the easiest way for us to share some of this info with you
As mentioned when we run aged debtors in pdf info is all good
When we export to csv on some lines the brought forward is not totalling correctly
Maybe 1 in 10 of the brought forwards are too low
So the final total on csv vs pdf do not balance
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: CSV report giving different info to pdf version
If you can attach the CSV and pdf files that would be a step in the right direction.
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: CSV report giving different info to pdf version
Hi Bruce
Where do i send the info as it is confidential
THanks
Where do i send the info as it is confidential
THanks
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: CSV report giving different info to pdf version
I suggest you remove any private information before uploading.
It would be better if you could work out what combination of things need to happen to cause it, then I could reproduce it.
It would be better if you could work out what combination of things need to happen to cause it, then I could reproduce it.
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: CSV report giving different info to pdf version
Hi Bruce
We have to run these reports every month to submit to our bank
Please see pages 1-3 of pdf version attached
Also the csv version exported from sage
They are both exactly the same report in 2 formats
I have converted to XLS to be able to upload
One error is highlighted but there are many throughout the report
It appears to happen on some accounts where there is a brought forward amount
But not every time
We have run this report for many years with no problem
In the last month it has started to throw out this error
Any help would be really appreciated
We cant get our heads around it at all!!
We have to run these reports every month to submit to our bank
Please see pages 1-3 of pdf version attached
Also the csv version exported from sage
They are both exactly the same report in 2 formats
I have converted to XLS to be able to upload
One error is highlighted but there are many throughout the report
It appears to happen on some accounts where there is a brought forward amount
But not every time
We have run this report for many years with no problem
In the last month it has started to throw out this error
Any help would be really appreciated
We cant get our heads around it at all!!
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: CSV report giving different info to pdf version
Can you print off the account history for the one with the error.
I don't seem to have the xls or csv file
I don't seem to have the xls or csv file
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: CSV report giving different info to pdf version
Hi Bruce
Please see excel sheet attached
CSV does not want to upload
Please see excel sheet attached
CSV does not want to upload
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: CSV report giving different info to pdf version
I think it is your interpretation of the CSV file that is the issue.
In the PDF there are 15 fields
In the CSV there are 32 fields
I suspect there are a number of "working" numbers in the report that are not shown in the pdf but are included in the csv.
If you ignore the "workings" fields and establish which fields are the one you need to read everything will be fine.
In the PDF there are 15 fields
In the CSV there are 32 fields
I suspect there are a number of "working" numbers in the report that are not shown in the pdf but are included in the csv.
If you ignore the "workings" fields and establish which fields are the one you need to read everything will be fine.
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: Ahrefs [Bot] and 4 guests