Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor III
21 hours ago

Loading a Journal Excel Template into Multiple Periods

Hi, is there syntax similar to forms to load journals into multiple wf periods?

My WF is 1 period, 12 months:

I tried using similar syntax to form loads:

Template set up as monthly:

And I return no messages when I load. Confirmed xfj range is set up on file and all dimensions match. Thinking maybe its my "Time" thats preventing the journal from getting into the system and want to confirm I have valid syntax.

Maybe the other option is to set Workflow Time to 2026M1 and make individual journals for each period:

Is it possible to do all months in 1 journal?

Excel Add In
Reports

1 Reply

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    1 hour ago

    I don't think it's possible. The Journal Header specifies the Workflow Time which will apply to all the Detail rows in that named range. You can have more than one named range though either on the same worksheet or multiple worksheets. So you could have a sheet for 2026M1 and another for 2026M2 etc