Postcode field doesn't hold the postcode
Shayne McNamara
Member Posts: 43 ✭
We have been trying on Reckon Accounts Hosted to dump a customer list to sort and do work by postcode.
We have got the correct postcode in the Postcode Field for the Invoice address but it just "joins" the City and Postcode field together under City and the Potcode field on a custom report is empty.
e.g. we put in Albany in the City code and 0794 in the Postcode field but when you run a report with those fields the City Field shows Albany 0794 and postcode field is empty.
Reckon if you are reading this I would have thought this is database 101. Does anyone know a fix other than trying to strip this out in and Excel worksheet.
Thanks
We have got the correct postcode in the Postcode Field for the Invoice address but it just "joins" the City and Postcode field together under City and the Potcode field on a custom report is empty.
e.g. we put in Albany in the City code and 0794 in the Postcode field but when you run a report with those fields the City Field shows Albany 0794 and postcode field is empty.
Reckon if you are reading this I would have thought this is database 101. Does anyone know a fix other than trying to strip this out in and Excel worksheet.
Thanks
0
Comments
-
I have the same problem in Premier 2016. In the supplier record if you use the address details button on the supplier and enter the postcode into the postcode field it changes the customer record so that the last address component (city or state) has the post code added to it. So next time you open the details popup the postcode is empty and the city is "Auckland 1234". So in my experience it is impossible to populate the post code field from within the tool.
I spent ages with the .iif supplier export trying to extract postcode and was blaming poor data quality only to discover that actually it is system design. As you say Shayne, hard to believe in this century. Glad we are migrating to a better system.0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community