set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


create FUNCTION [dbo].[FunGoodLastDate](@Code int)
	
RETURNS char(8)
AS
	BEGIN
	Declare @R char(8)
		SELECT     TOP (1) @R= InvoiceDate
FROM         VWInvoiceDetailComplete
WHERE     (GoodSysCode = @code) AND (Amani = 1) AND (Type = 2) OR
                      (GoodSysCode = @code) AND (NOT (FK_DocsysCode IS NULL)) AND (Type = 2)
ORDER BY SysCode DESC
	RETURN @R
	END