Items sold based on date and supplier

Discussion in 'Microsoft Point Of Sale' started by Brent, Feb 14, 2007.

  1. Brent

    Brent Guest

    I am wanting to get a report or create a query that shows items sold based
    on Suppliers and Date (from x to y).

    What tables are involved and how are they joined?

    Any canned reports created to do this?
    thanks
    brent
     
    Brent, Feb 14, 2007
    #1
    1. Advertisements

  2. Brent

    Nashat Guest

    find below a query to get sales by supplier
    *******************************
    select Suppliername,Itemlookupcode,description,sum(te.quantity*te.price) as
    Sales
    from item left join supplier on item.supplierid=supplier.id
    left join transactionentry te on item.id=te.itemid
    inner join [transaction] tr on tr.transactionnumber=te.transactionnumber
    where time between '2007-01-01 00:00:00' and '2007-02-01 00:00:00'
    and supplier.code='xx'
    group by Suppliername,Itemlookupcode,description
    order by Suppliername,Itemlookupcode,description
    *******************************
    please note that this query show u sales for the primary supplier only
     
    Nashat, Feb 14, 2007
    #2
    1. Advertisements

  3. Brent

    Craig Guest

    Nashat,
    Would you have a query to see sales by customer within a specific time
    frame?
    Craig

     
    Craig, Feb 14, 2007
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.