Page 1 of 1

CSV report giving different info to pdf version

Posted: 22 Jun 2018, 08:59
by jimbell
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

Re: CSV report giving different info to pdf version

Posted: 22 Jun 2018, 11:28
by brucedenney
Does this happen if you use the demo data?

Can you give me an example so I can reproduce the issue?

Re: CSV report giving different info to pdf version

Posted: 22 Jun 2018, 12:10
by jimbell
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

Re: CSV report giving different info to pdf version

Posted: 25 Jun 2018, 15:15
by brucedenney
If you can attach the CSV and pdf files that would be a step in the right direction.

Re: CSV report giving different info to pdf version

Posted: 29 Jun 2018, 13:48
by jimbell
Hi Bruce
Where do i send the info as it is confidential
THanks

Re: CSV report giving different info to pdf version

Posted: 29 Jun 2018, 14:29
by brucedenney
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.

Re: CSV report giving different info to pdf version

Posted: 29 Jun 2018, 17:02
by jimbell
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!! :(

Re: CSV report giving different info to pdf version

Posted: 02 Jul 2018, 11:17
by brucedenney
Can you print off the account history for the one with the error.

I don't seem to have the xls or csv file

Re: CSV report giving different info to pdf version

Posted: 03 Jul 2018, 22:06
by jimbell
Hi Bruce

Please see excel sheet attached
CSV does not want to upload

Re: CSV report giving different info to pdf version

Posted: 04 Jul 2018, 09:54
by brucedenney
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.