Skip to Content
User Experience Insights
Author's profile photo Juwin Pallipat Thomas

F2548 – Upload General Journal Entries

Ref: Apps Library, SAP Help, Prior blogs

Every organization I have worked for as a consultant, have requested a template to upload FI journal entries and hence, I am happy to see that SAP has provided a standard template to do the same with S/4HANA.

But,…. my concern is with the template design. A hierarchical upload template, is that really practical?

All customers I have worked with, and currently working for, have a tabular upload template, which is easier to manually fill in/extract from another external source and allows the users to use further Excel functions on the table, most common of which is a pivot table.

Now, imagine doing a similar Pivot table or a simple SUM on the template provided by SAP.

Looking at the downloaded template, apart from BUKRS, there are no fields which are common between Header and Items. Hence, I feel, just by looking at the fieldnames, the backend programmer could have easily & automatically split the table into Header and Items. Instead, SAP chose to pass that workload onto JE Processor.

As an end-result, what we are now doing, is finding ways to build Excel Macros, to convert the Tabular entry form into Hierarchical upload format.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bjorn Harzer
      Bjorn Harzer

      Agree. This upload template seems to be designed without actual input from real life requirements.

      Author's profile photo Jordan Cronin
      Jordan Cronin

      Hi Juwin, we're running into the same issue. Do you happen to have any sample Excel Macros you could share? I'd be most grateful. Thanks!

      Author's profile photo Archana Balliwar
      Archana Balliwar

      We have the exact same requirement. Could you please elaborate on macros that you leveraged?

      Author's profile photo Jordan Cronin
      Jordan Cronin

      So I ended up building a PowerAutomate flow that runs an OfficeScript inside Excel online. It uses a Power App as a front end for end-users to upload a filled-out user-friendly template that converts it into SAP's format.