Modified Report - Sales by Supplier by Individual Product

My Boss would like to access or print off a Modified Report for our listed inventory items that show Sales by Supplier (by Inventory).

Ideally, this report would be able to immediately show the greatest number of sales per product for each of our suppliers.

Is this request possible via the current available reporting selections?

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    Hi Vanessa

    Just to clarify ... You're wanting to report on the sales of your Inventory Items but grouped by Supplier ?

    Are your Items set up as grouped that way in your Item List ?

    eg

    Supplier 1

    Item A

    Item B

    Item C

    There are many default reports for Sales, Customers, Suppliers & Items but Sales are usually associated with Customers rather than Suppliers so I'm just trying to determine exactly what you're wanting to see.

    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!)
  • Vanessa Loudon
    Vanessa Loudon Member Posts: 10 ✭✭

    Thanks for your reply, Shaz.

    Our inventory list has been set up with the stock listed under product headers (eg. grouping of similar product items/purposes together) but each item is individually linked to the specific Supplier in the details on that product.

    We are wanting the report to identify which of our stock lines have the most orders / turnover but also list which supplier these items were sourced from.

    Can one of the Sales Reports be modified to include Supplier information or is there an Inventory Report that has the Supplier linked to it that can be modified to produce what is required?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    Hi Vanessa

    The Supplier field in the Item is database-specific rather than transactional so will only display in List-type reports.

    The Sales by Item Summary sorted by Total would show what you need (minus the Supplier) displayed in order from highest to lowest (or vice versa):

    This report contains other columns which I've unticked to not show but the Qty & Avg Price columns aren't able to be removed (although if necessary, you could export it to Excel to do that though)

    Is that one any help ?

    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!)
  • Vanessa Loudon
    Vanessa Loudon Member Posts: 10 ✭✭

    Thanks for the explanation, Shaz.

    I have passed your information on to my employer for their attention and actioning.