Sunday 16 August 2015

how to attach the reports in sap fico


REPORTS: 


Step 1.How to create a folder?

Keep the cursor and favorites from the menu select Favorites –Insert folder
Give the folder name FI reports
Enter

Step 2. How to attach the report to folder ?

Keep the cursor on FI reports folder from the menu select Favorites –Insert truncation tr code is (S_ALR_87011965)
Double click on asset balances report

Step 3. How to attach the report on desktop?

Go to report –Asset balances on right top select generates a short cut button
System description              :ECC6
Enter
Select OK button
Close SAP
Icon desktop
Double click on asset balances Icon
Give the password   :oracle (SAP password)

Step 4: How to create variant?
Go to asset balances report
Give the company code      :AML
Report date                           :30.11.2008
From the menu select go to variant --Save as variant
Give the variant name  :AML
Date                            :30.11.2008.
Save
Now close SAP
Double click on asset balances Icon on desktop
Give the password               :oracle
Enter
Select get variant button (Select asset balances S_ALR_87011965)
Execute
Select                                     :AML


Chart of Accounts List

Path :Accounting –Financial accounting –General ledger –Information system –General ledger reports –Master data –Chart of account- Chart of account (S_ALR_87012326)

Give your chart of accounts           :AML
Execute


TRAIL BALANCE

Path: Up to general ledger report the path is same -Account balances –Korea-Trail Balance (Tr code is (S_ALR_87012310)


Country          :Korea
Trail balance             :South Korea
Give the company code      :AML
Execute
Ignore the warning message press enter
Select current layout button
Keep the fields
GL account
GL account long text
Closing balances
Enter
To down lead to excel from the menu select list export –spread sheet
Enter
List –>Export local file
Select spread sheet radio button
Enter
See directory file name :AML.xls
Select generate button


LEDGER:

Path :Accounting –Financial accounting –General ledger –Periodic processing closing –Document –Balances audit trail –All accounts -General ledger from the document file (Tr code is S_ALR_87100205)

Give the company code      :AML
Execute

(Select menu bar –Settings-Layout –Current button )
 or
Select current layout button(Ctrl+F8)
Keep the fields document no.
Posting date
From the hidden fields column
Select text fields
Select left arrow
Select debit amount in local currency
Select left arrow
Select credit amount in local currency
Select cumulative balances
Select left arrow
Select total check box for debit amount in local currency, Credit amount in local currency
Select copy button
To go the document level
Double click an amount no.
Select call up document over view button


VENDORS LIST 

Path :Accounting –Financial accounting –Accounts payable –Information system -Reports for accounts payable accounting –Mater data –Vendor list (Tr code is S_ALR_87012086)

Give the company code                  :AML
Select address and telecom check box
Execute


Vendor wise patches

Path :Up to report for account payable accounting the path is same -Vendor balances vendor business (S_ALR_87012093)

Give the company code                  :AML
Execute
Each vendor wise


Out standing lit of vendors:

Path :up to reports for accounts payable accounting the path is same
Vendor Items- List of Vendors Open item for printing (S_ALR_87012083)

Give the company code                  :AML
Execute


Age wise analysis of vendors:

Path :Up to vendors column item the path is same -Vendor payment history with open item sorted list (S_ALR_87012085)

Give the company code                  :AML
Summarization level                                   :0
Select days overdue squirted list check box
Execute


Vendor advances report

Path :Up to vendors column items the path is same –List of Down payments open on key date vendors (S_ALR_87012105)

Give the company code                  :AML
Execute


Vendor ledger:

Path :Open and cleared up to vendors: Item the path is same –List of vendor line item (S_ALR_87012103)

Give the company code      :AML
Execute


Depreciation fore cost

Path :Accounting –Financial accounting –Fixed Assets –Information system -Reports are asset accounting –Depreciation fore cost-Depreciation on Capitalized Assets (Depreciation simulation) (S_ALR_87012936)

Give the company code      :AML
Report date                           :31.03.2011 (Give the any month end date)
Execute


Fixed assets schedule as per schedule VI of Companies Act

Path :Information system –Accounting –Financial accounting –Fixed assets -Asset history sheet (Tr code is AR02)

Give the company code                  :AML
Report date                                       :31.03.2009
Select group totals only radio button
Execute
Select assets button
Double click on asset retirements




No comments:

Post a Comment