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