Main menu
Member section cover

BLOG

ERPCorp SAP FICO Blog

Electronic Bank Statement & Lockbox in SAP ERP: How is the lockbox file different from the electronic bank statement file?

Lennart Ullmann SAP Electronic Bank StatementHow is the lockbox file different from the electronic bank statement file?

The lockbox file contains the remittance information the customers have sent to the bank, for example amount and number by invoice. That level of payment information allows easy reconciliation and clearing of open items in SAP Accounts Receivable. It is normally used for check payments only.

Within the electronic bank statement file you can have various types of payment transactions. The remittance information in the electronic bank statement file is limited and provides you with the consolidated amount paid by the customer. It is possible to use only one of these services, or both in combination, depending on the company’s needs. When using lockbox and electronic bank statement it is important to set up the posting rules in SAP correctly to avoid incorrect postings. The main lockbox program will debit the bank clearing account for accounts receivables and post a credit entry to the bank clearing account for incoming checks (lockbox). In a second posting area, the program will debit the bank clearing account for incoming checks and clear open items in the customer accounts. The remaining open items on the bank clearing account for accounts receivables will be cleared through the electronic bank statement. The electronic bank statement will debit the main bank account and credit the bank clearing account for accounts receivable.

Excerpt from Electronic Bank Statement & Lockbox in SAP ERP by Lennart Ullmann and Claus Wild.

Continue reading
  14854 Hits
  0 Comments
14854 Hits
0 Comments

Introduction to Reconciling SAP COPA to the General Ledger


b2ap3_thumbnail_IMG_3683.jpg

You may wonder why I am writing a book on such a specific topic. I initially had similar thoughts myself and wondered if the topic of CO-PA and general ledger reconciliation necessitated a whole book. However, I have found that this topic comes up time and time again with my clients and believe that it is important to provide information in a detailed manner to help businesses effectively deal with the reconciliation of CO-PA to the general ledger.

Continue reading
  12937 Hits
  0 Comments
12937 Hits
0 Comments

Book Excerpt: Introduction to Configuration from The Essential SAP Career Guide


b2ap3_thumbnail_IMG_3683.jpgOne of the major tasks for functional SAP professionals is configuration. You configure SAP to perform properly based on business requirements during the realization phase. On your first SAP project, it can be overwhelming to know where to start when configuring a module.

Continue reading
  8155 Hits
  0 Comments
8155 Hits
0 Comments

Controlling 2013 Video - Future of SAP e-books

b2ap3_thumbnail_John-Martin-Video-Image.jpgIn this SAP Controlling 2013 interview, Jon Reed of Jon ERP and Martin Munzel of Espresso Tutorials discuss the future of SAP e-books.

Continue reading
  10257 Hits
  0 Comments
10257 Hits
0 Comments

Most Common SAP Controlling Pitfall: Beyond Cost Center Accounting – there’s more to SAP CO than meets the eye!

Martin MunzelOur blog series on the most common SAP Controlling pitfalls and how to avoid them continues this week. SAP Controlling 2013 speaker Martin Munzel discusses the most common pitfall is from his perspective.

A common error I have found in companies using SAP CO is that they were trying to make some of the submodules do things they are not designed for.

Continue reading
  16180 Hits
  1 Comment
Recent comment in this post
Guest — Michel
What about cross-department costs, such as buying company cars or office supplies, should they be accounted for on a separate cost... Read More
Wednesday, 23 January 2019 17:29
16180 Hits
1 Comment

Controlling 2013 Speaker Profile: Jörg Siebert, SAP FI/CO Specialist and Co-founder of Espresso Tutorials

This week we are profiling Controlling 2013 speaker Jörg Siebert, SAP FI/CO Specialist and Co-founder of Espresso Tutorials.

How did you get your start with SAP and SAP Controlling? 

When I started my first real job in 1993, I worked for a small software company in Mannheim, Germany.  At that point of time, I had my first contact with business software.  Later on in 1999 when I joined Ernst & Young, the SAP world of Finance and Controlling became my main focus. From 2001 through 2011, I worked for SAP in Walldorf pushing forward with the newest inventions in Finance and Controlling.

Continue reading
  11780 Hits
  0 Comments
11780 Hits
0 Comments

Controlling 2014 Speaker Profile: Martin Munzel, SAP CO/PS Specialist and Co-founder of Espresso Tutorials

Martin MunzelThis week we are profiling Martin Munzel, SAP CO/PS Specialist and co-founder of Espresso Tutorials. Learn more about Martin and his view on what is most important to his customers. 

Continue reading
  9002 Hits
  0 Comments
9002 Hits
0 Comments