Interest account determination - OBV1

[Former Member]

Hello Gurus,

I am configuring Item Interest Calculation for the first time.

I configred the following settings...

OB46 u2013 Interest Settlement Calculation Type

Int Calc. Type

P u2013 calculate interest based on line items.

OB82 u2013 Interest Terms

OBAC u2013 Define Reference Interest Rates

OB83 u2013 Enter the Reference Interest Rates Value

OB81 u2013 Define Time Dependent Terms

OBV1 u2013 Prepare Interest on Arrears Calculation

Now when I calculate through F.24...it displays hte form and shows that some interest is calculated.

After pressing F3 (back)...the page shows an error "Posting specifications not found".

Please suggest the OBV1 configuration (although I have maintained).

Regards,

Devang

[former_member322617 · Accepted solution]

Dear Devang,

My settings are

BUS 1000

Debit 01 - 1000

Credit 50 - 0011

BUS 2000

Debit 40 -0012

Credit 16 - 1000

Best regards

Pernille Grundtvig Holst

[Former Member · Accepted solution]

Hello,

Its time to face the new problem as the older one (SYNTAX ERROR) has gone via a SAP note.

I have done the OBV1 settings as suggested in the last message on 29.06.10. When I run FINT (I will use this one for interest calculation), with the Test Mode, I can see the detailed report for interest calculation with the number of days and rate and every other detail that i require. It is really GOOD.

But the problenm arises when I run the program with the Test Mode.

There are two errors

1) Posting details not found (entry 1000 + + +)

2) Debit/credit indicator is inconsistent.

I cant really understand where actually is the problem.

Please suggest.

Regards,

Devang

[former_member322617 · Accepted solution]

Dear Devang,

As for the first Error message, I think that you are missing the account settings in OBV1, for each account symbol, you have to link to a G/L account. Click the icon accounts in OBV1 and create link between the account symbol and the G/L account.

Best regards

Pernille

[Former Member · Accepted solution]

Hi,

OBV1 is mainy used for Account determination starts with predefined business transactions which are accessed when the user runs the interest calculation programs.

Eg :­ Transaction 1030 if the user wants to calculate the interest for a certain period and wants to debit the account for which interest is calculated.

When the business transaction is combined with optional modifiers like the company code and interest indicator, R/3 determines posting keys and account symbols.

[Former Member · Accepted solution]

Thanks Gurus,

On saturday itself, i fixed the error of postings. What I had configured was Bus Tra = 2000, Co code = 2000, Int indicator = 02 and Bus area = 2000.

Maintained the accounts for the same in accounts (F7).

The error was solved when I changed the configuration to + + +.

i.e., Bus Tra = 2000, Co code = +, Int indicator = + and Bus area = +.

Welcome to the new problem,

I run the proguam notmally (without test run), then Click "Process Forma for All Interest Items (Shift + F7), its processed and displays "Following forms were printed". And the log is generated "No extended withholding tax code found:.

Please suggest something to remove this log.

THANKS AGAIN FOR THE EFFORTS

Regards,

Devang

[Former Member · Accepted solution]

Hello Gurus,

Problem solved.

New requirement.

Everything is running fine, i.e., when we pay interest for advance/overpayment of customers, the customising is done and checked. Even the postings are correct.

Now the problem arises when there is an open item while interest calculation, the system calculates the interest receivable. I am not able to configure the settings for interest receivable. It asks for a CO asasignment for that line item.

Should it be done by assigning a cost center or internal order or a profit center.

Please suggest urgently.

Regards,

Devang

[Former Member · Accepted solution]

Hi experts,

I have similar problem while running interest to the customer. The interest is calcuted by the system, I can check that in print preview. but the entry is not posted. when I execute FINT I am getting error as ...

Posting details not found (entry 1000 + + +)

when I followed the above post and checked all the settings the error is same..

Please experts suggest what to check for

MY OBV1 screen looks like this...

Business transaction - 1000

company code - TATA

Interest indicator - V3

Business area - 0001

Debit     01     1000        Customer posting

Credit   50      0001        Interest received

Business transaction - 2000

company code +

Interest indicator +

Business area +

Debit    40     1000        Customer posting

Credit   16      0001        Interest received 

Please experts I am stuck at this the only problem is I am unable to post the interest entries.

Please suggest.

Thanks in advance

Tahir

[Former Member · Accepted solution]

Hi,

I have resolved the issue by changing the settings in OBV1

But now I have one more problem.. that when I run FINT for interest calculation it is

posting but I cannot see form.. Although I have assigned form to the interest indicator  and defined no. ranges....

path: Financial Acounting(new)- Accounts receivable and Accounts payable- Business Transactions-Interest calculation-interest calculation global settings-print-assign forms for interest indicator.

when I run int.calculation IN FINT... the system is posting entries but no form is displayed in the spool... but when I run interest in F.2B I can see form but no postings...

now my doubt is the rite practice to jump with the screens for form F.2B and for postings FINT....

I don't think this is the right way....

please suggest.

Thanks

Tahir

[Former Member · Accepted solution]

Hello Tahir,

Once FINT is executed and the posting gets created, you need to select "process form for selected line item (Shift + F6)" or Process form for all line items (Shift + F7)" to geneterate the form. The ICON for the same is available at the top as shown in the screenshot below.

Give feedback about the results.

