General Ledger Transactions > Additional GL Numbering > Numbering Examples
  
Numbering Examples
Example:  
This example uses two entities, Entity 1000 and Entity 2000. The entities have the following additional GL numbering settings:
 
Settings
Entity 1000
Entity 2000
Additional GL Numbering:
Yes
Yes
Reset Number Yearly:
No
N/A
Source Numbering Entity:
N/A
Entity 1000
Next Sequence Number:
000000001
N/A
The entities use the following GL periods:
 
GL Period
Period Type
From - To Dates
200911
Normal
11/01 - 11/30
200912
Normal
12/01 - 12/31
200913
Correction
12/15 - 12/31
200914
Year-End Closing
N/A
201000
Year-End Closing
N/A
201001
Normal
01/01 - 01/31
201002
Normal
02/01 - 02/28
201003
Normal
03/01 - 03/31
201004
Normal
04/01 - 04/30
The entities use the following daybooks:
 
Daybook
Layer Type
Layer Included in GL Numbering?
Inv1
Management
Yes
Inv2
Management
No
JE
Official
Yes
Trans1
Transient
No
Year-End
Official
Yes
At the end of 2009, Entity 1000 and Entity 2000 contain the following postings:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-N01
JE
200911
20091110
20091120
20091110
1000-N02
JE
200911
20091115
20091115
20091115
1000-N03
Trans1
200911
20091115
20091115
20091115
1000-N04
Inv1
200911
20091115
20091115
20091115
1000-N05
Inv2
200911
20091115
20091115
20091115
1000-N06
JE
200912
20091211
20091218
20091211
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-N01
JE
200911
20091109
20091109
20091109
2000-N02
JE
200911
20091115
20091115
20091115
2000-N03
Inv1
200911
20091115
20091115
20091115
2000-N04
Trans1
200911
20091120
20091120
20091120
2000-N05
Inv1
200912
20091215
20091215
20091215
You run GL Sequence Renumber for Entity 1000 for periods 200911 and 200912. Entity 1000 is the numbering source for both Entity 1000 and Entity 2000. The following sequence numbers are assigned:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000001
2000-N01
20091109
JE
200911
000000002
1000-N01
20091110
JE
200911
000000003
1000-N04
20091115
Inv1
200911
000000004
2000-N03
20091125
Inv1
200911
000000005
1000-N02
20091115
JE
200911
000000006
2000-N05
20091115
JE
200911
000000007
1000-N06
20091211
JE
200912
000000008
2000-N05
20091215
Inv1
200912
Postings 1000-N03, 1000-N05, and 2000-N04 are not assigned sequence numbers because the daybooks to which they are posted belong to layers that are excluded from additional GL numbering.
Posting 2000-N01 is assigned sequence number 000000001 because it has the earliest numbering date.
Postings 1000-N04, 2000-N03, 1000-N02, and 2000-N05 have the same numbering date, and their sequence numbers are assigned in order by daybook code, and then by entity code.
Example:  
This example uses correction postings for Entity 1000 and Entity 2000.
The following are the correction postings:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-C01
JE
200913
20091201
20091220
20091201
1000-C02
JE
200913
20091203
20091215
20091231
1000-C03
Inv1
200913
20091207
20100115
20100115
1000-C04
JE
200913
20091215
20100315
20100315
1000-C05
Inv1
200913
20091220
20100325
20100325
1000-C06
Inv1
200913
20091225
20100404
20100404
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-C01
JE
200913
20091209
20100109
20100109
2000-C02
JE
200913
20091231
20100225
20100225
Using Journal Entry Approve, you approve postings 1000-C03, 1000-C04, and 1000-C05, and specify their numbering date as 20100331. Posting 1000-C06 does not need to be approved at this time so you manually modify its numbering date to 20100331.
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-C01
JE
200913
20091201
20091220
20091201
1000-C02
JE
200913
20091203
20091215
20091231
1000-C03
Inv1
200913
20091207
20100115
20100331
1000-C04
JE
200913
20091215
20100315
20100331
1000-C05
Inv1
200913
20091220
20100325
20100331
1000-C06
Inv1
200913
20091225
20100404
20100331
2000-C01
JE
200913
20091209
20100109
20100109
2000-C02
JE
200913
20091231
20100225
20100225
In addition, Entity 1000 and Entity 2000 contain the following normal postings in GL periods 2010/01 to 2010/02:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-N07
JE
201001
20100101
20100101
20100101
1000-N08
JE
201002
20100201
20100201
20100201
1000-N09
Inv1
201003
20100301
20100301
20100301
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-N06
JE
201001
20100120
20100120
20100120
2000-N07
JE
201002
20100220
20100220
20100220
2000-N08
Inv1
201003
20100320
20100320
20100320
You try to run GL Sequence Renumber for Entity 1000 for GL periods 201001 to 201002. The renumbering process fails for 1000-C01 and 1000-C02 because these postings must be numbered within GL period 200912 before you can proceed to renumber GL periods 201001 and 201002.
You run GL Sequence Renumber again for GL period 200912, and the system creates the following numbered postings:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000007
1000-C01
20091201
JE
200913
000000008
1000-N06
20091211
JE
200912
000000009
2000-N05
20091215
Inv1
200912
000000010
1000-C02
20091231
JE
200913
Finally, you run GL Sequence Renumber for Entity 1000 for GL periods 201001 to 201002. The system creates the following numbered postings:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000011
1000-N07
20100101
JE
201001
000000012
2000-C01
20100109
JE
200913
000000013
2000-N06
20100120
JE
201001
000000014
1000-N08
20100201
JE
201002
000000015
2000-N07
20100220
JE
201002
000000016
2000-C02
20100225
JE
200913
 
Example:  
On April 6, 2010, you run Year-End Closing Execute (25.21.4.1), and specify the numbering date as March 31, 2010. The system creates the following closing postings:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-Y01
Year-End
200913
20091231
20100406
20100331
1000-Y02
Year-End
200914
20091231
20100406
20100331
1000-Y03
Year-End
200914
20091231
20100406
20100331
1000-Y04
Year-End
201000
20100101
20100406
20100331
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-Y01
Year-End
200913
20091231
20100406
20100331
2000-Y02
Year-End
200914
20091231
20100406
20100331
2000-Y03
Year-End
200914
20091231
20100406
20100331
2000-Y04
Year-End
201000
20100101
20100406
20100331
You run GL Sequence Renumber for Entity 1000 for GL period 201003. Entity 1000 is the numbering source for both Entity 1000 and Entity 2000. The following sequence numbers are assigned:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000017
1000-N09
20100301
Inv1
201003
000000018
2000-N08
20100320
Inv1
201003
000000019
1000-C03
20100331
Inv1
200913
000000020
1000-C05
20100331
Inv1
200913
000000021
1000-C06
20100331
Inv1
200913
000000022
1000-C04
20100331
JE
200913
000000023
1000-Y01
20100331
Year-End
200913
000000024
1000-Y02
20100331
Year-End
200914
000000025
1000-Y03
20100331
Year-End
200914
000000026
1000-Y04
20100331
Year-End
201000
000000027
2000-Y01
20100331
Year-End
200913
000000028
2000-Y02
20100331
Year-End
200914
000000029
2000-Y03
20100331
Year-End
200914
000000030
2000-Y04
20100331
Year-End
201000