GoodsReceivedNoteID | LocationID
     1              |      1
     2              |      1

GoodsReceivedNoteDetailID|GoodsReceivedNoteID|AcceptedQuantity|ProductID|CreatedON|
    1                     | 1                | 50 |  1  |10-2-2015
    2                     | 2                | 100|  1  |1-3-2015

Fromlocation |Tolocation|ProductID|TransferQuantity|CreatedOn|
 1              2             1       10|10-2-2015
 1              2             1       25 |12-2-2015
 1              2             1       50 |5-3-2015``

GoodsReceivedNoteID

SELECT DISTINCT
    [GRN].[GoodsReceivedNoteNo] ,
    [GRN].[LocationID] ,
    [GRN].[CreatedOn] ,
    [POD].[UnitPrice] AS [BasicRate] ,
    [POD].[VAT] ,
    [POD].[UnitPrice] * [GRND].[ReceivedQuantity] AS [CostofPurchase] ,
    [PO].[PurchaseOrderNo] ,
    [V].[VendorName] ,
    [GRN].[SupplierInvoiceNo] ,
    [GRN].[SupplierInvoiceDate] ,
    [SR].[LRNO] ,
    [T].[TransporterName] ,
    SUBSTRING([LPM].[BarCode], 4, 4) [Code] ,
    RIGHT([LPM].[BarCode], 6) [ProductCode] ,
    [P].[ProductName] ,
    [UT].[UnitTypeShortCode] ,
    CAST([GRND].[ReceivedQuantity] AS DECIMAL(18, 2)) AS [ReceivedQuantity] ,
    CAST([GRND].[RejectedQuantity] AS DECIMAL(18, 2)) AS [RejectedQuantity] ,
    CAST([GRND].[AcceptedQuantity] AS DECIMAL(18, 2)) AS [AcceptedQuantity] ,
    CAST([GRND].[UnitPrice] AS DECIMAL(18, 2)) AS [BasicRate] ,
    CAST(ISNULL(( [GRND].[UnitPrice] * [GRND].[ReceivedQuantity] ), 0.00) AS DECIMAL(18, 2)) [BasicValue] ,
    [GRND].[VAT] ,
    CASE WHEN COUNT([GRND].[GoodsReceivedNoteID]) OVER ( PARTITION BY [GRND].[GoodsReceivedNoteID] ) > 1
         THEN ISNULL(( [GRND].[FreightCharges] ), 0.00)
         ELSE ISNULL(( [OEC].[FreightCharges] ), 0.00)
    END [FreightApportioned] ,
    CASE WHEN COUNT([GRND].[GoodsReceivedNoteID]) OVER ( PARTITION BY [GRND].[GoodsReceivedNoteID] ) > 1
         THEN ISNULL(( [GRND].[LoadingCost] + [GRND].[UnloadingCost] ), 0.00)
         ELSE ISNULL(( [OEC].[LoadingCost] + [OEC].[UnloadingCost] ), 0.00)
    END [LoadingandUnloadingApportioned] ,
    CASE WHEN COUNT([GRND].[GoodsReceivedNoteID]) OVER ( PARTITION BY [GRND].[GoodsReceivedNoteID] ) > 1
         THEN ISNULL(( [GRND].[FreightCharges] ), 0.00) + ISNULL(( [GRND].[LoadingCost] + [GRND].[UnloadingCost] ), 0.00)
              + ISNULL(( [GRND].[UnitPrice] ), 0.00)
         ELSE ISNULL(( [OEC].[FreightCharges] ), 0.00) + ISNULL(( [OEC].[LoadingCost] + [OEC].[UnloadingCost] ), 0.00)
              + ISNULL(( [GRND].[UnitPrice] ), 0.00)
    END [TotalCost] ,
    [TN].[CreatedOn] ,
    [TN].[TransferQuantity] ,
    [TN].[Tolocation] ,
    [TN].[ProductID] ,
    [GRND].[ProductID] ,
    ( [TN].[TransferQuantity] * [TN].[UnitPrice] ) AS [VALUE] ,
    [L].[Location] ,
    [TN].[FreightCharge] ,
    ( [TN].[LoadingCharge] + [TN].[UnLoadingCharge] ) AS [LoadingandUnloadingCharges] ,
    ( [TN].[FreightCharge] + [TN].[LoadingCharge] + [TN].[UnLoadingCharge] ) AS [LoadingCost]
FROM
    [GoodsReceivedNoteDetail] [GRND]
LEFT OUTER JOIN
    [GoodsReceivedNote] [GRN] ON [GRN].[GoodsReceivedNoteID] = [GRND].[GoodsReceivedNoteID]
LEFT OUTER JOIN
    [PurchaseOrder] [PO] ON [PO].[PurchaseOrderID] = [GRN].[PurchaseOrderID]
LEFT OUTER JOIN
    [Vendor] [V] ON [V].[VendorID] = [PO].[VendorID]
LEFT OUTER JOIN
    [SecurityRegister] [SR] ON [SR].[SecurityRegisterID] = [GRN].[SecurityRegisterID]
LEFT OUTER JOIN
    [Transporter] [T] ON [T].[TransporterID] = [SR].[TransporterID]
LEFT OUTER JOIN
    [OtherExpenseCost] [OEC] ON [OEC].[GoodsReceivedNoteID] = [GRN].[GoodsReceivedNoteID]
LEFT OUTER JOIN
    [Product] [P] ON [P].[ProductID] = [GRND].[ProductID]
LEFT OUTER JOIN
    [LocationProductMap] [LPM] ON [LPM].[ProductID] = [GRND].[ProductID]
LEFT OUTER JOIN
    [UnitType] [UT] ON [UT].[UnitTypeID] = [P].[UnitTypeID]
LEFT OUTER JOIN
    [PurchaseOrderDetail] [POD] ON [POD].[PurchaseOrderID] = [PO].[PurchaseOrderID]
LEFT OUTER JOIN
    [TransferNote] [TN] ON [TN].[ProductID] = [GRND].[ProductID]
LEFT OUTER JOIN
    [Locations] [L] ON [L].[LocationID] = [TN].[Tolocation]
WHERE
    (@d_StartDate = ''
      OR CAST([GRND].[CreatedOn] AS DATE) >= @d_StartDate
      OR CAST([GRND].[CreatedOn] AS DATE) = @d_StartDate)
    AND (@d_EndDate = ''
          OR CAST([GRND].[CreatedOn] AS DATE) <= @d_EndDate)
    AND (@i_GrnStartNo = '0'
          OR [GRN].[GoodsReceivedNoteNo] >= @i_GrnStartNo)
    AND (@i_GrnEndNo = '0'
          OR [GRN].[GoodsReceivedNoteNo] <= @i_GrnEndNo)
    AND ([GRN].[LocationID] = @i_LocationID)
    --AND CAST( GRND.CreatedOn AS DATE)=@d_StartDate