How Journals Are Copied from Primary to Secondary Ledgers When Accounting Calendars Are Different
As part of setting up a secondary ledger, you select a data conversion level, which determines the level of information that's copied to that ledger.
If you set the data conversion level to Journal, the journal posting process in the primary ledger copies journals to the secondary ledger.
When the primary and secondary ledger use different accounting calendars, journals are copied to the standard period with the same accounting date as the journal. Journals aren't copied to adjusting periods. If your requirement is to post to an adjusting period, then you must manually change the period in the secondary ledger journal.
Period Setup in Primary Ledger
Let's say the accounting calendar for your primary ledger has these periods.
Period Name |
Period Date Range |
Adjusting Period? |
---|---|---|
NOV-20 |
11/1/20 - 11/30/20 |
No |
ADJ-NOV-20 |
11/30/20 - 11/30/20 |
Yes |
DEC-20 |
12/1/20 - 12/31/20 |
No |
ADJ-DEC-20 |
12/31/20 - 12/31/20 |
Yes |
Period Setup in Secondary Ledger
Here are the accounting periods for the secondary ledger accounting calendar.
Period Name |
Period Date Range |
Adjusting Period? |
---|---|---|
NOV-20 |
11/1/20 - 11/30/20 |
No |
ADJ-NOV-20 |
11/30/20 - 11/30/20 |
Yes |
DEC-20 |
12/1/20 - 12/31/20 |
No |
ADJ1-DEC-20 |
12/31/20 - 12/31/20 |
Yes |
ADJ2-DEC-20 |
12/31/20 - 12/31/20 |
Yes |
How Journals Are Copied
Here are some examples that show how journals are copied to the secondary ledger.
Example |
Journal Accounting Date |
Journal Period in Primary Ledger |
Period Status in Secondary Ledger |
Journal Period in Secondary Ledger |
---|---|---|---|---|
1 |
11/10/20 |
NOV-20 |
All are open. |
NOV-20 |
2 |
11/30/20 |
ADJ-NOV-20 |
All are open. |
NOV-20 |
3 |
12/31/20 |
DEC-20 |
Only ADJ1-DEC-20 and ADJ2-DEC-20 are open. |
Not Applicable. The posting process ends in error because the DEC-20 period isn't open. |