Excel Reports truncated
We're using Reckon Accounts Enterprise 2021 and when we export our customer list to Excel, the customer "Note" (eg. Customer Notepad) field/cell in each row is truncated to 256 characters when the data arrives in Excel, and all it shows after 256 characters is #####. We are using Excel 2007 and according to Microsoft's website, Excel 2007 supports 32,767 characters per cell. Is there any way to fix this? Thanks in advance for any help :).
Comments
-
Hi James,
When you are 'exporting' your Customer List to Excel, are you doing this by generating a specific report which you have customised from the Reports menu and clicking the Export button send it to Excel?
Or are you using the built-in function by clicking the File | Utilities | Export |Lists to IIF File function?
And then opening up the resulting Customer List in Excel.
If you use the export of the Customer list to IIF, it should show more than 256 characters.
Example:
Regards,
Reckon Data Recovery Team
How do I add an image or screenshot to my discussion?
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
Thank you for this helpful information. Just to clarify, when exporting lists to IIF, can you also export all the custom fields at the same time?
0 -
The Custom Fields present in the Customer, Supplier, Employee, Other Name list records are exported as part of those lists.
Explore the different list types by using a blank new test data file with limited specific information, so you can see what gets exported and how the info you enter into the Reckon Accounts data file maps out to the export files.
Regards,
Omar - Reckon Data Recovery Team
Data Services Tip - Try this first before requesting a data service
0
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 š¢ Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 š¢ Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll
- 33 š¢ Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos š„
- 25 Reckon Mate App
- 2.6K Reckon One
- 9 š¢ Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community