F2548 – Upload General Journal Entries

[Juwin]

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.

[BjornHarzer]

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

[jordancronin]

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!

[archanaballiwar]

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

[jordancronin]

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.

[ben_lerch]

Is there an standard fiori for uploading vendor and client postings?