how to clear vendor open items if vendor invoice currency and payment currency different

[Former Member]

Hi All.

How to clear vendor open items through f-44 if vendor invoice currency is EUR , payment currency is USD  but local currency is INR

while clearing through f-44 system showing error as "to large for clearing clearing is not possible"

I checked all configuration, configuration wise no problem

BR.

Chandra

[former_member653350]

I have similar issue, during clearing of customer - Bal Sheet adjustment A/c is hitting and PL A/cs are negated, please help - Pic attached

[Former Member]

HI Chandra, why dont you use as residual items , how much ever getting balance adjust in the residual line , once you click on residual entry system will generate one more line item hope it will help you Thanks

[Former Member]

Hi Kha

I am using residual items even though its  not working.

Again balance hitting to vendor A/c, balance not affecting to GAIN or loss A/c.

Please help to me

BR.

Chandra

[Former Member]

HI Chandra have you check the setting in FBKP check why its not hittig to the P/L account in FBKP

[Former Member]

HI Khan,

Still we are using 4.7 version

In FBKP what settings we have to do, plz tell me

BR.

Chandra

[Former Member]

chandra, have you maintain the GL account in the FBKP here only we maintain the foriegn exchange valuation check and confirm

[Former Member]

Hi,

Previously they maintained. everything

vendor invoice EUR  of  4256.40

Vendor payment USD 5586.065 on

while clearing through f-44 the difference Amt again hitting to vendor Debit, no amount posted to Gain or loss A/c.

even I tried Residual A/c.

[Former Member]

Have you check in OB08

[Former Member]

Hi,

I tried in 0b08 also

[Former Member]

Hi,

I check in 0b08 also

[Former Member]

is there any exchage rate different

[Former Member]

Hi,

yes is there exchange rate difference even though it is not hitting to Gain or Loss A/c

That difference A/c hitting to vendor debit

BR.

Chandra

[Former Member]

Hi Chandra as my observation you are trying to clear with USD currency , can you please try with EUR currency you may get your answer. Thanks

[Former Member]

HI Chandra if you got the answer please close this discussion

[former_member189001]

Hi Chandra

Please share screen short

[Former Member]

Please find above screen shot

BR.

Chandra

[former_member198650]

Hi Chandra,

You chose any one of the currency i.e. EUR/INR/USD for clearing in F-44. After selecting line items for clearing, system will show a difference. Click on over view button and manually write off the difference by selecting any one account i.e. dummy or small diff.account, after that click on process open items then system will show the difference 0 and simulate the document, here system will post gain/loss exchange GL postings along with other line items. After save the document, manually pass journal entry to dummy account and gain/loss account. I have explained clearly in the below example.

Invoice is in USD - 1000 & INR - 60000

Payment is in INR - 60000

Now I am going to clear these in INR currency in F-44 on 31.03.2015. On this date the exchange rate for USD is 60.10. At the time of clearing system will post the below entry

Vendor A/c Dr 60000 (invoice)

Vendor A/c Cr 60000 (Payment)

Gain from exchange rate A/c Cr  100 (60000 - 60100)

Small diff.write off A/c (or) Dummy A/c Dr 100

After done the above posting, we have to pass below manual JV in FB01

Gain from exchange rate A/c Dr  100

Small diff.write off A/c (or) Dummy A/c Cr 100

Regards,

Mukthar

[Former Member]

Thanks a lot Mukthar

My doubt is  Amount is not affecting to Gain or loss A/c

Again same amount hitting to vendor A/c that amount showing again as openitem

now i am attaching screen shot, could you please find

[former_member198650]

Hi Chandra,

Share screen shots of invoice & payment line items.

Regards,

Mukthar

[Former Member]

Hi Mukthar,

Please find below invoice & payment screen shots

Please provide solution to me

Thanks in Advance

[former_member198650]

Hi Chandra,

Which currency are using for clear the vendor balance in F-44. Share the screen shot of the documents in F-44.

Regards,

Mukthar

[Former Member]

Hi Mukthar,

I tried all currency USD , EUR & INR also

gain or loss balance not hitting to relevant Gl A/c

I shared previously F-44 document , if you need one more time i can able to add.

BR.

Chandra

[former_member198650]

HI Chandra,

Not this one, I need the items are showing inside of F-44 before over view.

Regards,
Mukthar

[Former Member]

HI Mukthar,

The  above screen shot is F-44 only

BR.

Chandra

[former_member198650]

Hi Chandra,

I want the screen shot as shown below for the above line items.

Regards,

Mukthar

[Former Member]

Hi,

I will share

[Former Member]

Hi,

I will ask to user , share screen shot like above.

BR.

Chandra

[Former Member]

Hi Mukthar,

Please find screen shot, plz provide better solution 2 day its going to high priority.

SA doc type is Payment doc

RE doc type is Invoice doc

BR.

Chandra

[Former Member]

HI Mukthar

Please help for me above issue.

[former_member198650]

Hi Chandra,

Click on overview button, then post the difference 391387.28 to any GL account, after enter this click on process open items, then the not assigned balance shown as 0, then simulate the document, the system will generate gain/loss account posting with the above amount and save it. After that post JV for gain/loss account & the GL account which is used above.

Regards,

Mukthar

[Former Member]

HI Mukthar &Inayat Khan

I tried as you said above, remaining balance manually I posted to Gain/ Loss A/c.

Thanks for your support.

BR.

Chandra

[Former Member]

HI Mukthar,

Do You have any SAP Co certification material, could you please send  to my mail id.

BR.

Chandra

[Former Member]

Chandra, if the problem is solved please marked answer and close Thanks