Displaying P.O. Number as a column in the customer centre

GoatyMcGoatBoat
GoatyMcGoatBoat Member Posts: 54
Can this be done?  Almost EVERY other item on the invoice/estimate is available as a column except this one.  I have a customer who likes to request estimates for jobs well in advance and I've ended up with about thirty estimates for them... when it comes time for them to book one of their jobs, I have to go back and open each estimate to figure out which one to turn into an invoice, wasting LOTS of time.

Thanks

Comments

  • Charley
    Charley Member Posts: 541 ✭✭✭
    edited January 2020
    Go to reports>purchases>open purchase orders, you should be able to set up a memorised report for this customer and modify the report by adding the purchase order # and whatever else. It will get you to the right one a lot quicker
  • GoatyMcGoatBoat
    GoatyMcGoatBoat Member Posts: 54
    edited August 2017
    Hi Charles, thanks for the idea... not quite as easy as having the column but sounds a lot easier than opening each one!!

    Only problem is I don't have a "Purchases" category under "Reports"

    And I can't find "Open Purchase Orders" anywhere in reports..

    Cheers
  • GoatyMcGoatBoat
    GoatyMcGoatBoat Member Posts: 54
    edited August 2017
    Update

    Are you talking about "Sales Orders?"  If so, I don't use Sales Orders...

    When I say PO Number, I'm referring to the PO number that's entered on the invoice or estimate in the top right, near the terms and due date.  I usually enter the address of the job in there when doing an estimate.
  • GoatyMcGoatBoat
    GoatyMcGoatBoat Member Posts: 54
    edited September 2018
    UPDATE #2

    I've managed to get pretty much the same thing using the "Transaction List By Customer" report, limiting it to the one customer, and removing all the columns but the Type/Date/Num/PO/Amount columns.

    I'd still like to get the PO number as a column in the customer centre, but this will help a lot in the short term :)

    Thanks very much