TULISAN

??ALTER PROCEDURE [dbo].[PFILOGENERATEINVOICENO]

(

	@FiscalYear	VARCHAR(20)

	,@DocType VARCHAR(20)

)

AS

--DECLARE @FiscalYear VARCHAR(20) = '2020'

--DECLARE @DocType VARCHAR(20) = 'AR'

IF (@FiscalYear = '') BEGIN SET @FiscalYear = '*' END

DECLARE @CountYear DECIMAL(18,0)

SELECT DISTINCT @CountYear = COUNT(inv.Year)

FROM dbo.PCMFILOINVOICENO AS inv WHERE inv.Year = @FiscalYear

DECLARE @Sequence DECIMAL(18,0)

IF(@CountYear = 0)

BEGIN

SET @FiscalYear = '*'

SELECT DISTINCT @Sequence = invno.Sequence 

FROM dbo.PCMFILOINVOICENO AS invno

WHERE invno.Year = @FiscalYear

END

ELSE IF(@CountYear > 0)

BEGIN

SELECT DISTINCT @Sequence = invno.Sequence 

FROM dbo.PCMFILOINVOICENO AS invno

WHERE invno.Year = @FiscalYear

END

DECLARE @SequenceNew DECIMAL(18,0) 

SET @SequenceNew = @Sequence + 1

DECLARE @InvoiceNo VARCHAR(250)

--SET @InvoiceNo = 'INV' + CONVERT(VARCHAR(100), @SequenceNew) +'/KEU/LPPOM'

SET @InvoiceNo = ''

SELECT DISTINCT @InvoiceNo AS InvoiceNo

UPDATE dbo.PCMFILOINVOICENO

SET Sequence = @SequenceNew

WHERE Year = @FiscalYear