insert into setup(code,SValue) values('SalesOrderno',1000);
GO
alter table invoice add SalesOrderNo nvarchar(100);
GO
alter table DeliveryNote add SalesOrderNo nvarchar(100);
GO
alter table DeliveryNoteItem add SalesOrderNo nvarchar(100);
GO
alter table invoiceitem	add SalesOrderNo nvarchar(100);
GO
CREATE FUNCTION dbo.udf_GetTotalStockValue
(
    @DateOn DATE
)
RETURNS DECIMAL(18,2)
AS
BEGIN
    DECLARE @TotalValue DECIMAL(18,2)

    SELECT @TotalValue = SUM(
        ISNULL(GSV.SUMQTY, 0) * ISNULL(dbo.udf_SelectSTDCOST(@DateOn, I.ItemCode), 0)
    )
    FROM Item I
    LEFT JOIN GetStockValue GSV ON GSV.ItemCode = I.ItemCode
    LEFT JOIN Category C ON C.Code = I.Category
    WHERE ISNULL(I.stkmode, 'Inventory') = 'Inventory'

    RETURN @TotalValue
END