GR/IR clearing issue due to change in configuration.

[Former Member]

Hello,

We have a production issue. User has entered Purchase Order and entered Goods Receipt. Later it was realized that it was posting to an incorrect GR/IR clearing account. So as per the valuation class, correction has been made to the configuration (old GR/IR account replaced by new GR/IR account). After that the Invoice Receipt is posted. Now the issue is, we are unable to clear these GR/IR accounts. Because there exists two different GR/IR accounts for Goods Receipt and Invoice Receipt. Tried the transaction code F-03, but no success. Please help.

Thank you

[Former Member]

Hi.And what is the problem with F-03?Error message appeared?

[Former Member]

GR/IR clearing account cannot be manually cleared. This is the error message.

[Former Member]

Maybe set of check box in FS00 "only automatic posting", or try to clear with the help of ABAP debuger

[Former Member]

Thanks for your reply. I did check the G/L account, it's set as 'Post Automatically only'.But I believe here the issue is, the old GR/IR clearing account has a lot of Goods Receipts, which implies that there is a lot of credit balance on it. The new G/L account has a lot of debit balance on it. Is there any possible way we can do this. As far as I know, since the balances are sitting in two different G/L accounts, it's getting difficult to clear. Any possible solution?

Thanks.

[Former Member]

Hi Jitesh,

I believe, that though there are several debit and credit line amounts pertaining to GR/IR Clearing account. System will do clear with transaction F.13 based on sort key information at GL Account.

If the GL Account Sort Key gets changed, then to be cleared manually with T.Code F-03. Here you will not be in a position to clear if the debit and credit items are huge.

Then go to FBL3N, match the both credit and debit with same information at Assignment field and do Clearing with F.13

As we know, it is very big taks. You have to struggle for which the mistake was happend and ensure that the sortkey should not be changed where there are line items to be cleared.

Regards

VG

[Former Member]

Thanks Venkata. I will try it and let you know. I appreciate your quick response.

[Former Member]

Hi Venkata,

I looked into the G/L master records for both accounts for 'Change Documents'. The sort key has been '014'. It was never changed. When I try to use the T-Code F.13, it's not letting us clear the accounts. I can see the documents in 'Documents that cannot be cleared' list. Is there any other way we can do it? Or any other checks that need to be performed?

Thank you.

[Former Member]

Hi

Your issue is GR/IR postins have happened in two different accounts. Credits in one GR/IR account number and the debit in another GR/IR account (new) and you want to knock off the equivalent items in these two different GR/IR accounts. F.13, will be of help if the items are in the same GL account.

What you can do is to allocate the debit/credit items in the GR/IR accounts against each other and thereby clear the items. Use GL account clear functionality for this purpose.

[Former Member]

Could you please let me know the steps?