cancel
Showing results for 
Search instead for 
Did you mean: 

Item grouping of F.19/ GRIR clearing

hansi_heyderich
Participant
0 Kudos
951

Hello,

I'm just trying to figure out after what criterias the T-Code F.19 is grouping the open items together but don't find an answer. SAP help is saying "for each reconciliation account and assignment number..." but I don't find an assignment number. I tried the PO, the supplier id, a mixture of both but I'm not able to assign the items of F.19 to the posting items of F.19.

Can somebody please give me a hint?

Thanks a lot in advance.

BR,

Hansi

Accepted Solutions (1)

Accepted Solutions (1)

former_member182098
Active Contributor
0 Kudos

Hello,

You use transaction code F.13

Before that make sure your settings in OB74

For Account type Vendor K Use EBELN as criteria

For Account type GL S Use ZUONR

For GRIR Account use the sort key as 014 (Purchase Order)

Hope this solves your problem.

Regards,

Ravi

hansi_heyderich
Participant
0 Kudos

Hello Ravi,

thanks for the answer but probably I have used the wrong english terms. I'm interested in the F.19 with which we clear the GR/IR Clearing accounts for years ending - especially the case where we have received goods but no invoice.

Sorry for any missunderstanding.

Best Regards,

Hansi

former_member182098
Active Contributor
0 Kudos

Hello,

Please go to MR11 Transaction code.

You get the details of goods received and where there is no invoice. This is nothing but doing the same thing as F.19 or F.13 from MM side.

You are also having Posting Option.

I hope this is what you are looking for.

Regards,

Ravi

hansi_heyderich
Participant
0 Kudos

Hello Ravi,

sorry, but still not what I'm looking for. With help of F.19 I create a posting document which in some way is grouping together positions of the GRIR-account. I'm looking for the criteria the F.19 is grouping the different positions together.

BR,

Hansi

former_member182098
Active Contributor
0 Kudos

Hello,

If I understand your questions correctly, you need to go to OBYP and configure for transaction keys BNG and GNB.

Enter the Reconciliation Account GRIR

Enter the Adjustment and Target Account

Hope this will solve your problem. Once this is being done you can carry out F.19 and it will generate the postings, then you can go to SM35 and post them.

Regards,

Ravi

hansi_heyderich
Participant
0 Kudos

Hello Ravi,

I'm sorry, still not. I try to explain it in full:

If I run the F.19 I get an analysis which positions are still opened, seperated between "invoiced not delivered" and "delivered not invoiced", e.g.:

Vor BuKr Hauptbuch EinkBeleg GsBe Pos Belegnr Hauswährun St Kreditor Abstimmkto

BNG 0014 191000 4500109862 10 5000170943 669,33 112673 160000

BNG 0014 191000 4500109862 10 5000171867 8,22- 112673 160000

  • BNG 0014 191000 4500109862 10 661,11

BNG 0014 191000 4500128904 20 45837163 2.449,00 100142 160000

BNG 0014 191000 4500128904 20 5000173728 460,93- 100142 160000

  • BNG 0014 191000 4500128904 20 1.988,07

I understand this result. If I go on (button "Postings") to the generated posting document I receive sth. like this:

BuKr Belegnr Belegkopftext Buch.dat. HWähr

Pos BS Hauptbuch Betrag Hauswähr St Text

0014 Umgliederung WE/RE-Konten 31.12.2008 EUR

40 191099 7.040,00 GNB

50 191102 7.040,00 GNB

0014 Umgliederung WE/RE-Konten 31.12.2008 EUR

50 191099 661,11 BNG

40 191101 661,11 BNG

My trouble is, that I'm not able to assign the positions from the posting document to the positions of the analysis. With other words I don't know which line items of the posting document belongs to which PO.

As far as I understand the SAP help the t-code summarises the items of the analysis after a certain criteria, which I'm not able to find (it's not the PO, it's not the supplier id - what else can it be?).

Thanks for being patient with me!

Best Regards,

hansi

former_member182098
Active Contributor
0 Kudos

Hi,

I would suggest you may please go through the informaton given on F.19

I am reproducing the relevant part of the text how the entries are being grouped together.

The program selects all items in GR/IR clearing accounts that are open at the specified key date. If the open items per purchase order number and item in local currency do not balance out to zero, adjustment postings are created in a batch input session for these items. With a credit balance, the transaction is seen as "delivered, but not invoiced". With a debit balance, the transaction is seen as "invoiced, but not delivered".

Adjustment postings are created per company code, GR/IR clearing account, reconciliation account, and business area. All postings are reversed at the specified reverse posting date. If no date is entered, the program reverses the postings on the day after the key date.

If you are using parallel local currencies, the balance in the first local currency also determines the transaction. If the balance in the first local currency is zero, the transaction key is determined from the parallel currency.

Hope you will find this informative.

Regards,

Ravi

hansi_heyderich
Participant
0 Kudos

Ravi - thanks a lot, you did it!

Have a wonderful day,

Hansi

Answers (0)