Customer country field
Comments
-
Hi Kevin
I don't use the "Edit" button for name/address info (& make sure the "Show this window again when address is incomplete or unclear" checkbox in that "Edit ..." window, is not ticked)
This particular section seems to have a default format which struggles with longer/international address layouts. Instead, I always type the info directly into the "Bill to" section on the customer record.
Alternatively, if you do use the "Edit ..." info window (or add Shipping addresses), type the address - as you want it displayed - all into the "Address" box & ignore the other fields (City, State etc)
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
Thanks Shaz. When I follow your method, I get the address looking good from a layout perspective (in the Bill To box) but when I run a Customer list report, the country "jumps around"into the City, State or Notes field. I am trying to prepare a Sales by Country report (we deal with ~80 countries). It should be easy to do in Reckon, but only if you can actually "force" the value into the Country field. My current approach is to export to Excel and manually edit for Customers with "problem" countries. As I surmised in my original comment, it appears that Reckon has a secret Country list and will only accept values from that list, regardless of what you type. If so, Reckon might have inherited this from the Americans (Intuit).
0 -
Sorry Kevin ... I get where you're coming from now. I had thought you'd meant on the invoice itself.
As a workaround, would it be any good to create a Custom Field for the Country? This can be added in their Customer record which you can then add to your invoice template "Screen" to autofill every time you create an invoice for them, but not display on the customer's printed/hard copy. Then filter/group your report by this?
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
I have concerns with having Country values in two places - potential for variances! I can display the Custom field in a report, but cannot summarise by the Custom field label. Ultimately, I am attempting to produce a table of sales by Item group (row) by Country (column). My current solution is to extract the data into Excel, edit the Country value for the problem Countries then summarise into the table with the SUMIF function.
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community