Uninvoiced GRN

[Former Member]

Dear Experts,

I am in a process of developing the GRN Done and IR not done report. But i am not able to exactly figure out the link for the table to be used for this report. we have the following scenatios for this report.

1. Normal case.

I will go and check the RSEG table whether GRN is populated in LFBNR field. If the GRN Document is populated, we will come to conclusion that IR is made for that GRN. Hence our report will display the GRN document.

2. Imports and Intercompany.

For the imports and intercompany, we will make an invoice and then we will make a GRN. In that case please let me know how to relate the table for RSEG. Here in this case RSEG table is not filled with LFBNR. It will be blank.

Please help ASAP.

Ultimately our report should match with FS10N.

Shankar

Message was edited by: Shankaran Jayakumaran

[Former Member]

Dear Experts,

I am in a process of developing the GRN Done and IR not done report. But i am not able to exactly figure out the link for the table to be used for this report. we have the following scenatios for this report.

1. Normal case.

I will go and check the RSEG table whether GRN is populated in LFBNR field. If the GRN Document is populated, we will come to conclusion that IR is made for that GRN. Hence our report will display the GRN document.

2. Imports and Intercompany.

For the imports and intercompany, we will make an invoice and then we will make a GRN. In that case please let me know how to relate the table for RSEG. Here in this case RSEG table is not filled with LFBNR. It will be blank.

Please help ASAP.

Ultimately our report should match with FS10N.

Shankar

Message was edited by: Shankaran Jayakumaran

[Former Member]

Hi ,

FS10N runs based on the G/L accoutns not based on the Accounting Documents.

check table <b>EKBE</b> ? for the same and try to Use Field values of <b>VGABE</b>

<b>1 Goods receipt

2 Invoice receipt

3 Subsequent debit

4 Down payment

5 Payment

6 Goods issue for stock transfer

7 Consumption (subcontracting)

8 Delivery (stock transfer)

9 Service entry sheet

Q Comparison for internally posted material (IS-OIL only)

R Return delivery via delivery note

P Invoice parking</b>

regards

Prabhu