set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go





create FUNCTION [dbo].[FunGoodRemainBeforeDate] 
	(
	@Date char(8)='99/99/99'
	)
RETURNS TABLE
AS
	RETURN SELECT     GoodSysCode, SUM(NetQuantity) AS Remain
FROM         VWInvoiceDetailComplete
WHERE     (NOT (FK_DocsysCode IS NULL)) AND (InvoiceDate < @Date) OR
                      (Amani = 1) AND (InvoiceDate < @Date)
GROUP BY GoodSysCode