Report in R/3

10-11  Source: Network gathering  Views:0 

Advertisement
Dear friends,
I need a report that enables us to query any G/L Expense account and have the ability to drill into it by cost centre showing the individual transactions building up the balance including the vendor name (for items processed using a PO and direct pay), vendor number for all A/P transactions, dollar value, currency, document number, document type, reference, PO number, posting date, and document date.
Please let me know if this is possible in R3 or i need to check in BW.
Rgds,
Kunal Vichare.
You can get the required details from FAGLL03, where you can get the cost center, PO no and vendor number by use the offsetting account field, dollar value, currency, document number, document type, reference, PO number, posting date, and document date.
Related articles
  • Re: Column is not getting displayed in the BI report 10-11

    Hello Gurus, I have developed a BI report with more number of parameters. Case 1: When i run my report , I am able to see data for particular condition but one column doesn't show any thing. All the rows in the column are blank. Case 2 I tried to put

  • Open and cancelled Quote Report 10-11

    Hi, Can anyone give me the information  for getting open and cancelled Quote Report?I hope you are using reason for rejection for cancelling quotations. If that is the case, you can use transaction VA25 to view the list of quotations. Here you can fi

  • Print Quote Report 10-11

    Hi All, I have a requirement to develop the custom print Quote Report. When i review the standard pring quote report ,I found a call like <?call-template:TermsTemplate?>. This statment itself is getting all the Terms and Conditions for that report.

  • XML Quote report 10-11

    We have a problem with our XML Quote report that cuts off the report at 26 pages when it should go to about 200 pages. We have another report the Acknowledge Quote and it works fine.Finally we found the solution for this problem. 1. Open qotSCocPrint

  • Same EPM Excel Report takes time to open and refresh on 1 system while it opens and refreshes faster on other system 10-11

    Hi All , I am facing an issue where the EPM Excel Templates on SERVER ROOT FOLDER take time to open on 1 system . It also takes great amount of time to REFRESH . While on an another system the same Report opens rather quickly and refreshes also quick

  • Safari doesn't open and comes up with this error report. 10-11

    Please help. Process:         Safari [474] Path:            /Applications/Safari.app/Contents/MacOS/Safari Identifier:      com.apple.Safari Version:         7.0.4 (9537.76.4) Build Info:      WebBrowser-7537076004000000~3 Code Type:       X86-64 (Na

  • Training and Event Management - report on list of cancelled courses 10-11

    Hi All, Is there any standard report available to get the list of cancelled courses (be it business event grp , type or business event) Would appreciate your inputs on this. Kind regards SathyaS_AHR_61016216 - Cancellations per Attendee , i think the

  • Help my safari doesnt open and gives me a crash report 10-11

    help my safari doesn't open and gives me a crash report ever since i downloaded a file from the internet. I have a macbook air (early 2014) with running os x yosemite version 10.10.1There is no need to download anything to solve this problem. You may

  • I click on itunes but doesnt open and says send error report or dont send 10-11

    i click on itunes but doesnt open and says send error report or dont sendYou will need to provide more details as we cannot see your computer screen. Does this happen every time you launch LabVIEW? What version of LabVIEW are you using? What version

  • How Open And Print Proc C Genrated Text File Based Report ON Browser 10-11

    Dear Sir I have my old 6i forms from which i runs some Pro*c programmers with the help of HOST() command ,and then that generates a normal text file as a resultant report like file name "kha10" which i can easily open with any text client ,,, no

  • MB5B Report table for Open and Closing stock on date wise 10-11

    Hi Frds, I am trying get values of Open and Closing stock on date wise form the Table MARD and MBEW -Material Valuation but it does not match with MB5B reports, Could anyone suggest correct table to fetch the values Open and Closing stock on date wis

  • HELP to Open and Print automatic a REPORT 10-11

    Hello, I'm a Portuguese Developer, and i've a challenge, that is, i want to open REPORT by FORMS in RDF format and i want to open and print automatic way, i do not want to open, and then have to go print button to pint them. I want to open by FORM wa

  • If image file not exist in image path crystal report not open and give me exception error problem 10-11

    Hi guys my code below show pictures for all employees code is working but i have proplem if image not exist in path crystal report not open and give me exception error image file not exist in path although the employee no found in database but if ima

  • Using SQVI to generate report of open and released delivery schedule lines 10-11

    All, I'm using SQVI  to generate an excel spreadsheet for some buyers to show open released schedule lines because they are a 1 line item per scheduling agreement company. I used the logical database MEPOLDB instead of a table joint and pulled fields

  • Campaign Report Clicks, Open, and, Bounces 10-11

    How does WebTools determine the number of Clicks, Opens, and, Bounces on the Campaign Reports? Thanks to all in advance.I would be interested in the answer to this also.Read other 2 answers

  • Queation Regaring Print Quote Report 10-11

    Hi All, I have a requirement to develop the custom print Quote Report. When i review the standard pring quote report ,I found a call like <?call-template:TermsTemplate?>. This statment itself is getting all the Terms and Conditions for that report.

  • Questions on Print Quote report 10-11

    Hi, I'm fairly new to Oracle Quoting and trying to get familiar with it. I have a few questions and would appreciate if anyone answers them 1) We have a requirement to customize the Print Quote report. I searched these forums and found that this repo

  • Open PO Analysis - BW report issue 10-11

    Hello Friends I constructed a query in BW in order to show Open Purchase Orders. We have custom DSO populated with standard datasource 2lis_02_itm (Purcahse Order Item). In this DSO we mapped the field ELIKZ to the infoobject 0COMP_DEL (Delivery comp

  • Open vi error for report generation toolkt 10-11

    Originally it works fine. Now I upgrade to win7, LV9 and office2010. To open the old program by 8.6.1, I reinstalled LV 8.6.1 and report generation toolkit. But still got the error as attached. Any suggestion, thanks. Attachments: ss.png ‏184 KB1. MS

  • Report developed in 6i and open and run in 10g, Web Layout is not working 10-11

    Hi, Initially reports were developed in Reports 6i now we need to convert into 10g. I just opened the .rdf in Reports10g. Report is successfully running in paper layout and showing the data. But when i try to run the report in Web Layout im getting a