Sequential Numbering (Document Sequence) in EBS GL

This is used to assign unique numbers to the Oracle concepts. Sequential number can be called voucher numbers or document category. I have explained the steps which are required to setup a document sequence for Journals in GL.

Define profile option sequential numbering at responsibility level

N: System Admin -> Profile -> System
Enable Responsibility: KT GL Super user
Profile: %Seq%numb%           ->Find

Profile Option Name	Site	Application	Responsibility	User
Sequential Numbering	Not USed		Partially Used

Save and close.

Define Sequential Numbering

N: System Admin -> Application -> Sequential Numbering ->Define

Name	Application	From	To	Type	Message	Initial Value
KT Exp	General Ledger	1-Apr-18		Automatic	√

Save and close.

Assign Sequential Numbering to the Category

N: System Admin -> Application -> Sequential Numbering ->Assign

Application	Category	Ledger	Method
General Ledger	Expenditures	KT PL	Manual
General Ledger	Expenditures	KT PL	Automatic

 

Go to Assignment tab

Application	Category	Start Date	End Date	Sequence
General Ledger	Expenditure	1-Apr-18		KT Exp
General Ledger	Expenditure	1-Apr-18		KT Exp

Save and post.

Enter Journal to check the result

N: GL -> Journals -> Enter      ->New Journal
Journal : Sequential Num Test                                   Category:Expenditure

Come to Lines

Line	Account	Debit	Credit
1	01.00.00.00.7420	40000
2	01.00.00.00.2210		40000

 Save.

One Popup window will come up i.e Sequence Number    ->Ok
Document Number: 1
Post and close the window.

Points to Note:

At Sequence

Automatic: General Ledger sequentially assigns a unique number to each document as it is created

Gapless: General Ledger sequentially assigns a unique number for each document, but ensures that the document was successfully generated before assigning the number.

Manual: The user must assign a number to each document when it is created. You must enter unique values. Sequential ordering and completeness are not enforced.

Assignment

Automatic: Assign sequential numbers to journal entries created automatically by General Ledger. Do not assign sequences defined with a manual numbering type to an automatic creation method.
Manual: Assign sequential numbers to journal entries you enter manually using the Enter Journals window.
Null = transactions can be created either Automatically or Manually