74 | ProductPurchasesbySupplier (Custom Report)

Disclaimer:

This report may need modifications or alterations base on each system setup and configuration.

Report Query:

N.B This is intended to be added as a Custom Report in Bepoz

SELECT 
    Venue.Name AS Venue, 
    Store.Name AS Store, 
    Product.Name AS Product, 
    Supplier.Name AS Supplier, 
    SUM(STOCKVAR.CostExAdjust) AS TotalCost, 
    SUM(STOCKVAR.QtyOHAdjust) AS TotalQty
FROM STOCKVAR
INNER JOIN Store ON STOCKVAR.StoreID = Store.StoreID
INNER JOIN Supplier ON STOCKVAR.SupplierID = Supplier.SupplierID
INNER JOIN Venue ON STOCKVAR.VenueID = Venue.VenueID
INNER JOIN Product ON STOCKVAR.ProductID = Product.ProductID
WHERE STOCKVAR.AdjType = 1 AND STOCKVAR.ShiftID >=  {ShiftFrom} and STOCKVAR.ShiftID <= {ShiftTo} and STOCKVAR.STOREID LIKE '{STOREID}' AND STOCKVAR.VENUEID LIKE '{VENUEID}' AND  STOCKVAR.SUPPLIERID LIKE '{SUPPLIERID}'   
GROUP BY 
    Venue.Name,
    Store.Name,
    Product.Name,
    Supplier.Name
ORDER BY 
    Store.Name, 
    Product.Name, 
    Supplier.Name;