How to Upload a Journal Entry in Sap

Accounting professionals often need to upload multiple journal entries in one get. This could be during month-end or year-end processing, for uploading accruals and provisions, or for other specific purposes. In the case of month-end entries, these would be well-nigh the aforementioned from month to month, except maybe for small differences in amounts.

Until recently, they had no alternative but to develop a custom program or use an external third-party tool. In ECC versions of SAP, there was no fashion to upload multiple Journal entries.

SAP S/4Hana with Fiori attempts to solve this nagging trouble via a new app called "Upload Full general Periodical Entries"

The steps to do a mass upload of journal entries in SAP Fiori are described beneath.

Footstep ane – Open up Fiori App F2548

Start by opening the Upload General Journal entries app from Fiori.

The following screen will exist displayed.

Step two – Download the template

At the right bottom of the screen, there is an icon to download the template. Click on the icon to download a spreadsheet template.

The template can be downloaded either in .xlsx or .csv format. For our example, we will use the .xlsx format.

Pace 3 – Fill in the template

The template consists of a few lines of bones information and instructions (up to line 5) and so the individual accounting entries.

Each accounting entry is differentiated by the "Header" Line. To create more than accounting entries, copy the entire section (Header + Line items) and give information technology the next number. Then in this case the adjacent entry would like this (Entry no.3)–

Some tips and tricks to fill in the template:

ane.      The Header consists of exactly ane line. Information technology contains basic information (corresponding to SAP table BKPF) like Company Code, Date, Header text, Document Currency, and then on.

two.      Mandatory fields are indicated past an "*" symbol side by side to the field description.

3.      The date format is commonly YYYYMMDD.

4.      You lot can enter every bit many line items (corresponding to SAP tabular array BSEG) as y'all wish (subject to standard SAP restrictions on line items)

5.      Debit and Credit amounts are entered in carve up columns hence there is no need for posting keys or a negative sign for credit.

Step four – Upload the template

In one case the template is ready, go back to the app and upload the template.

If there are errors in upload (like missing price objects, wrong appointment format), the organisation volition display the error log. The user needs to analyze the logs, and go back to the template and rectify the mistakes.

Later on rectifying the problems, upload is attempted again. If it is successful, SAP will create accounting documents with the condition "Held". The post-obit system message is displayed.

Step 5 – Post the journal entries

In the side by side stride, the "held" entries are posted. In the Fiori screen above, you volition find a "Post" icon at the right bottom corner. Click on the "Postal service" icon to continue.

The system now finally generates the certificate number, which is additional evidence of the journals being posted

In this case, the document numbers are 1000000001 and 1000000002

Users can view the document using the Manage Journal Entries Fiori App or the FB03 transaction in SAP GUI.

Conclusion

SAP Fiori has made it very easy to upload more than one entry using a unmarried template, without the demand for any custom evolution or external development. Business organization Users should find this feature very useful, especially during calendar month-stop or year-stop processing.

Known Restrictions

There are some limitations when using this app. This app works but with General Ledger accounts (i.east for posting keys forty and l). Information technology does not work for customer and vendor lines. For mass upload of customer or vendor lines, a custom development would still be required.

Want to Learn More than?

More than Information near the Fiori app is available on the SAP Fiori Apps Library. Also, check out the S/4 Finance - General Journal Upload with Fiori class on MMC to swoop deeper into the Upload General Periodical Entries, acquire how to create and edit templates, resolve common issues that may come up upward, and get your Full general Journal Upload certification.

freemansweves.blogspot.com

Source: https://www.michaelmanagement.com/blog/sap/mass-upload-multiple-journal-entries-in-sap-fiori

Share this post