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

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: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

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: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

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: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

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!! :(
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

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
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 18 guests