topic Pending Invoice Report Problem. in Application Development and Automation Discussions

Pending Invoice Report Problem.

Former Member — Sun, 16 Dec 2012 07:45:34 GMT

hi gurus,

i have developed pending invoice report which tells for these many GR'S , IR'S not done (or Pending)..

and my report is showing correct output.. but in one case it fails to show accurate output..

the case is as described below:

1. The end_user has created PO

2. second he made GR.

3. he thinks that he made GR Wrongly..... and he does Reverse GR with same quantity and same price.

4. then again he creates the GR with Same Quantity and Same Price..

Now in case he totally creates 3 GR's(out of which one is reversed) and all 3 have same quantity and same price....

if i written logic like this:

for particular PO.

delete previous gr. if (reverse_GR amount = previous_GR amount and reverse_GR quantity= previous_GR quantity).

According to this logic it is displaying that this PO has no pending invoices..

But actually the last GR(i e. 3rd GR) has not been invoiced that GR has still invoice Pending..

In this case the report is not working..

Need Your Suggestions..

thanks and Regards,

Nitin

Re: Pending Invoice Report Problem.

kakshat — Sun, 16 Dec 2012 08:04:34 GMT

Maybe you can add all the GR (including GR and reverse GR) quantities for a given PO taking GR quantities as positive and reverse GR ones as negative. If the final sum comes out to be positive, it means the GR is pending invoicing.

Re: Pending Invoice Report Problem.

Former Member — Mon, 17 Dec 2012 07:29:30 GMT

Y dont u try with movement type, hoping u are using different movement type for reversal.

Regards

Re: Pending Invoice Report Problem.

RaymondGiuseppi — Mon, 17 Dec 2012 07:44:58 GMT

Did you use EKBE-SHKZG to identify canceling documents (S= GR, H = GR cancel) ?

Regards,

Raymond

Re: Pending Invoice Report Problem.

former_member194152 — Mon, 17 Dec 2012 08:09:04 GMT

you can check with entry date and entry time field for document creation(MKPF-CPUDT,MKPF-CPUTM), check with any 102 movement type exist in internal table and reverse it with corresponding 101, with non latest 101 movement.

Re: Pending Invoice Report Problem.

Former Member — Mon, 17 Dec 2012 10:18:10 GMT

thank you all very much for your valuable suggestions.

Re: Pending Invoice Report Problem.

Former Member — Mon, 17 Dec 2012 11:43:13 GMT

thank you for suggesting.

Re: Pending Invoice Report Problem.

RaymondGiuseppi — Mon, 17 Dec 2012 12:12:38 GMT

Look out, 102 is not the only code that cancels/reverses a code 101 good movement, look also at code 122 (and code 123 that cancels code 122...)

Regards,

Raymond

Re: Pending Invoice Report Problem.

Former Member — Fri, 03 May 2013 05:47:53 GMT

using credit/debit indicator "SHKZG" and PO History Cat "BEWTP" it has to be added all correct GR's for particular Purchase order line item wise from ekbz table and also add all reverse GR's for the same Purchase Order Line item Wise there we will get sum of correct GR's for a PO Line Item and we will get Wrong GR's for the PO line item ,,, then we need to substract that wrong GR's amount from the Correct GR's that will give you Correct GR's Amount and Quantity for the po line item,,,, same procedure has to followed in IR's also,,,,,,,,,,,,,

Then Finally we will get correct gr and ir amount ,,

substract IR from GR you will get Pending Invoice,,,,

important tables
:ekbe purchasing history table

:ekbz transportation table

:mkpf material Document Header

Re: Pending Invoice Report Problem.

J_OWENS — Sat, 09 Nov 2013 10:38:46 GMT

Hi Nitin,

Can you pls tell me how to find the GR with invoice pending.
I am new to SAP and this is my first real time scenario.

Pls guide me.......

Thanks & Regards

Jesse

Re: Pending Invoice Report Problem.

Former Member — Sat, 09 Nov 2013 12:53:13 GMT

Hi Nitin / Jesse

Better remove the doc. with mvt type 102 and the reference doc. no. from field LFBNR of material document and exclude that document.

it will give you the correct report.

Regards,

Manish Jain