Open PO Report with value of invoices (not still to be invoiced)

[Former Member]

Hi

I'm trying to find a standard report or produce something using SQVI, which will provide details of all open purchase orders and the sum of invoice values processed. We have extensive usage of the subsequent debit/credit for service order, which I suspect is making the still to be invoiced totals in the likes of ME2L, ME2N etc unreliable.

I have tried to draft something in SQVI using the following fields but have been unsuccessful, I would appreciate if anyone could let me know if they are aware of something already in existence. (I require the PO data and sum of invoices only)

PO Number	EKKO	EBELN
PO Item	EKPO	EBELP
Creation Date	EKKO	AEDAT
Vendor No	EKKO	LIFNR
Vendor Name	LFA1	NAME1
Short text	EKPO	TXZ01
Co Code	EKPO	BUKRS
GL Account	EKKN	SAKTO
Cost center	EKKN	KOSTL
Profit center	EKKN	PRCTR
WBS Element	EKKN	PS_PSP_PWR
Requestor	EKPO	AFNAM
PR Number	EKPO	BANFN
Tracking no	EKPO	BEDNR
Material group	EKPO	MATKL
Gross amount of PO	EKPO	BRTWR
Invoice amount	EKBE	WRBTR

Many thanks

Michelle

[Former Member]

Hi Michelle

I think you should post this in the R3 (Business Suite) forum.

Kind regards

Peter Juby