Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

CSV report giving different info to pdf version

Sage 50 general help forum - Free help and support for all general issues
Post Reply
jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

CSV report giving different info to pdf version

Post by jimbell » 22 Jun 2018, 08:59

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4058
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by brucedenney » 22 Jun 2018, 11:28

Does this happen if you use the demo data?

Can you give me an example so I can reproduce the issue?
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by jimbell » 22 Jun 2018, 12:10

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4058
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by brucedenney » 25 Jun 2018, 15:15

If you can attach the CSV and pdf files that would be a step in the right direction.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by jimbell » 29 Jun 2018, 13:48

Hi Bruce
Where do i send the info as it is confidential
THanks

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4058
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by brucedenney » 29 Jun 2018, 14:29

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.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by jimbell » 29 Jun 2018, 17:02

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!! :(
You do not have the required permissions to view the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4058
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by brucedenney » 02 Jul 2018, 11:17

Can you print off the account history for the one with the error.

I don't seem to have the xls or csv file
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by jimbell » 03 Jul 2018, 22:06

Hi Bruce

Please see excel sheet attached
CSV does not want to upload
You do not have the required permissions to view the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4058
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: CSV report giving different info to pdf version

Post by brucedenney » 04 Jul 2018, 09:54

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.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest