0

F2548 – Upload General Journal Entries

 1 year ago
source link: https://blogs.sap.com/2021/03/28/f2548-upload-general-journal-entries/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
User Experience Insights
Posted on March 28, 2021 1 minute read

F2548 – Upload General Journal Entries

0 Likes 14 Views 0 Comments

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.

2021-03-28-08_24_24-JournalEntry_Template-Excel.png

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.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK