Journal Entry Uploader – 1709 Ver and Above

It is very important to have excel template to post massive line items in one transaction, in S/4 HANA 1709 On-premise we have two options for JV upload, they are

  1. Use “Upload General Journal Entries” Fiori app (App ID – F2548)
  2. Use “LTMC” – S/4HANA Migration Cockpit – Migrate your Data to SAP S/4HANA

1. Use “Upload General Journal Entries” Fiori app (App ID – F2548)

you can post journal entries by uploading a templated file that contains entry header and line item information. Postings can be made in all relevant ledgers for the accounts for which you are responsible. If not all the journal entries in a file are uploaded successfully, you must correct errors, copy the batch ID of the initial upload to the file, and then repeat upload. You can perform posting journal entries that are successfully uploaded. You can also navigate from the Post General Journal Entries app to the Upload General Journal Entries app by clicking the Upload New Entry button.

Click here to view the App on Fiori library

Click here to view App information F2548

2. Use “LTMC” – S/4HANA Migration Cockpit – Migrate your Data to SAP S/4HANA



Thank you


Source : SAP


Key Features of SAP S/4 HANA FINANCE – 1709 On-premise Principales características de SAP S / 4 HANA FINANCE 1709 On-Premise

It’s high time to learn new Finance automation process and accept changes that comes with SAP Leonardo for faster decision making, adaptability, innovation, business acceleration, better outcomes.

Let’s go through the “Finance – Innovations”

  • Universal Journal: Subsequent implementation of document split
  • Parallel valuation: 3rd currency in Controlling and Cost of Goods Manufactured.
  • Accounting: General ledger document split
  • Financial Planning: Basic Sales Planning (Activity Price, Consumption)
  • Cash Management: Bank relationship management including bank fee analysis; Improved Integration with Bank Communication Management and In-House Cash
  • Machine Learning for Cash Application – Invoice Matching clear incoming payments by matching them with the corresponding receivables
  • Soft close and prediction: Minimum closing time; Early insight into business trends
  • Integration: Seller-side integration with Ariba Network (invoice and discount management); Cost center (SuccessFactors); Payment advice (Fieldglass); Ariba Pay/ Supply Chain Finance
  • Central finance
  1. Shared Services in Accounts Payables/Receivables
  2. Central reversal and correction capabilities
  3. financial reporting scenarios
  • SAP Fiori apps Roles
  1. Accounts Payable/Receivable Accountant
  2. Accounts Receivable Manager
  3. Controller (Production Costs, Credit)
  4. Treasury Risk Manager
  5. Asset Accountant
  6. General Ledger Accountant
  7. Inventory Accountant


Topic – 1: Universal Journal – subsequent introduction of document splitting

To fulfill the IFRS reporting requirements, you need to report your financial data at a lower level of detail than your company code. With this feature, you can introduce new account assignment objects, such as segment or profit center, and add these account assignments to your journal entries when you post them. To ensure that you have a complete reporting view of each account assignment object, the opening balance is enriched and split, per account. The enrichment of relevant accounting data is carried out in the project cockpit, according to the new account assignment information. To ensure correct processing of open items, at the time document splitting is active, this feature allows you to enrich open items.


Topic – 2: Machine Learning – SAP Cash Application Integration

SAP Cash Application is a cloud service that integrates with S/4HANA Cloud Edition as of 1702 and S/4HANA on-premises as of 1709 (hybrid model).

The integration to SAP Cash Application solution intends to automate the invoice-matching process and provide the prediction results back to the SAP S/4HANA system with the help of machine learning.

SAP Cash Application enables you to match open receivables to incoming bank statement items using machine learning.

In the finance area, and more specifically in the area of accounts receivables, incoming bank statement items are ideally matched automatically to open receivables such as invoices. Any manual post-processing of incoming bank statement items that could not be matched to open receivables takes time and effort. SAP Cash Application uses machine learning procedures to train financial applications in order to learn from manual matchings, and thus achieve higher automatic matching rates.

 Key functionalities of SAP Cash Application:

⊕ Proposing open receivables for incoming bank statement items

You can schedule jobs to receive a list of Machine Learning proposals for matching receivables to existing bank statement items

⊕ Clearing incoming bank statement items.

You can schedule jobs to automatically clear incoming bank statement items based on Machine Learning proposals, if the following conditions are met:

  • The matching rate of the proposal is higher than specified in the configurations
  • The proposed receivables are still open
  • All other clearing rules are fulfilled

 Proposing customer accounts for incoming bank statement items

You can schedule jobs to receive a list of Machine Learning proposals for matching accounts to existing bank statement items.

  • The matching rate of the proposal is higher than specified in the configurations
  • The proposed account is a valid existing account

 Posting incoming bank statement items

You can schedule jobs to automatically post incoming bank statement items to accounts based on Machine Learning proposals.

SAP Cash application detailed workflow:


Topic – 3: Intercompany Reporting 

  • Shows reconciliation amount and difference in object group for company and its partner
  • Drills down to line item details
  • Displays detailed information of document
  • Shows the reconciliation processing status
  • Navigates to reconciliation monitoring page for manual reconciliation
  • Sends mail and reminder to contact person


Topic – 4:  Profitability Analysis in the Universal Journal

Splitting Cost of Goods Sold in SAP S/4HANA

Enhanced functionality enables to split costs of goods sold during more processing such as third party or other processes with account assignment to internal orders or projects

COGS Splitting customizing has been adjusted

Previous COGS Split functionality which processed the splitting only for goods movements with reference to a sales order is still available

Splitting Cost of Goods Sold in SAP S/4HANA 1610 Screen and 1709 Screen



Topic – 5: Material Valuation in S/4HANA  – Material Ledger

  • Up to 3 currencies
    • Tracking historic rates in material master
    • Local legal valuation & e.g. hard or trading currency2017-08-05_010324.jpg
  • Actual Costing
    • Optional revaluation of stock and COGS
    • Leverage Actual cost component split

Thank You

Jayanth Maydipalle

Source: SAP, JAM, ML, AI and Other.