how to generate cost center wise vendor payment list

[Former Member]

Hi

My client requirement is to generate payment list cost center wise,  how to generate?

It is a payment list which mean payment make for the cost center/project.

The selection screen to include Co Code, Currency, House bank and bank ID and etc.

		Remitting	Payment	Debiting		--> BREAKDOWN BY PROJECTS
					SAP Cost Centre	7010PJCT	7010PROJ	7010PROP	70102010
Ledger	Vendor  Name	Ref #	Date	Currency	AMT PAID	ROIPL Project Controls	ROIPL Project Mgt	ROIPL Proposals	5041 Turret mooring project
MISPL-7120	Tricor Outsourcing-SOP Client A/c (THB1,325,349.84)	Q0011294	2-Sep-15	USD	37,654.12
AP	Andritz Ritz Pte Ltd	Q0011297	2-Sep-15	SGD	8,845.00
AP	Mapletree Investment	Q0011296	2-Sep-15	SGD	67,468.60
AP	Rolls-Royce Singapore	Q0011295	2-Sep-15	SGD	46,409.82
AP	Rotating Offshore Solutions	Q0011298	2-Sep-15	USD	471,786.69
AP	The Trust Co of the Marshall Islands, Inc	Q0011299	2-Sep-15	USD	1,300.00
ROP	Tri-Power Integrated	Q0011300	3-Sep-15	PHP	1,529,735.29

[former_member267327]

Hi,

There are no such report but you can refer the below report which will give you the consolidated informaiton cost center wise and you can also see the individual line item by dbouble click on it.

S_ALR_87013616

If you want to be add options which you mentioned above in selection parameter then you have to develop Z report or else you can try via SAP Query where you can use BSEG table with abap logic.

Regards,

Dattatraya B.

[Former Member]

Hi,

Just follow the below process to get the payment details invoice cost center wise.

Execute the FBL1N report, pick the invoice document number and pass it in BSEG table and pick the account type "S" for respective GL line item for cost center.

Regards,

Ravi