1 Reply Latest reply on Nov 24, 2014 5:31 AM by philmodjunk

    Combining purchase/sale prices

    sarap

      Title

      Combining purchase/sale prices

      Post

      I need to create a list of all the invoice and the order information for each product. Every product can have multiple purchase and selling prices. So for every product I'd like to display the date and price(::Orders_details) for every time it has been purchased and the date and price for every time the product, with that particular purchase price,  has been sold(::Invoices_details). For example

      ProductID(1) purchasedate(mm/yy) purchaseprice($) saledate(mm/yy) purchaseprice(1)

      ProductID(1) purchasedate(mm/yy) purchaseprice($) saledate(mm/yy) purchaseprice(2)

      ProductID(2) purchasedate(mm/yy) purchaseprice($) saledate(mm/yy) purchaseprice(1)

       

       

       

       

       

      Schermata_2014-11-24_alle_11.43.33.png