Can I search for a field in an estimate
I do see that there is a field called P.O. in the estimates template, but I thought that might pertain to the other side of the ledger (as in... I (emphasis on I) would create a PO when I am ordering something)...but couldn't see how that would be right for the CUSTOMER'S reference number...
Comments
-
Hi Deb
In my Reckon Accounts Desktop 2018 if I go to the Customer Centre and click the Customer & Job tab, then on the right hand side under Reports for this Customer click Show Estimates.
On the left hand side click Modify Report and and then under columns check all the optional column headings to see if there is one that might be suitable for your requirements. In this respect, Reckon Accounts is quite customisable for all sorts of reporting.
Robert Smeallie0 -
Hello Robert, thank you for that - I really appreciate you responding :-) That has helped a lot thanks, except I don't seem to have "Columns" as such, more filters or accounts, but within those, really the only one I can see that would be appropriate, is P.O.#. I guess from here my query would be, can the P.O. field be used as the customers Work Order number (or Request for Quote number), or is the P.O. field in an estimate form really designed for MY use to order products to fulfil the stock provision side of the estimate. I don't mind using this P.O. # field for the customer's reference number, as it would be great and easily can run a report with this field, but I didn't want to use it that way if it's actually meant for "the other side of the ledger" so to speak. Because that might scramble something?0
-
Hi Deb
I make the Quote/Estimate Number itself the "Request for Quote No". You can even re-name the field label to this in the template.
This allows it to be shown in all reporting & - for customers who have their own specific number formats - also makes it easy to identify
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 -
Hi Deb,
The method described by Shaz is likely easier.
Below is an alternative which makes use of Custom Fields if you want to keep the existing Quote/Estimate Number field and also have a "Request for Quote No.".
These custom fields can be added to estimate, invoice and other templates.
Ensure that you have confirmed that these custom fields are available in the reports you need to make use of and that you are able to search/filter for them successfully.If you require over-the-phone technical assistance, please contact the Reckon Accounts Technical Support Team.
Reckon Accounts Technical support*
Members: Phone number available via members.reckon.com
Monday to Friday 8:30 am to 7 pm AESTAlready a member? please visit the Advantage members area for priority support here
Non-Members: 1902 223 101*
Weekend support: 1902 223 101*
Saturday and Sunday 9 am to 4 pm AEST* All calls cost $4.90 per minute (incl. GST). Higher rates apply to calls from mobile & payphone.
For unlimited free technical support, why not consider joining the Reckon Advantage program.
Read more about the benefits here.
The Reckon Community Support and Knowledgebase articles are a useful resource.
Regards,
Data Recovery TeamRegards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
0 -
thank you Data Rec, this was exactly what to do and I have done it - others had given the answer too - very grateful to all. One thing though, it doesn't not seem to be possible to sort my estimates report in alphabetical order by the field I have chosen. It just wants to sort the list by the customer name, no matter what? How can I get an estimates report that will sort itself by the field in the list that I click on, instead of defaulting to the customer name/job.?
Kind regards,
Deb
0 -
Hi Deb,
You need to generate one of the standard reports such as the "Estimated by Job" report and modify it.
In the Display tab, ensure that you add the specific column that you want to appear such as that "Request-for-Quote" custom field.
Then you can modify the "Sort by" field value.
Then you can Memorise the report.If you require over-the-phone technical assistance, please contact the Reckon Accounts Technical Support Team.
Reckon Accounts Technical support*
Members: Phone number available via members.reckon.com
Monday to Friday 8:30 am to 7 pm AESTAlready a member? please visit the Advantage members area for priority support here
Non-Members: 1902 223 101*
Weekend support: 1902 223 101*
Saturday and Sunday 9 am to 4 pm AEST* All calls cost $4.90 per minute (incl. GST). Higher rates apply to calls from mobile & payphone.
For unlimited free technical support, why not consider joining the Reckon Advantage program.
Read more about the benefits here.
The Reckon Community Support and Knowledgebase articles are a useful resource.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
0
Reckon Staff