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.