Can an Excel Journal template be modified to allow upload to multiple periods at once?
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
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
