Can I search for a field in an estimate

In Reckon Accounts Premier Edition 2017 (Desktop)... I use estimates (or Quotes), and would like a field in there somewhere where I can enter the customer's Request-for-Quote number. (The customers reference number). And then I would like to be able to run a report of my estimates that would show this number within the results. (So, find transaction type Estimate, run a report of it and then modify report to display desired fields. The customers request for quote number would be one of the fields I would want to see displayed in the report.
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

Robert Smeallie_9600650

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 Smeallie

Deb_9768970

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?

Acctd4

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

Datarec

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.

Image httpsd2r1vs3d9006apcloudfrontnets3_images1748518RackMultipart20180828-14710-gg6wha-Community-Screenshot-Custom-Fields1_inlinePNG1535423905

Image httpsd2r1vs3d9006apcloudfrontnets3_images1748519RackMultipart20180828-8708-1a60q7r-Community-Screenshot-Custom-Fields2_inlinePNG1535423914

Image httpsd2r1vs3d9006apcloudfrontnets3_images1748520RackMultipart20180828-68313-1hds4bl-Community-Screenshot-Custom-Fields3_inlinePNG1535423922

Image httpsd2r1vs3d9006apcloudfrontnets3_images1748521RackMultipart20180828-62525-yuy1gn-Community-Screenshot-Custom-Fields4_inlinePNG1535423929

Image httpsd2r1vs3d9006apcloudfrontnets3_images1748522RackMultipart20180828-124350-lpqr43-Community-Screenshot-Custom-Fields5_inlinePNG1535423939

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 AEST

Already 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 Team

Deb_9768970

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