customer that bought anything from that supplier for a period of time

SUGGESTED

Hello, 

Does anyone know of a way to produce a report of customers that bought from a supplier in sage 50c.

For example: If I have a supplier and I want to know every customer that bought anything from that supplier for a period of time, what report would I use/how would I do this? 

I am using Sage 50c - 28.1.404.0

  • 0

    Not a standard report .
    How would you identify the customers as that's sales ledger and suppliers are purchase ledger; the two just don't mix.

    Are you a third party brokering sales ?

    Are the products uniquely identifiable etc ?

  • 0

    Hi Niall,

    Just to clarify, are you buying products from your supplier that you then sell on to customers and you want to know which customers bought products that you sourced from a particular supplier?

    Andy
    Sage UKI

  • 0 in reply to Ken Starnes

    Hello Ken, 

    Thank you for your response, i am just a regular user of Sage, looking to see the list of customer that bought from a supplier. 

    Yes, all items in the Supplier recorded that we sell to customers are uniquely identifiable.

    For example: I have Supplier A and Supplier B and Supplier C

    I want to know what customers Bought from "Supplier B" only to have a list of customer that bought from that supplier this year for instance. 

    this can be every product related with the supplier record in Sage. 

  • 0 in reply to Andy Rickeard

    Hello Andy, 

    Yes, we buy from the supplier and sell to our customer. 

    as mentioned above this response I am looking to do the following: 

    I have Supplier A and Supplier B and Supplier C

    I want to know what customers Bought from "Supplier B" only to have a list of customer that bought from that supplier this year.

  • 0 in reply to Niall Connolly
    SUGGESTED

    Thanks for clarifying Niall. 

    If you use product records in Sage 50 Accounts and you complete the Supplier Account ref field in those product records and you only ever buy in those products from that  supplier then an invoicing report, such as the Product sales by customer report, could be amended to add in the default supplier as a field, group or criteria as required.  If you purchase the products from more than one supplier then it would not be possible.

    If you'd like to pursue this option you can submit a query online >

    Regards,

    Andy
    Sage UKI

  • 0 in reply to Andy Rickeard

    Thank you for your response, however this does not answer the question?

    I want a report, that gives me a list of customers that purchased items we got form a particular supplier. 

  • 0 in reply to Niall Connolly

    There isn't one Niall.

    You'd need to get Sage to write one or you could create your own but ONLY if you use the Supplier Field in the Products record for those products sold as Andy has suggested

  • 0 in reply to Niall Connolly

    Hi Niall, in Sage 50 Accounts, in terms of reporting, the customer and supplier modules are not linked.

    The only way this information could be obtained would be if there was something that tied the purchase of the product by the customer to the supplier it was sourced from. You could amend a report to do this if you use product records, populate the Supplier fields on the product record  and only obtain the product from one supplier.

    There isn't a default report that would show this information.