expertsask994@gmail.com
My Account
  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account
Blog
Home FICO Tips on configuring Memo record creation through bank statement load
FICOGeneral SAP

Tips on configuring Memo record creation through bank statement load

ERP College April 8, 2023 0 Comments

Generally big organizations receives bank files daily and it is parked in AL11 folder. In cash management module it is critical to have updated bank balances in SAP.

Through intraday statements bank balance is updated in every 10-15 mins. But intraday statements only carries transactions in delta manner throughout day. So it does not contain opening balance of banks.

So opening balance has to fetch from previous days ending balance. From daily bank recon files.

Let’s see how to achieve that:

Below is sample BAI file format

Bank statement format

This is processed file format, generally when file is received from bank it needs some correction. 

In above file format you can notice from line 4, there are codes like 010, 015 & 045 and after this code there are some values.

Let’s understand what these codes stands for:

010 – opening balance

015 – closing balance

045 – total balance

So while creating opening balance memo record, 045 is crucial code. Value afterwards 045 code is considered as opening balance for memo records.

045 code balance is stored in FEBIP-TOTAL field and then it is considered for opening bal memo records creation.

Read eBook: Manual and electronic bank reconciliation in SAP

Checkout the configuration required for this:

  1. Require Planning level for opening balance
  2. In OT83 transaction BTC Internal external allocation for code 045 (see below screenshot)
OT83 Transacion code

Notice first entry in above screenshot for external transaction 045 with processing type 20.

Without this opening balance memo records will be created without any balance.

Once this setup is in place you can use same bank statement to upload as cash memo records and it will update opening balance of banks in cash management.

Read blogpost: What is MT101 file format and it’s application in SAP

Bank Memo record creation from bank statement in SAP
20
455 Views
AboutERP College
ERP College is a knowledge portal for all of those who want to learn SAP. This is a one-stop reference for your entire SAP needs. Here you will find blogs that will help you to point out daily support issues. The blog covers technical, educational, and psychological aspects of working with SAP, mostly from the point of view of consultants or people responsible for implementing SAP software.
In Socials:
PrevSAP ECC & S4 Server AccessMarch 16, 2023
Adjust budget in WBS Element as per current Exchange rate (Project System)April 29, 2023Next

Related Posts

General SAP

Configure company code for all FICO sub modules

In this blogpost we will see how to configure company code in all FICO sub modules....

ERP College April 19, 2022
FICO

Everything about OB52 authorization group

I am sure many of you know that in OB52 SAP has provided option to keep two sets of...

ERP College January 9, 2022

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 23
  • General SAP 29
  • MM 1
  • SD 2
Products
  • What has been changed in New Asset Accounting
    Rated 4.00 out of 5
    ₹151.06 ₹119.00
  • SAP Asset Accounting (AA) Training ₹1,399.00 ₹1,199.00
  • SAP Accounts Payable (AP) Training
    Rated 4.00 out of 5
    ₹1,999.00 ₹1,699.00
  • SAP Sales and Purchase Tax Training
    Rated 4.50 out of 5
    ₹899.00 ₹699.00
Sign Up to get update of latest Blogs

Find Us

Address
123 Main Street
New York, NY 10001

Hours
Monday–Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Contacts
Website: https://erpcollege.co/
Email: expertsask994@gmail.com
Terms & Condition

Copyright © 2020 ERP College by Smarksys Technologies. All Rights Reserved.