aierp1

SAP Finance Part-1

Table of Contents Enterprise Structure Localize Global company code 0001 setting Tcode : O035 SAP supplied sample company code is 0001. This is country independent. So if the implementation is for USA this is localize for country US installation. This is than copied to the new organization units. This will copy below settings for country […]

SAP Finance Part-1 Read More »

SAP Treasury End User Training Part 1

Table of Contents SAP Treasury & Risk Management-End User Training   Money Market Instruments   Interest Rate Instruments- End User Training   Interest Rate Instruments Functionality An interest rate instrument is a money market transaction with additional structural characteristics, such as variable interest and installment repayment.   End to End Business Process for Interest Rate

SAP Treasury End User Training Part 1 Read More »

SAP Treasury and Risk Management Part 2

Define Account Determination

IMG- FSCM – Treasury & Risk Management- Transaction manager – General Settings-Accounting- Link to Other Accounting Components

Here we link the GL accounts to Account assignment reference. This activity covers many tasks which are explained as below.

Define Account Symbols

Account Symbols represent GL Accounts. SAP has defined several standard account symbols. Can add new ones if required.

Business Definition Account Symbols SAP Definition
Short Term Investment 1 Position
Cash 3 Bank Clearing
Interest Receivable 5.1.2 Acc. Receivable Interest
Interest Income 4.1.1 Interest Gain
Unrealized FX Gain 4.9.4.2 Increase FX
Unrealized FX Loss 4.9.3.2 Decrease FX
Realized FX Gain 4.9.2.1 Realized Gain FX
Realized FX Loss 4.9.1.1 Realized Loss FX

Define Posting Specs

It links Account symbols defined in earlier step with Posting type (Balance Sheet, Profit/Loss) and Debit or Credit accounting entry. For our configuration below posting specs are required.

Posting Spec Description Debit Symbol Credit Symbol
11100 Investment Increase 1 3
13900 Interest Accrual 5.1.2 4.1.1
15700 Balance Sheet Revaluation (loss) 4.9.3.2 1
15300 Balance Sheet Revaluation (gain) 1 4.9.4.2
15400 Reset FX Gain 4.9.4.2 1
15800 Reset FX Loss 1 4.9.3.2
11200 Investment Decrease 3 1
11210 Interest Receipt 3 5.1.2
12300 Realized FX Gain 1 4.9.2.1
12400 Realized FX Loss 4.9.1.1 1
15430 Move FX gain from unrealized to realized 4.9.4.2 4.9.2.1
15730 Move FX loss from unrealized to realized 4.9.1.1 4.9.3.2

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Assign Update Types to Posting Specs

Assign Update Type to Posting specs defined in last step.

A screenshot of a computer Description automatically generated

Assignment of GL Accounts to Account Symbols

A screenshot of a computer Description automatically generated

This content is for Silver Level members only.
Login Join Now

SAP Treasury and Risk Management Part 2 Read More »

SAP Treasury & Risk Management Part 1

Table of Contents General Settings Maintain Calendar IMG: SAP Netweaver – General Settings – Maintain Calendar The Factory Calendar is relevant for the Treasury. Ensure Factory calendar is maintained for current year. Click change and ensure Factory Calendar is valid for current year Assign Holiday calendar to factory calendar. Verify assigned holiday calendar has the

SAP Treasury & Risk Management Part 1 Read More »

SAP QUERY

Table of Contents SAP Query Purpose SAP Query enables data from multiple tables to be extracted in one report, provided at least one field from one table can be linked to another table There are two methods of creating query in SAP SAP Quick Viewer: Query created by this method is user specific –i.e. the

SAP QUERY Read More »

SAP Foreign Currency

Table of Contents Foreign Currency Valuation Foreign Currency Valuation in SAP FASB 52: is issued by US accounting standard board. It provides guidance on financial reporting of companies operating in foreign countries Functional Currency: Currency of the economic environment in which the entity operates. In case of SAP functional currency is generally company code /

SAP Foreign Currency Read More »

SAP Substitutions

Table of Contents Substitution in SAP What is the substitution The substitution function can be used to substitute a value to some fields which is included in line item table BSEG or header table BKPF. And the substitutions are valid for both the manual entry of documents and the automatic created entry of documents (for example, payment program). You can define

SAP Substitutions Read More »

error: Content is protected !!