cancel
Showing results for 
Search instead for 
Did you mean: 

F.13 Automatic Clearing

former_member229478
Participant
0 Kudos
2,320

Dear SAPians,

I am executing the Automatic clearing for GR/IR but its not working only in the case of Import (i.e. Foreign Currency) whereas Local currency is clearing normally.On execution the system shows information message "The difference is too large for clearing" and "No clearing". Whereas, the Debit and credit amount exist. I have tried to clear the via F-03 ( manual Clearing ) still the system respond the same.

Just for information; After invoicing, there is an issue identified in MM condition due to which we have to reverse MIRO and MIGO to correct the system impact and then post the entries normally.

One more thing, the GL was cleared in the last period normally .i.e. vie F.13 and it worked properly, but now only in current period it is not working.


I have try to look for the response on Google but couldn't found it.


I would highly appreciate for you response.



Thanks in Advance


Best Regards

Arif Billah

Accepted Solutions (0)

Answers (8)

Answers (8)

former_member229478
Participant
0 Kudos

Hi All,

Thanks alot for your kind support. The issue has been resolved.

We have assign the Sort key of Purchase order in GL master data so that when the automatic clearing executed, system will fetch the PO number.

Once again thank you very much. Highly appreciate.

THE ISSUE IS NOW CLOSED

Best regards,

Muhammad Arif Billah

Former Member
0 Kudos

HI ,

Please refer OSS note

1697659 - GR/IR line items cannot be cleared in T-code F.13

This is Knowledge base and its indicate the how GR /IR clearn ing should work .

Many Thanks

Regards

Preeti Agarwal

former_member229478
Participant
0 Kudos

Dear all,

Please find the screen shot in which we have reference key 3 appears only on GRIR stores not on the other GLs. If by anymean if I got the ref. Key on other GLs, Automatic clearing would be possible.

1st I thought this is the issue of Field status but now i have set the F.Status at optional. Issue still stands.

Please help me in this regards.

For your information, transaction keys are not standards keys on which these GLs are assigned.

@Arjun Raghav: GR based invoice verification is Set

Humble regards

Arif Billah

former_member198650
Active Contributor
0 Kudos

Hi Arif,

In that case you have to define clearing criteria as purchasing doc.& item or assignment fields for the above GLs. Before that you have to define the sort key as purchase order for the above GLs. Then only system will capture the PO No.

Regards,

Mukthar

former_member229478
Participant
0 Kudos

Dear Mukhtar,

Thanks for sharing the Idea, my understanding is same as you mentioned.

But the issue is when I select the GRIR for Import the system does not derive the reference key PO and Item field. Which makes me think that there is an issue in MM conditions that is why system is not storing the year, Material doc and item in the reference key. (please correct me if I am wrong)

Do you have any idea of settings for these conditions or how could I let the system derive these fields in the reference key. Please share it. Your help will be appreciated.

Thanks

Arif Billah

former_member198650
Active Contributor
0 Kudos

Hi,

First check the t.code of the document and also check the original document of the accounting document. If it is generated from MM, then go to PO history of the document. If it is generated from PO, then definitely stores the data for the above fields.

Regards,

Mukthar

former_member229478
Participant
0 Kudos

Dear Mukhtar,

I totally agree with you system is generating and showing it on the header symbol. But not on the line item. As per my understanding the it is required on Line item for clearing.

Thanks

Arif Billah

former_member229478
Participant
0 Kudos

Hi All,

Thanks for the response. I have tried everything mentioned above.

Somehow i have cleared the GRIR for the current period and It is assumed that automatic clearing will not be executed for the next period until the following queries be resolved.

The query which is totally confusing is below. Which include need some clarification about F.13.

1. When I execute the Auto Clearing for the GRIR stores the systems shows the following 3 fields;

     a. Reference Key

     b. Purchase Doc.

     c. Items

I want to know why and how the system picks these fields in some GLs of GRIR whereas when I execute the clearing with other GL (those GLs which were not clearing .i.e. Import relevant) the system shows the fields other than the above mentioned (please refer the Screen shot 2 .i.e Assignment, Business Area & Trading, these fields are the standard fields)

1.

2.

Please help me in this regards, as far as my understanding there is an issue in MM conditions but couldn't able to trace. Here, I am talking about the conditions relevant to Import.

If anyone have the idea of Import condition, please share so that i can compare it with my settings.

Best Regards,

Arif Billah

former_member198650
Active Contributor
0 Kudos

Hi Arif,

You have defined clearing criteria for the above GL as Ref.key 3, Purchase doc. & item no. When you post GR with reference to PO, then system will store the combination of year+material doc.no+item no in the ref.key 3 field and update purchase order no along with item no. So when you do MIRO posting with reference GR, then the above field got updated. Based on this your clearing will happen. However, the import conditions custom duty,ADC etc. also get cleared as explained above.

Regards,

Mukthar

Former Member
0 Kudos

Hi Muhammad,

The check box 'GR/IR account special process.' assumes GR based invoice verification.

Please see the F1 help of the checkbox. If GR based invoice verification is not applicable, clearing based on Reference Key 3 may not work.

I think that is the issue in your case.

Regards,

Arjun Raghav



michael_kozlowski
Active Contributor
0 Kudos

Maybe trx F13E will help you in this special usecase.

former_member198650
Active Contributor
0 Kudos

Hi Mohammad,

As you said, it has posted in foreign currency. So there might be exchange rate difference araised when you are clear on different period. So try to post on same period.

Regards,

Mukthar

Pardhasaradhi_Reddy_Chelikam
Active Contributor
0 Kudos

Dear,'

Kindly check the settings made for clearing in SPRO

Kindly check settings for Clearing Differences.

Financial Accounting (New)-->Accounts Receivable and Accounts Payable-->Business Transactions-->Open Item Clearing-->Clearing Differences-->Define Tolerances for Customers/Vendors

Regards,

pardhu