calculate Customer Interest Calculation – SAP

Interest calculation:

1. Define terms of payments:
T.code: OBB8
path: IMG ⇒fin. accting⇒AP AR ⇒ Business transactions⇒outgoing invoice and credit memo⇒ maintain terms of payment

2. Define Interest Cal indicators / type:
T.code: OB46
path: IMG⇒fin. accting ⇒ AP AR ⇒ Business transactions ⇒ interest calculation global settings ⇒ define interest cal types
Here in int cal type select ‘p’ for int cal on line items

3. Make Interest Indicator Available to Interest Run

Program:
T.Code: OB82
path: IMG ⇒fin. accting⇒ AP AR⇒ Business transactions ⇒ interest calculation global settings⇒ prepare int. on arreas

4. Create Reference Interest Rate:
T.code: OBAC
path: IMG ⇒fin. accting⇒ AP AR⇒Business transactions⇒ interest calculation⇒ interest calculation⇒ define reference interest rate

5. Assign interest indicators to ref. int rate
or define time dependant terms:
T.code: OB81
path: IMG ⇒fin. accting ⇒ AP AR⇒ Business transactions⇒ interest calculation ⇒ interest calculation ⇒ define time dependant terms
Here in sequence # always use 1 for line item interest

6. Interest calculation account assignment:
Here we will mention how and which accounts the interest program should post.

T.code: OBV1
path: IMG ⇒fin. accting ⇒ AP AR ⇒ Business transactions⇒ interest calculation ⇒ interest posting ⇒prepare interest on arreas calculation (customers)

Cash Discounts in SAP

Create a GL A/c of “Discount Allowed” under “Indirect Expenses”    (FS00), Assign Field status group :G001

Follow the below mentioned path to configure “Terms of Payment” (OBB8)

Click on “Maintain Terms of Payment” ,The following screen Appears

Click on “New Entries”, follow the next screen

Terms of payment has been created,

Now we need to configure for Cash Discount (OBXI) or Follow below mentioned path

In this step, you define the account numbers for your cash discount expense accounts. The system posts the cash discount amount to these accounts when clearing open items.

Note

Your specifications are dependent on the chart of accounts. You can additionally distinguish your specifications by tax code.

Activities

1. Specify your accounts.

2. Make sure that the accounts are created.

Chart of Accounts: “Company Code”

Click on “Accounts”

Click on “SAVE”

Now we need to “Modify Customer Master Data with Discount Term” (FD02)

1. Select the “Customer”
2. Click on “Company Code Data”
3. Select “Payment Transactions”
4. Terms of Payment : “Company Code”
5. Click on “Save”.

Raise Sales Invoice Under F-22

Retain the “Payment Term” to allow Discount or else delete the term not to allow the Discount

Post the entry.

Incoming Payment (F-28)

fill the data as mentioned above with full amount

Press”ENTER”

Click on “Charge of Diff” ,the following screen appears

Double click on Bank line item(HDFC Bank)

Amount: Modify Amount,100000*5%=5000

=100000-5000 =95000

Click On Document & Simulate, Finale entry ll be

Configure Default Baseline Date for Payment

This article is a quick reference on how to set the default value of baseline date for payment.

A baseline date for payment is the date for which the payment terms apply. It’s the basis of the sytem to determine the cash discount taken (from vendor) or cash discount given (to customer). During entry of customer and vendor invoice transactions, the baseline date field is a required field. You can not proceed with the posting of the transaction not unless the said field is filled-up.

In SAP system, you can customize the default baseline date for payment that appears during transaction entry. You may choose as default either the posting date, document date, entry date or no default date. Do remember you can override the default value of baseline date.

To configure the default value of baseline date for payment, here’s a quick and simple guide:

Transaction Code: OBB8

Path: IMG → Financial Accounting → Accounts Receivable and Accounts Payable → Business Transactions → Outgoing Invoices/Credit Memos → Maintain Terms of Payment.

See highlighted items. Select the the default value either posting date, value date, document date or no default. Bear in mind that the default baseline date is applicable for each payment term you maintain. You could have different default baseline date for different payment terms.

How is the due date of a document calculated?

The due date is determined through default payment terms entered in the business

partner’s master data and setting a baseline date for payment terms. Payment terms can be configured through T-codes OBB8 and OBB9.