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

JV

JV

Thank you

Jayanth

Source : SAP

Advertisement

CREATE BANK ACCOUNTS ON FIORI / NWBC

Below mentioned Roles are required to activate “Manage bank accounts” app on Fiori.

The user must be assigned with role:

  • SAP_BR_CASH_SPECIALIST (for On-premise Edition)
  • SAP_BCR_FIN_CM_BAM_MC (for Cloud Enterprise Edition)
  • SAP_BCR_FIN_CM_BANK_ACC_MGM (for Cloud Project Services Edition)
BACK-END SERVER: ACTIVATE WEB DYNPRO APPLICATION:

Component: Web Dynpro Application

Technical Name: WDA_FCLM_BAM_HIERARCHY

Use transaction “SICF” and make sure that the ICF service for the Web Dynpro application is activated.

BACK-END SERVER: ASSIGN ROLE WITH START AUTHORIZATION FOR WEB DYNPRO APPLICATION:

Component: Back-End Role

Technical Name: SAP_SFIN_CASH_MANAGER

2016-12-09_133039

The Manage Bank Accounts transactional app provides an overview of your bank accounts in a hierarchical structure and allows you to maintain bank account master data according to your organization’s business requirements, as shown in

2016-12-09_134425.png

Thank You

Jayanth

FIORI – Account Determination

SAP is now providing “Accounting determination” using Fiori for On-Premise 1610 release or higher. Let us deep dive into the steps of “Accounting determination” fiori app functionality.

The central task of G/L accounting is to provide a comprehensive picture of external accounting and accounts. Recording all business transactions (primary postings as well as settlements from internal accounting) in a software system that is fully integrated with all the other operational areas of a company ensures that the accounting data is always complete and accurate.

General Ledger Accounting is integrated with all application components of the SAP System that generate posting data of relevance to General Ledger Accounting:

“Accounting Determination” app allows us to do below mentioned integration activities,

1.      FI-GL

  • Foreign currency Valuation
  • Transfer and sort Receivables and Payables
  • Retained earnings account

2.      FI-MM Integration “OBYC”

3.      FI-SD Integration “OVKA”

Below mentioned are front-end, back-end and OData service roles needs to be assigned to view the “Account Determination” fiori app.

·        oData Service : FAC_ACC_DETERMINATION_SRV

·        Back-End Authorization Role (PFCG): SAP_BR_GL_ACCOUNTANT

·        Technical Catalog: SAP_TC_FIN_ACC_COMMON

Business Role: SAP_BR_GL_ACCOUNTANT

FI-GL Integration

Select Subarea as “General Ledger Accounting”

  • Foreign currency valuation. Currently, only transaction key KDF (under transaction group FWA) is supported. It covers T-code OBA1, tables T030H and T030HB.

Hit on Step 2 to assign the Exchange gain/loss GL accounts

Retained earnings account, it corresponds to T-code OB53, tables T030 and T030B

Click on Step 2 to select the parameters

Click on Step 3 to assign retained earnings account

Bank Account Determination for Payment Transactions in AP/AR: In ERP, it is a view cluster VC_BANKDET that can be launched in SM34. The app only supports one branch in the view cluster, for example, ‘Bank Accounts’.

Click on Step 2 to assign Bank determination GL accounts,

Using this app we do similar configuration that we do in GUI transaction – FBZP bank determination (below screen refers GUI screenshot)

 Let us do bank determination on Fiori now,

This series of articles Accounting determination on Fiori is divided into three parts,

  1.   Financial Accounting (FI-GL) https://www.linkedin.com/pulse/account-determination-fiori-jayanth-maydipalle-
  2. Material Management (FI-MM Integration) https://www.linkedin.com/pulse/account-determination-fi-mm-integration-fiori-app-maydipalle-?published=t
  3. Sales and Distribution (FI-SD Integration)