Regards

Amitash

[Former Member · Accepted solution]

Hi Amitash,

As per your suggestion... i did the same thing i executed FINT and first i executed in test run mode.

then i unchecked testrun executed i didnot find option for process forms for selected or all open items.

Then later i got i posted one more invoice of customer and again executed FINT in test run i am getting that option of forms so i proceeded and processed the forms and interest is also posted but still forms are not there.

Now please suggest what to do in FINT.... do i have to execute in testrun mode.

because the image what you displayed that option is only coming in testrun mode.

please suggest.

Thanks

Tahir

[Former Member · Accepted solution]

Hello Tahir,

Did you check the spool.

Please check the same using transaction SP01. The form might have already been created. In case you want to regenerate the form, use T. Code FINTSHOW

Regards

Amitash

[Former Member · Accepted solution]

Hi, the Above is line item display FBL5N.

In this u can check interest is posted with the document type DA.

But only thing is form is not showing when i check the spool..

Although i assigned form and gave no.ranges for the form...

The below is FINTSHOW...

The only thing i am stuckup is the form.

Sir, if you have process for interest run. can you share with me i will check it.. because what i think is i have to do some minor changes in my settings...

Thanks

Tahir

[Former Member · Accepted solution]

Hi Amitash,

Please can u suggest any settings that are related to form which I need to check...  

I have assigned forms to the interest indicator... and defined no. ranges for the same.

When we run FINT there is also one tab called forms in that I did not gave any form... is that the reason which form is not getting displayed in the spool...

I have doubt that I am missing some settings related to form. because when I run APP I can see payment advice and check... and also when I do dunning I can see the correspondence letter.

Please suggest

Thanks

Tahir

[Former Member · Accepted solution]

Hi Tahir,

In FINTSHOW, select the item and do the Reprinting. The Icon is available at the top of the screen.

Regards

Amitash

[Former Member · Accepted solution]

Hi Amitash,

I think the problem is here as u said i checked in FINTSHOW reprinting option its the same issue.

I got doubt i executed T.code : SE71 in that F_DUZI_01 the form is not there in client 800  in english language.

For your reference will attach screen shorts of the same.

I guess i have to copy forms from one client to other....

I don't know the steps if you can suggest that would be very helpful.

Thanks

Tahir

[Former Member · Accepted solution]

Hi,

I tried  to copy the form F_DUZI_01 from client 000 to client 800 by following the steps from scn.sap.com.

The system is asking for some package. I don't have any idea about the package....

I am attaching the screen short of that package.

Thanks

Tahir

[Former Member · Accepted solution]

Hi Tahir,

I am just wondering whether you have done the customization in your Interest indicator to print the form.

Can you check the same.

It is maintained at the below mentioned customization

SPRO

IMG Menu

Financial Accounting --> Accounts Receivable and Accounts Payable --> Business Transactions --> Interest Calculation --> Interest Calculation Global Settings --> Prepare Item Interest Calculation

Here in the Interest Indicator, check the Output control section. You have "PRINT FORM" field in the interest indicator.

Select if this not selected.

Regards

Amitash

[Former Member · Accepted solution]

Hi Amitash,

Your reply was correct it was not selected. but still i am not getting the form in the spool....

I will attach the print screen.

when i process interest interest is posted but no form and no error log also.

Thanks

Tahir

[Former Member]

Hi,

If you are using the F.24 transaction i.e ( Calculate Interst on arreas), Then make the below mentioned settings in OBV1

A/R: Calculation of Interest on Arrears

In this step, you define the specifications for posting the interest

calculated as interest on arrears.

The account determination is carried out via the posting interface of

application 0002 (interest on arrears). The following specifications are

necessary:

o Account determination keys and posting details

First you determine which account determination keys are used. For

the business transaction account determination key, 1000 (interest

earned) and 2000(interest paid) should be entered. The other account

determination keys (company code, interest indicator, business area)

are optional. You use them if you want to define interest posting in

more detail.

For every combination of the account determination keys, you specify

a debit posting key, a credit posting key and account symbols

(posting details). You use the account symbol 1000 for the customer

posting. It is not necessary to specify an account since the posting

is made to the customer account. You do, however, have to specify

the posting keys.

o G/L accounts

For each G/L account symbol, you specify the account allocation for

interest earned and interest paid in full. You can differentiate the

account specifications according to currencies.

o Document type

In the Goto menu option you can define a document type for posting

the interest. In the standard system, the document type DA is

defined for posting interest.

[Former Member]

Thanks,

Currently my OBV1 looks like this:

Bus Tra 1000 Int Ind 01 Co Code 1000 Bus Area 0001

Debit 01 1000 Customer posting

Credit 50 0001 Interest received

Bus Tra 2000 Int Ind 01 Co Code 1000 Bus Area 0001

Debit 14 1000 Customer posting

Credit 50 0001 Interest received

Plesae check and reply

Regards,

Devang

[former_member322617]

Dear Devang,

In OBV1 make 2 settings.

Business transaction 1000 and 2000 for each interest indicator.

I will just email you some screen dumps of our settings.

Best regards

Pernille Grundtvig Holst

[Former Member]

Thanks for the info!

Havent yet received the mail but i am confused that for each indicator means 2 interest inticators.

I have maintained only 1 indicator.

Regards,

Devang