Supplier Report

Options

I need to run a Supplier report to show the names of all customers we have billed under a particular supplier. I have tried creating this report and adding the fields I need but cannot find the Customer: Job field to add to the report. Can anyone point me in the right direction, please?

Best Answer

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,426 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited February 2023 Answer βœ“
    Options

    This particular report can't display that information.

    There is an Unbilled Costs by Job report (under the Reports dropdown menu > Jobs, Time & Mileage) but not a specific one by Supplier.

    However, the beauty of Reckon Accounts is that you can create your own via the Find Advanced tab (under the Edit dropdown menu along the top toolbar) !

    • Click on Transaction Tyoe in the Filters box & select Bill
    • Click on Detail Level & select All except summary
    • You cn also specify a particular timeframe/date (incl range) under the Date filter if required

    … then click on Report

    In the report display, you can add/remove columns, change formatting, rename &/or configure to show a specific Billing Status only (eg Unbilled) etc etc:

    Once configured exactly how you want it, Memorise it so you can regenerate it anytime, without needing to redo all the settings every time 😊

    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)

Answers

  • Kris_Williams
    Kris_Williams Member Posts: 3,303 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    Options

    how are you linking a customer to a bill - in the name Field at the bottom of the bill or cheque?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,426 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited February 2023
    Options

    If you've jobcosted the charges by selecting/linking the lines specifically to a Customer:Job, the column to tick for this in the list when you modify the report, is just Name or Source Name (depending on the report) 😊

    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • Rochelle
    Rochelle Member Posts: 8 ✭
    Options

    I've just taken a screenshot of the area I want to run a report for Best in Bed. What I'm trying to work out is the name of clients who have purchased from them.

    If I generate a Transaction List by Supplier report and selecting all the fields required but I'm still need the Customer:Job (Customers/Clients name)

  • Rochelle
    Rochelle Member Posts: 8 ✭
    Options

    Thanks you so much. I completatly forgot about designing reports through the β€œFind” section.