on 05-07-2009 9:41 AM
Hi All,
We need to do KPI reporting for accounts payable data.The report layout includes invoice header data and invoice lineitem data.Could somebody help me in finding the datasource to accomplish the same.I have checked the datasource 0FI_AP_04 and 0FI_GL_04.The report layout includes the following fields:
invoice header data:
location ID
vendor #
invoice #
invoice date
operator ID (who entered the invoice)
invoice entry date
days to enter (entry date - invoice date)
days to process (balanced date - entry date)
invoice due date
total invoice amount
invoice freight amount
invoice tax amount
cash discount available
invoice entry batch number
invoice balanced date
PO # reference
date posted to ledger
payment date
paid amount
cash discount taken
payment method
payment terms code
forecast payment days
actual payment days
actual - forecast days
cash discount lost
invoice line data:
location ID
vendor #
invoice #
invoice date
PO # reference
GL company #
GL account #
GL cost center #
invoice line amount
Regards,
Shravani
and combine LO DS with AP/AR and GL through infoset or mutiprovider...
You need to look for these KPIs in different datasources...and then link them.
Regards,
Ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you may also check the 2LIS_02_* datasources.
Siggi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.