Can an Excel Journal template be modified to allow upload to multiple periods at once?

[kmd]

Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file?

If it's possible, can anyone provide a brief how-to for setting something like this up?  The request is to be able to upload this to a forecast scenario so it's really outside the normal parameters of a typical journal.

I know one easier alternative is to create an _ADJ member and just load the data to that but that's not the ask from the team.

Would be grateful for any advice.  Thanks

[lzwebb]

Yes, there is a template that can be leveraged to load all periods at once.  You have a line for the header and lines for the detail.  

[kmd]

That's great - thanks.  Are you able to provide the name and/or location of that template?  I'm wondering if it's just not yet available in our version of OS.  Thanks very much

[lzwebb · Accepted solution]

It doesn't look like there is a specific template for it.  I created one off the original JE template.  Doesn't look like I can upload it here, but I did a copy/paste below.  Each month would need to have 1 header row and at least 1 Detailed row.  You put the period in the header row.

!H (RowType Header)

JournalName

OriginatingTemplateName

JournalDescription

JournalType

JournalBalanceType

IsSingleEntity

EntityMemberFilter

ConsName

WFProfileName

WFScenarioName

WFTimeName

!D (RowType Detail)

JournalName

CubeName

EntityName

ParentName

AccountName

FlowName

ICName

UD1Name

UD2Name

UD3Name

UD4Name

UD5Name

UD6Name

UD7Name

UD8Name

DebitAmount

CreditAmount

LineDescription

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M7

LineDescription

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M8

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M9

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M10

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M11

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

H

MultiPeriod JE

MultiPeriod Adjustment

Standard

Unbalanced

FALSE

Local

TEST.ADJ

Actual

2021M12

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_CR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

0

3159388.2

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST

MULTIPERIOD_TEST

D

MultiPeriod JE

TEST_CUBE

TEST_ENTITY

TEST_ACCOUNT_DR

FLOW_TEST

None

TEST_UD1

TEST_UD2

None

TEST_UD4

TEST_UD5

TEST_UD6

TEST_UD7

None

3159388.2

0

MULTIPERIOD_TEST