I am trying to work on Vendor payment analysis where i have to identify how much amount has been paid to a perticular vendor and how much is to be paid analyzing the PO information. I also know that for a perticular vendor the PO created will either hit a cost centre (hardware vendor) or a wbs ( service provider or consulting vendor) .
If someone has worked on it and give me some suggestion it will be great help.
I have identified that i can use 2LIS_02_ACC-Purchasing data account level for getting PO header and item detail but here how will i identify Open and closed POs.Is there a flag field please let me know
Similarly can i use New gl ledger 0FI_GL_14 to identify which are open PO and which are closed. I would also like to know if these 2 datasoruces be able to fulfill my needs.