beanwiz
https://community.reckon.com/home/leaving?allowTrusted=1&target=https%3A%2F%2Ffree.beanwiz.com.au%2Fbeanwiz helps you to perform batch update processes with your Reckon Hosted
Exporting Invoice Descriptions
Alex_10836088
Member Posts: 54 Reckoner 
We have a lot of invoices where information has been typed into the Description field - some have been entered beside an item, others with no items as shown
I'm needing to extract all information from the description - either as a report, IIF export or any other way.
Is this possible and if so how?
Thanks
0
Answers
-
Run a report on all the invoice lines and export it to excel.
Call me if you get stuck
Kevin 0407744914
0 -
Copy and paste doesnโt work - pasting to possibly a word document?
0 -
Thanks Kris - copy/paste does work - but I'm needing to extract from several hundred invoices over a period of time.
Happy to look at options like cData ODBC if anyone can confirm it would work for this ?
0 -
You need a third party app to do this. Speak to Mr Cosmic. And it wont be cheep
Zappy
0 -
Wow thatโs a big job, good luck with it
0 -
I can create a script to export invoices within a range for you and extract the description fields to a text file (CSV or XML) so that you can use it.
Please email me if you are interested.
Thanks,
Phuong
Phuong Do / Reckon Developer Partner
phuong@cactussoftware.com.au
https://www.youtube.com/watch?v=O61SfV2bte8
1 -
Kris it's not a big job if you have the correct tools
0 -
Just following up on needing to pull invoice line data over several months - not a task i wanted (or even could) do manually.
Phuong was amazing and quickly prepared a script/tool that allows me to pull data out as i need it - even tweaked changes afterward to get it working just right.
Phuong is highly recommended and easy to work with - thanks Phuong :)
1 -
Thanks for the update
0