AnsweredAssumed Answered

Combining purchase/sale prices

Question asked by sarap on Nov 24, 2014
Latest reply on Nov 24, 2014 by philmodjunk

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

Outcomes