DbitGeoStat

E-mail: || Phone: 6473800837

SAP FICO and BI/DW

Spreadsheet Server, Powered by the QueryExchange™, opens up the power of Excel…This Microsoft Excel Add-In provides live and dynamic SAP reporting and analysis from the SAP ERP into Excel. Your organization's users have complete control over the design and content of your SAP Excel reports from SAP modules, including FI, CO, PCA, SD, MM, PP, QM, PM, HR, PS, New GL, and Special Purpose Ledgers. Users can create dynamic dashboard views from SAP. These views can be accessed, automated and presented with our formula driven methodology, including summary balances and detailed drill-downs. - See more at: http://www.glbsoft.com/sap/spreadsheetserver.aspx?gclid=CIm88rvblrgCFac7Mgod3RkA6Q#sthash.nbWSfyek.dpuf

Read more: http://www.glbsoft.com/sap/spreadsheetserver.aspx?gclid=CIm88rvblrgCFac7Mgod3RkA6Q

SAP FICO

SAP FICO consists of two major modules essential to process financials of a company , viz,

1. Financials (FI)

2. Controlling (CO)

Refer the tutorials sequentially one after other to maximize effectiveness of the training material.

If you are new to SAP technology , before you begin refer our tutorial explaining What is SAP ERP System?

So lets get started! (All links open in a new tab in your browser)

SAP FICO

Organizational Structure

1. Create a Company

2. Create a Company and assign to Company Code

General Ledger

3. Create Chart of Account

4. Create Chart of Account (COA) Group

5. Create Retained Earnings Account

6. Create G/L Account

7. Posting to General Ledger

8. Blocking Or Deleting GL Accounts

9. Display Changes To GL Accounts

10. Create Financial Statement Version

11. How to perform a Journal Entry Posting

12. Fiscal Year Variant

13. Assign Company Code To Fiscal Year Variant

14. Define Posting Period Variant

15. Opening And Closing Posting Periods

16. Define Field Status Variant And Field Status Group

17. Assign Field Status Variant To Company Code

18. Document Type And Number Ranges

19. Post With Reference

20. Hold Document

21. Park Document

Accounts Receivable

22. Create a Customer Master Data

23. Change Customer Documents

24. Create Customer Account Group

25. One Time Customer

26. How to post a Sales Invoice

27. Document Reversal

28. Sales Returns – Credit Memo

29. How to Post Incoming Payment

30. How to post a Foreign Currency Invoice

31. Incoming Partial Payments By Residual Method

32. Incoming Partial Payments By Partial Payment Method

33. How to Reset AR Cleared Items

34. Credit Control for the Customer

Accounts Payable

35. Create Vendor Master Data

36. One Time Vendor

37. Purchase Invoice Posting

38. Document Reversal

39. Purchases Returns – Credit Memo

40. Outgoing Payments

41. Foreign Currency Vendor Invoice

42. How to Post Withholding Tax during Vendor Invoice Posting

43. How to Post Withholding Tax During Payment Posting

44. Outgoing Partial Payments By Residual Method

45. Outgoing Partial Payments By Partial Payment Method

46. Reset AP Cleared Items

47. Automatic Payment Run

48. Posting Rounding Differences

Read more: http://www.saptraininghub.com/sap-fico-training-tutorials/

Bi and SAP Business Information Warehouse

Read More: The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market. As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided. SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis.

Read more: http://help.sap.com/saphelp_nw04/helpdata/en/b2/e50138fede083de10000009b38f8cf/content.htm