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'

SELECT DISTINCT @InvoiceNo AS InvoiceNo

--UPDATE dbo.PCMFILOINVOICENO
--SET Sequence = @SequenceNew
--WHERE Year = @FiscalYear