Lock Box Configuration
What are the steps for lock box configuration?
Lock Box Config:
Master Data Settings
General Ledger Accounts:
XXXXX has three lockbox clearing accounts:
Company Code 1000 – G/L account 1201005, First Union
Bank
Company Code 1000 – G/L account 1201006, PNC, Bank
Company Code 2000 – G/L account 1201008, Wachovia, Bank
General Ledger Account Master Record Settings:
Cash G/L accounts exist for each bank. For example account
1105012 is for PNC Bank. If you look at the G/L account master record for
this account (Accounting -> Financial Accounting -> General Ledger -> General
Ledger -> Master Records -> Display, transaction FS03) you will notice
the 'Relevant to Cash Flow' field is checked.
Customer Master Record Settings:
In order for the lockbox program to identify a customer
the payment MICR must be populated on the customer master record in the
General Data: Payment Transactions screen. The remit-to lockbox assignment
must also be specified. Regarding the tolerance group assignment, XXXXX
only has one configured that is a blank customer tolerance. By defining
a blank tolerance group the tolerance group field may remain blank on each
customer master record but the tolerance settings are applicable. The tolerance
configuration will be reviewed in the next few slides. Finally an alternative
payer should be entered on a customer master record if another customer
account will pay the bills for the customer.
Lockbox Assignment on Customer Master Lockboxes are assigned
on customer master records and determine which remit to address is printed
on the customer's invoices
Tolerance Settings
When an incoming cash payment does not exactly pay the
referenced open item(s), the system will create a residual item back on
the customer's account or write-off the difference if tolerance limits
are configured.
In SAP tolerance limits are set for users and customer
accounts with the stricter limits applying.
SPRO -> Financial Accounting -> Accounts Receivable and
Accounts Payable -> Business Transactions -> Manual Payment Receipt ->
Define Tolerance Groups for Employees
Transaction: OBA4
This transaction is used to create tolerance groups for
users. The tolerances are defined by company code and at a minimum there
must be one assigned to each company code otherwise no postings can occur
in the company code.
Company Code
Currency
Amount per Document – The maximum amount that can be
posted in an accounting document.
Amount per Open Item Account Item – the maximum amount
that can be posted to a customer or vendor account.
Cash Discount per Line Item – the maximum cash discount
percentage that can be applied to a line item.
Amount, Percent, Cash Discnt Adj. To (Both Revenue and
Expense) – the amount field contains the maximum amount of a customer overpayment
(Revenue)/underpayment (Expense). The percent field is the maximum percentage
rate difference posted by the system. The lower limit between the amount
and percentage applies.
Configuration: Define Tolerances (Customers/Vendors)
SPRO -> Financial Accounting -> Accounts Receivable and
Accounts Payable -> Business Transactions -> Incoming Payments -> Define
Tolerances (Customers/Vendors)
OR
SPRO -> Financial Accounting -> Accounts Receivable and
Accounts Payable -> Business Transactions -> Outgoing Payments -> Manual
Outgoing Payments -> Overpayment/Underpayment ->Define Tolerances (Customers/Vendors)
Transaction: OBA3
This transaction is used to configure customer tolerances.
To change a tolerance select the company code then press the Details icon.
Configuration: Define Reason Codes
Transaction OBBE is used to configure reason codes by
company code. All new reason codes must be configured in each company code.
Configuration: Define Text : Transaction OB56 is used
to configure the text that appears on a line item based on the reason code
entered.
Configuration: Define Accounts for Overpayments/Underpayments
: Transaction OBXL is part of the automatic account assignment. The GL
account for overpayments/underpayments is maintained here.
Configuration: Define Posting Keys : Transaction OB41
is used to configure posting keys. Posting keys are two-digit numeric keys
that control the entry of document line items. Specifically it controls
the account type, debit/credit posting, and layout of entry screens.
Get help for your SAP FI/CO problems
SAP FICO Forum
- Do you have a SAP FI/CO Question?
SAP Books
SAP
FICO Books - Certification, Interview Questions and Configuration
SAP FICO Tips
SAP FI/CO Tips
and Financial Accounting/Controlling Discussion Forum
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.erpgreat.com is in no way affiliated with
SAP AG.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|