Problem to post foreign payment in FF67

[Former Member]

Hello,

I have a problem with manual bank statement FF67 and would kindly ask you for help.

Bank account is in local currency DKK (Denmark), but foreign payments to vendors are also handled via this account.

Example:

Vendor invoice 100 EUR, posted on Credit with exchange rate 7,0 which gives 700 DKK

Automatic Payment Program posts: Vendor account Debit 100 EUR, Bank OUT clearing account Credit 100 EUR. No exchange rate differences posted with F110.

On the Bank Statement we have the invoice paid 100 EUR with bank exchange rate 7,1 which gives 710 DKK.

So I want the system to generate following posting:

In foreign currency (EUR):
Bank OUT clearing account – Debit 100 EUR
Bank main account – Credit 100 EUR

In local currency (DKK):
Bank OUT clearing account – Debit 700 DKK
Bank main account – Credit 710 DKK
Exchange rate differences – Debit 10 DKK

The problem in FF67 is that such a posting can be created only if I maintain bank account currency in foreign currency EUR. But the account currency is DKK, so the system always requires and refers to amount in local currency. If I enter amount 710 DKK paid by the bank, the system refers to invoice amount in local currency (700 DKK) and displays error message: “Difference too large for clearing”.

I hope I was clear enough in my explanation and some of you can help me to find a way how to post payment 100 EUR = 710 DKK in FF67 and to get automatic posting in both currencies, as I specified above. If needed, I will provide the screens.

Thank you

Jolanta S.

[Marssel700 · Accepted solution]

Dear Jolanta,

You wont get this document posted standarly. An user exit linked with your posting rules will solve this issue.

regards              

[Former Member · Accepted solution]

Hi Marssel,

Thank you for your reply. I was searching for the right user exit for FF67, but found only following four:

FEB00003  Customer exit for Finnish bank statement TITO format

FEB00004  Raw data processing, user exit SWIFT MT940

FEB00005  Electronic Banking - Account Statement Object Generation

FEDI0005  Function exists for EDI-ICODS in FI - Elec.bk stmt/lockbox

Looking at the decription, none of them fits to my problem.

Can you please tell me the user exit no. or any other information that will help to find the proper user exit.

Thank you

Jolanta

[Marssel700 · Accepted solution]

Jolanta,

You must develop a new exit report. Specify for the statement posting table: FEBCL and currency table: TCURR. The report have to search for exchange difference and split in differences account.

I hope you get succeed

[Former Member · Accepted solution]

Hi Marssel,

Thanks again. This is more complicated than I thought and will ask programmer for help.

But I would like to ask you one more question about FF67 or rather the batch input session, which is created after manual bank statement is saved. Customer may pay for normal sales invoices or down payment. I would like to process both kinds of payments in one transaction, i.e. to post and clear customer payments with normal invoices and with dp requests. For this reason Sp. GL Indicator F is maintained in the posting rule. However in batch input session (screen SAPMF05A, post with clearing) checkbox "Normal OI" is blank. It means, I can clear only down payment requests, no normal invoices.

Similar problem with SM35 I have, when I want to post payment with VAT: checkbox "Calculate tax" is blank, not possible to process batch input without errors.

Do you have any idea how to correct the screen in batch input to have chackboxes marked?

Best regards

Jolanta