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
201411
Normal
11/01 - 11/30
201412
Normal
12/01 - 12/31
201413
Correction
12/15 - 12/31
201414
Year-End Closing
N/A
201500
Year-End Closing
N/A
201501
Normal
01/01 - 01/31
201502
Normal
02/01 - 02/28
201503
Normal
03/01 - 03/31
201504
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 2014, Entity 1000 and Entity 2000 contain the following postings:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-N01
JE
201411
20141110
20141120
20141110
1000-N02
JE
201411
20141115
20141115
20141115
1000-N03
Trans1
201411
20141115
20141115
20141115
1000-N04
Inv1
201411
20141115
20141115
20141115
1000-N05
Inv2
201411
20141115
20141115
20141115
1000-N06
JE
201412
20141211
20141218
20141211
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-N01
JE
201411
20141109
20141109
20141109
2000-N02
JE
201411
20141115
20141115
20141115
2000-N03
Inv1
201411
20141115
20141115
20141115
2000-N04
Trans1
201411
20141120
20141120
20141120
2000-N05
Inv1
201412
20141215
20141215
20141215
You run GL Sequence Renumber for Entity 1000 for periods 201411 and 201412. 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
20141109
JE
201411
000000002
1000-N01
20141110
JE
201411
000000003
1000-N04
20141115
Inv1
201411
000000004
2000-N03
20141125
Inv1
201411
000000005
1000-N02
20141115
JE
201411
000000006
2000-N05
20141115
JE
201411
000000007
1000-N06
20141211
JE
201412
000000008
2000-N05
20141215
Inv1
201412
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
201413
20141201
20141220
20141201
1000-C02
JE
201413
20141203
20141215
20141231
1000-C03
Inv1
201413
20141207
20150115
20150115
1000-C04
JE
201413
20141215
20150315
20150315
1000-C05
Inv1
201413
20141220
20150325
20150325
1000-C06
Inv1
201413
20141225
20150404
20150404
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-C01
JE
201413
20141209
20150109
20150109
2000-C02
JE
201413
20141231
20150225
20150225
Using Journal Entry Approve, you approve postings 1000-C03, 1000-C04, and 1000-C05, and specify their numbering date as 20150331. Posting 1000-C06 does not need to be approved at this time so you manually modify its numbering date to 20150331.
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-C01
JE
201413
20141201
20141220
20141201
1000-C02
JE
201413
20141203
20141215
20141231
1000-C03
Inv1
201413
20141207
20150115
20150331
1000-C04
JE
201413
20141215
20150315
20150331
1000-C05
Inv1
201413
20141220
20150325
20150331
1000-C06
Inv1
201413
20141225
20150404
20150331
2000-C01
JE
201413
20141209
20150109
20150109
2000-C02
JE
201413
20141231
20150225
20150225
In addition, Entity 1000 and Entity 2000 contain the following normal postings in GL periods 201501 to 201502:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-N07
JE
201501
20150101
20150101
20150101
1000-N08
JE
201502
20150201
20150201
20150201
1000-N09
Inv1
201503
20150301
20150301
20150301
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-N06
JE
201501
20150120
20150120
20150120
2000-N07
JE
201502
20150220
20150220
20150220
2000-N08
Inv1
201503
20150320
20150320
20150320
You try to run GL Sequence Renumber for Entity 1000 for GL periods 201501 to 201502. The renumbering process fails for 1000-C01 and 1000-C02 because these postings must be numbered within GL period 201412 before you can proceed to renumber GL periods 201501 and 201502.
You run GL Sequence Renumber again for GL period 201412, and the system creates the following numbered postings:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000007
1000-C01
20141201
JE
201413
000000008
1000-N06
20141211
JE
201412
000000009
2000-N05
20141215
Inv1
201412
000000010
1000-C02
20141231
JE
201413
Finally, you run GL Sequence Renumber for Entity 1000 for GL periods 201501 to 201502. The system creates the following numbered postings:
 
Sequence
Posting
Numbering Date
Daybook
GL Period
000000011
1000-N07
20150101
JE
201501
000000012
2000-C01
20150109
JE
201413
000000013
2000-N06
20150120
JE
201501
000000014
1000-N08
20150201
JE
201502
000000015
2000-N07
20150220
JE
201502
000000016
2000-C02
20150225
JE
201413
Example:  
On April 6, 2015, you run Year-End Closing Execute (25.21.4.1), and specify the numbering date as March 31, 2015. The system creates the following closing postings:
Entity 1000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
1000-Y01
Year-End
201413
20141231
20150406
20150331
1000-Y02
Year-End
201414
20141231
20150406
20150331
1000-Y03
Year-End
201414
20141231
20150406
20150331
1000-Y04
Year-End
201500
20150101
20150406
20150331
Entity 2000
 
Posting
Daybook
GL Period
Posting Date
System Date
Numbering Date
2000-Y01
Year-End
201413
20141231
20150406
20150331
2000-Y02
Year-End
201414
20141231
20150406
20150331
2000-Y03
Year-End
201414
20141231
20150406
20150331
2000-Y04
Year-End
201500
20150101
20150406
20150331
You run GL Sequence Renumber for Entity 1000 for GL period 201503. 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
20150301
Inv1
201503
000000018
2000-N08
20150320
Inv1
201503
000000019
1000-C03
20150331
Inv1
201413
000000020
1000-C05
20150331
Inv1
201413
000000021
1000-C06
20150331
Inv1
201413
000000022
1000-C04
20150331
JE
201413
000000023
1000-Y01
20150331
Year-End
201413
000000024
1000-Y02
20150331
Year-End
201414
000000025
1000-Y03
20150331
Year-End
201414
000000026
1000-Y04
20150331
Year-End
201400
000000027
2000-Y01
20150331
Year-End
201413
000000028
2000-Y02
20150331
Year-End
201414
000000029
2000-Y03
20150331
Year-End
201414
000000030
2000-Y04
20150331
Year-End
201500