Your SAP Resource  »  Publications  »  SAP Experts  »  Financials Expert Online

Log In  |  Help

Financials Expert

SAP financial
concepts, technology,
and best practices

Part of the
SAP Experts
knowledgebase

Subscribe/Renew Now

Browse by Category  |  Advanced Search »

Go

Home

Knowledgebase Overview

Article Index  |  PDF

Free Sample Article

Frequently Asked Questions

Downloads

Webinars

Financials 2010 Conference

SAP Insider Event Calendar

SAP Experts Knowledgebases

About Us

Contact Us

Categories  »  General Ledger

General Ledger

  1. "In Synch" Ledgers! Update the "Cost of Goods Sold" to Both Your G/L and Costing-Based CO-PA Ledgers Solely from the "SD Billing" Transaction... With 100% Standard R/3 Functionality!
    by Chris Kupczyk, Certified SAP FI/CO Consultant, EDS

    This article identifies a creative use of standard R/3 functionality that allows a single end-user transaction (SD Billing) to simultaneously act as the "Cost of Goods Sold" source for both your G/L and Costing-Based CO-PA ledgers. After a brief explanation of why the "single source" design is not the main option offered by the SAP R/3 application, the article briefly describes how the single-source design pieces are interconnected, and then shows you, step by step, how you can set your system up for single-sourcing using 100 percent standard R/3 functionality.

  2. 1099 Reporting - The Special G/L Indicator Gets a New Use in Release 4.7
    by Martin Ullmann

    In the many years I have been consulting in the FI area, almost every U.S. client I have worked with has had a common issue - 1099 MISC reporting. The question they have had is how to deal with data outside their SAP system that is subject to 1099 MISC reporting.

  3. 11 Steps to a Successful Year-End Close for Fixed Assets
    by Thomas Michael, SAP Fixed Assets Product Expert, Michael Management Corporation

    Year-end closes often present problems both big and small. You can minimize these problems for both the current and subsequent year-end closes by following these simple steps.

  4. Accelerate Your Closing Process with mySAP ERP New G/L and New Functions
    by Aylin Korkmaz, Manager, Accenture UK

    Fast period closing enables quick identification, investigation, and elimination of accounting problems. Here’s how to take advantage of mySAP ERP’s new G/L and new functions in accounting for your fastest closings yet.

  5. Achieve Balanced Reporting by Automating Document Splitting in the New G/L
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software

    See the rules, steps, transactions, and method for document splitting. Then follow seven steps to configure it in your system.

  6. Achieve Cross-Fiscal Year Reporting with the Rollup Ledger in the SAP General Ledger
    by Karthik Tharkabhushanam, SAP Consultant, Infosys Technologies (December 2009)

    Overcome challenges presented with the SAP General Ledger for simultaneous reporting by using the rollup ledger.

  7. Advanced Techniques to Optimize R/3 Lockbox Performance and Accelerate Cash Receipts
    by Qian Sharon Tang, System Program Manager

    Take full advantage of lockbox functionality with these advanced tips. Learn about two user exits that can increase lockbox efficiency.

  8. Are My A/R and A/P Figures in PCA Wrong?
    by Drs. Stef Cornelissen, SAP Consultant, Proxyon B.V.

    Discrepancies between FI and Profit Center Accounting (PCA) figures often confuse even the most experienced controllers. The author shows how the transfer of balance sheet A/P and A/R accounts from FI to PCA can produce unexpected and bewildering results. He also explains the logic used to obtain PCA data.

  9. Are Your Stock Balances Correct?
    by Rohana Gunawardena, Principal Consultant, Exium, Inc.

    The answers to six questions along with a little-known report can help you to keep your R/3 Materials Management (MM) and FI stock balances in sync.

  10. Ask the FI/CO Expert: "Can the 'Special Fields' Settings Be Made Available to End Users?"
    by Kim Ciesla

    This month's "Ask the FI/CO Expert" question concerns ABAP List Viewer (ALV) functionality that was introduced in R/3 Release 4.6: specifically, how to make the "Special Fields" (such as Material #, Quantity, User name, and Entry date) available to end users. As this article explains, the secret is to run two quick ABAP programs after you have changed the Yes/No settings.

  11. Ask the FI/CO Expert: How to Manage Customizing Activities Directly in Production Without Using Transports
    by Nathan Genez, Platinum Consultant, SAP America Inc.

    In response to a reader's question, the author explains how to add a new G/L account to the financial statement version directly in the development system. Two confusing vocabulary words, "current settings" and "message control," have an impact on this everyday task.

  12. Ask the FI/CO Expert: What Are the "Line Item Display" and the "Only Balances in Local Currency" G/L Master Data Checkboxes Really Doing?
    by Kurt Goldsmith, Senior Consultant, ICM America

    These seemingly innocent checkbox items might have negative long-term consequences if you don't understand the questions they actually represent.

  13. Asset Accounting: Highlight Key Data Conversion Issues During Implementation
    by Yuval Nir, Managing Director, Financial Systems Consulting, TLR Tech Ltd.

    Prepare for an Asset Accounting implementation project with these best practices and tips for converting legacy data.

  14. Automate Accrual Calculation and Posting for Improved Flexibility
    by Kedar Muzumdar, Consultant, Infosys Technologies Limited

    See the process of percentage-based cost center-wise accrual calculation. You can then automate the subsequent financial posting using standard SAP functionality.

  15. Automate Your Intercompany Reconciliation Process in ECC
    by Srihari Subramaniam, Manager, Capgemini US LLC

    SAP ERP Central Component (ECC) includes more robust functionality for intercompany reconciliation during period-end closing. The reconciliation ledger helps to reconcile balances between companies and tags disputed or follow-up items. See how the intercompany reconciliation process works and how to handle the differences.

  16. Best Practices Migrating to the New General Ledger: A Three-Phase Approach
    by Gary Fullmer, SAP Labs LLC

    Use this three-phase approach to upgrade to the new G/L in mySAP ERP. mySAP ERP 2005 includes a migration tool to assist in the upgrade project.

  17. Complete the Manufacturing Process with Period-End Postings to Recognize Production Variances
    by Birgit Starmanns, Senior Director, SAP America (December 2009)

    After you manufacture a product, it is received into finished goods inventory at its standard cost. Understand the month-end postings that are necessary to clear any work in process on the production order, and to recognize manufacturing variances on the profit and loss statement.

  18. Comply with Sarbanes-Oxley Regulations by Locking Posting Periods in CO-PA
    by Jeffrey Holdeman, Principal Solutions Consultant, SAP

    Discover how to use the Profitability Analysis (CO-PA) valuation enhancement to lock posting periods against changes in CO-PA data. See also how this solution helps meet Sarbanes-Oxley compliance for internal controls on CO-PA reporting.

  19. Configure a Customized Document Splitting Method with Extended Splitting Rules
    by Yu (Kathy) Zhao, Deloitte Consulting USA

    Find out how to create a customized document splitting method with extended document splitting rules to meet business needs.

  20. Configure Automatic Account Determination for Logistics-Finance Integration
    by Naeem Arif, SAP Functional Lead, Service Birmingham Ltd., and Sheikh Tauseef, SAP Financials Consultant, Smith & Nephew, Inc

    Don’t face sleepless nights because your automatic account determination is creating integration issues between your logistics and finance departments. Discover the main configuration activities needed for automatic account determination and see the purpose of the common business transactions and keys that organizations use.

  21. Currency Types: The Key to Reporting Parallel Valuations
    by Rohana Gunawardena, Principal Consultant, Exium, Inc.

    Do you know what the different currency types are, where they are configured, and when to use them? Confusion abounds in this area, especially when dealing with parallel valuation. Use this roadmap to gain control of all of your conversions and valuations.

  22. Dealing with France, Italy, or Spain? What You Need to Know About Processing Bills of Exchange
    by Roy Brookes, Senior FI/CO Consultant

    The form of payment called bill of exchange provides a company with control over when payment is made. It is common in some European countries.

  23. Demystifying CO Module "Actual Costs" and "Actual Revenues"
    by Kurt Goldsmith, Senior Consultant, ICM America LLC

    Within the CO module, the data values "Actual Costs" and "Actual Revenues" have additional meaning not always found in other modules (such as Profit Center Accounting, Special Ledger, and Costing-Based Profitability Analysis). For FI/CO report users and developers, it is sometimes confusing how such a common, everyday word, "Actual," can represent a very uncommon, special relationship between the FI and CO modules. The article examines in depth the meaning of the term "Actual" in the context of the General Ledger and the CO module's Managerial Accounting Ledger. In the process, it also clarifies cases in other R/3 accounting modules where the terms "Actual Costs" and "Actual Revenues" both can and often do mean something other than what they do in the CO module.

  24. Discover Hidden Parameter IDs to Simplify Your FI Settings
    by Rohana Gunawardena, Senior SAP Consultant, Exium Inc.

    Many users set default values for their FI transactions using transaction FB00 - Accounting Editing Options. However, not all settings for FI/CO transactions are available here. In this article, I'll show you other ways to find and set default values for parameters. I'll also introduce you to some "hidden" parameters.

  25. Effectively Manage Post-Dated Checks with Portfolios
    by Shankar Kaza, SAP Financials Practice Lead, Mahindra Satyam (July 2010)

    See how to configure post-dated checks in your standard Bank Accounting submodule in FI. Follow the various process steps in a sample business scenario in Thailand.

  26. Formula Builder + BAdI = Easier Application of Business Logic
    by Anurag Barua, Manager, SAP Application Support, The Washington Post

    As of SAP Enterprise Release 4.7, Formula Builder functionality is embedded in all Business Add-Ins (BAdIs). That means you can assign formulas and logical statements to validations, substitutions, and rules without having to resort to ABAP code.

  27. Get Your SAP General Ledger Terminology Right
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software (August 2009)

    With the onset of SAP General Ledger, it is important to become familiar with a number of terms, vocabulary, and buzz words.

  28. Hone Your Manufacturing Cost Understanding for Better Decision Making
    by Birgit Starmanns, Senior Director, SAP America (September 2009)

    When a product is manufactured, an accounting entry is automatically made each time that a posting is made in the production process. Some of these postings take place in FI, while others are posted only in CO. Follow the flow of these accounting entries and understand the reconciliation process between FI and CO.

  29. How R/3 Accounts for the European Union's Value Added Tax
    by Roy Brooks, Senior FI/CO Consultant

    Europeans have lived with the Value Added Tax (VAT) for many years now, but to Americans or other non-Europeans who want to do business in Europe or to implement new systems in European subsidiary companies, VAT is often imperfectly understood.

  30. How to Delete Wrongly Entered Bank Statements
    by Kees van Westerop, SAP Consultant

    SAP R/3 does not provide a standard transaction to delete bank statements from the Banks module in FI. This can lead to time-consuming problems when erroneous statements make their way into your system. While there is no transaction code, there is a report that allows you to delete bank statements. It has the added benefit of being able to work as timesaving testing tool that can be reused again and again. However, there is a risk when you use the report. If a user accidentally clicks the delete button without deselecting the found bank statements, the report deletes all bank statements for all company codes.

  31. How to Integrate FI-AA with the New G/L for Segment Reporting
    by Aylin Korkmaz, Manager, Accenture UK

    With the new general ledger (G/L), you no longer need custom programs or user exits to obtain the asset balances for segment reporting. Instead, you can update profit center/segment details for all asset transactions and depreciation postings in the new G/L. Find out what settings you need to make in Asset Accounting (FI-AA) to make it happen.

  32. Improve Your Bad Debts Risk Reporting
    by Kees Van Westerop, SAP Consultant

    SAP's reserve for bad debt functionality can help you make more accurate A/R reports. This little-known functionality helps you to automatically transfer bad debts to special reconciliation accounts and post provisions for bad debts. In addition, it's easy to configure.

  33. Improve Your G/L Postings by Enabling Substitution of Relevant Fields
    by Dr. Kees van Westerop, Atos Origin, Senior SAP Consultant

    SAP limits the number of fields that you can use for substitution. If you want to use a field that SAP does not make available for substitution, you have to modify table GB01. Sometimes you can use transaction SE16 to make the modification, but more often you have to create a Z-program. An example shows how to make a G/L account available for line item substitution.

  34. Improve Your G/L Reporting by Summarizing Your Data
    by Srihari Subramaniam, Manager, Capgemini US LLC

    One of the key challenges for the summarization process is determining which field you need to use for summarization to achieve the best business impact. Understand various summarization levels, as well as process, configuration, and practical examples demonstrating when to use these summarization concepts.

  35. Maintain Data Integrity by Implementing Profit Center Planning in the New General Ledger
    by Yu (Kathy) Zhao, Deloitte Consulting LLP, USA

    Find out how to implement profit center planning in the new General Ledger and how to transfer planning data from Cost Center Accounting and Profitability Analysis to profit centers.

  36. Make SAP General Ledger Migration Cockpit More Flexible by Adding Your Own Activities
    by Mitresh Kundalia, Quality Systems and Software (September 2009)

    Fine-tune the migration cockpit to include your own activities in addition to standard ones so that you can see all the steps in one central place.

  37. New G/L Posting Program in SAP ERP 6.0 Requires Attention During Upgrades
    by Clay Molinari, SAP HR Consultant, C&C Savant, Inc. (February 2009)

    Evaluate the differences between the old G/L posting program and the new program available in SAP ERP 6.0. See how third-party posting processes affect your decision to switch processes and prepare your organization for various business scenarios.

  38. New G/L Reporting Features Financial Analysis at Various Levels
    by Kathy Zhao, Deloitte Consulting USA

    Find out what new reporting functionality and new reports are available in the new G/L.

  39. Overcome Performance Challenges When Migrating to SAP General Ledger
    by William Miller, Solution Architect, MI6 Solutions Group, LLC (November 2008)

    See how companies of all sizes and complexities can benefit from a new migration approach for SAP General Ledger (SAP GL). This approach seeks to reduce the activation downtime window of your SAP GL migration. Discover how to implement the migration technique over two weekends.

  40. Prepare Your R/3 System Now for the International Accounting Standards Deadline
    by Dr. Stef Cornelissen, SAP Consultant, Proxyon B.V.

    Impending deadlines for compliance with the International Accounting Standards (IAS) will require hard work on the part of many accountants and R/3 specialists. The problem posed by IAS is that, in most cases, two or more sets of figures have to be managed because of the differences among IAS, US GAAP, and national fiscal reporting.

  41. Profit Center Reorganization Is a Snap with New Functions in Enhancement Package 5
    by Janet Salmon, Solution Manager, SAP AG (August 2009)

    When your organizational structure changes, are you sure your profit centers are accurate? See how features in the forthcoming enhancement package 5 allow you to reorganize your profit centers in SAP General Ledger without the cost or headache.

  42. Provide Parallel Product Costs for Inventory Valuation in the SAP General Ledger
    by Janet Salmon, SAP AG (October 2009)

    See how to take the parallel accounting functionality available in the SAP General Ledger and apply it in CO. You can use it to calculate multiple activity rates and multiple inventory values for your finished goods at period close. This means that although your logistics flows (e.g., goods movements and order confirmations) continue to be captured at standard cost at the time of posting, you can calculate different activity rates and apply them to your finished goods inventories using the Material Ledger at period close.

  43. Quick Tip: Add Fields to Dynamic Selections in FI Line Item Display Reports
    by Yuval Nir, Managing Director, Financial Systems Consulting, TLR Tech Ltd.

    Learn how to add fields to dynamic selections in the G/L account, customer, and vendor line item display reports by maintaining selection views in the underlying logical database.

  44. Quick Tip: Can You Create Balanced Financials for Just Certain Profit Centers?
    by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software (January 2010)

    Walk through a simple example to see how to limit your balanced financials to specific profit centers.

  45. Quick Tip: Can You Group Segments in the SAP General Ledger?
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software (November 2009)

    Learn why you can’t group segments in the SAP General Ledger — but what you can do instead.

  46. Quick Tip: Check Your Settings for Sales/Purchase Taxes in an Instant
    by Kees van Westerop, SAP ConsultantConsultantSolutions, Paymetric, Inc.

    The customizing of tax on sales and purchases is often a complex and time-consuming process, as is checking the end results. Learn to leverage report RF_STEUERINFO, a little-known tool introduced in R/3 version 4.0A, for easier checking of your settings. The report itself doesn't indicate that something is wrong, but it reduces the checking process to one transaction.

  47. Quick Tip: Deactivate Document Splitting for a Company Code
    by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software

    You can deactivate a feature in the new G/L called document splitting for certain company codes while in the testing environment, thereby lessening the impact of testing on your system.

  48. Quick Tip: Display Table Contents Without Technical Help
    by John Jordan, ERP-Corp

    Using this simple technique, you can determine the name of a transparent table in a structure, or find a field name from data that is in a structure, without assistance from a technical team.

  49. Quick Tip: Easily Display Automatic Account Determination Settings
    by John Jordan, ERP Corp

    Learn how to easily display only relevant table contents of automatic account determination settings with transaction SE16N. This can assist you in quickly analyzing financial account balances, especially those associated with inventory and settlement transactions.

  50. Quick Tip: Eliminate Manual Adjustment Postings by Using a Standard BAdI in the Accrual Engine
    by Karthik Tharkabhushanam, SAP Consultant, Infosys Technologies (October 2009)

    Process Accrual Engine accounting documents with multiple account assignment objects with less manual effort for more efficient reporting.

  51. Quick Tip: Enter the Right G/L Accounts When Creating Account-Assigned PRs or POs
    by Naveen Sharma, FI/CO Consultant, Satyam Computer Services

    You can use SAP’s validation tool to define rules to validate the data you have entered. One such application is to define the quality assurance checks that are applicable when you create or change account-assigned purchase requisitions or purchase orders.

  52. Quick Tip: G/L Terms Defined: What Are the Flex G/L, Split Processor, and the New G/L?
    by Nathan Genez, Platinum Consultant, SAP America

    The new G/L that comes with the mySAP ERP 2004 release is in Ramp-Up. The author provides a preview of its functionality and explains how it differs from the Flex G/L and the split processor.

  53. Quick Tip: How to Build a Business Case for the SAP General Ledger
    by Gary Fullmer, MI6 Solutions (March 2010)

    Many SAP professionals believe that only the requirement to adopt International Financial Reporting Standards will drive the adoption of the SAP General Ledger. In reality, there are at least 10 other benefits to the new technology that you should use to help build a better business case for the SAP General Ledger adoption and possible migration.

  54. Quick Tip: How to Get the Check Number into an FI Document
    by Kurt Goldsmith, IT Productivity Developer, Enowa Consulting

    Starting with Release 4.0C, the R/3 system comes delivered with a program you can use to add the check number to the automatic journal entry.

  55. Quick Tip: Keep Your Chart of Accounts in Synch Across Clients and Environments
    by Quentin Hurst, Senior Principal, Virtuoso LLC

    SAP provides two seldom-uses tools that will help you keep your Chart of Accounts in synch among multiple instances and clients. This article describes where to find them and how they work.

  56. Quick Tip: Manually Adjust Postings from FI to CO-PA
    by Drs. Stef G. M. Cornelissen, MBA, SAP Business Consultant, Sperry Partners BV

    See how to ensure that Profitability Analysis reporting mirrors the corrections you post in FI.

  57. Quick Tip: Review and Analyze Document Splitting Rules in One Place
    by Mitresh Kundalia, Director, SAP Practice, Quality Systems & Software

    Use a simple icon to find one screen that shows all your document splitting rules.

  58. Quick Tip: SAP GL Data Sources: Which Tables Should You Use?
    by Rohana Gunawardena, SAP Practice Director, Quality Systems & Software (February 2009)

    When upgrading, users may take reports from the classic General Ledger (GL) and assume they will work in the SAP GL (formerly called the new GL). This isn’t always the case. See the differences between key tables containing SAP GL data and identify where you need to look for data.

  59. Quick Tip: Simplify Expense Account Selection with Keywords
    by John Jordan, ERP-Corp

    Learn how keyword search functionality can help your users, or groups of users, choose the correct G/L expense account when they create purchase requisitions or purchase orders.

  60. Quick Tip: Tie G/L and Profit Center Balances by Solving a Common Mistake in EC-PCA
    by Marco Jordy, Senior Consultant, ORBIS America

    Differences between the account balances in G/L and Profit Center Accounting (EC-PCA) are most common shortly after the go-live of an SAP finance project. The number one mistake is a missing customizing setting. The author describes the best way to identify this problem and synchronize the two ledgers.

  61. Quick Tip: When to Deactivate the Classic General Ledger Totals Table in the New G/L World
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software

    See how to deactivate GLT0 when converting to the new G/L, and some considerations when doing so.

  62. Quick Tip: You Still Need the CO-PA Ledger for Margin Analysis Reporting
    by Mitresh Kundalia, SAP Practice, Quality Systems & Software

    Discover a misconception about the new G/L’s ability to replace traditional ledgers.

  63. R/3's Accrual Option: Same Setting, Different Functions in Sales Orders and Purchase Orders
    by Kurt Goldsmith, Senior Business Consultant, Enowa Consulting

    Freight costs are not easy to account for. The challenge comes from timing differences. You often might not know the real costs for a month or so. One functionality in R/3 that can help accountants with the timing issue is referred to as the "accrual" option in sales order and in purchase order (pricing) condition types. They may or may not be useful for you. To decide, you must first get past one confusing aspect of this field setting - it behaves differently in sales orders than it does in purchase orders. One setting. Two results. Not nice.

  64. Reconcile FI-AA with FI-GL After Fixed Asset Data Takeover
    by Thomas Michael, Senior SAP Product Expert, Michael Management Corporation

    Take these steps to reconcile the Asset Accounting sub-ledger with FI-GL after you complete the initial go-live implementation when you bring over the asset data from your legacy system into your SAP system.

  65. Reduce Potential SAP General Ledger Migration Errors with Validation for Document Splitting
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software (December 2009)

    Enable validation of document splitting in the SAP General Ledger and identify potential issues you could face early on. That way, you can take appropriate actions and prevent the accumulation of error documents while also improving the data quality for migration.

  66. Reduce Time-Consuming Reconciliations with Real-Time FI/CO Integration
    by Manish Dharnidharka, Manager, SAP, BearingPoint, Inc.

    In SAP ERP Central Component (ECC) systems, you can use a different process for reconciling FI and Controlling (CO) documents than what you did in R/3. FI and CO were often out of sync in R/3 because costs that were moved or altered in CO did not automatically translate into FI. See how to set up real-time FI/CO integration so that the two modules are in sync in real time.

  67. Secure Your Revenue Stream: Ensure That SD Billing Document Invoices Are Posted in FI
    by Rohana Gunawardena, Principal Consultant, Exium, Inc.

    It is possible to have an SD billing document without a corresponding FI invoice. This type of error can result in significant under-reporting of revenue. Take these steps to ensure all SD invoices are reflected accurately in FI-AR.

  68. Set Up a Cash Journal to Enhance Your Internal Controls
    by Dr. Kees van Westerop, Atos Origin, Senior SAP Consultant

    See how to set up a cash journal and how to use it to record cash transactions and monitor your cash position.

  69. Simplify Segment Reporting with the New General Ledger
    by Aylin Korkmaz, Manager, Accenture UK

    Find out how the new General Ledger (G/L) in mySAP ERP differs from the classic G/L. With its new segment functionality, you do not need to create a Special Purpose Ledger to meet different compliance standards.

  70. Streamline Your Parallel Accounting with the New G/L Ledger Solution
    by Aylin Korkmaz, Manager, Accenture UK

    See how to set up parallel accounting with the ledger solution in the new G/L with three procedures: ledger definition, currency valuation, and asset accounting.

  71. Structure Consumption Accounts to Reflect the True Cost of Sales
    by Paul Ovigele, SAP Consultant (September 2010)

    Learn the configuration settings that determine which accounts are posted to when performing the various transactions on a production order (e.g., goods issue, confirmation, goods receipt, work in process, overhead, and variance calculation). Then see how to structure these accounts in their financial statements to reflect the true cost of goods sold.

  72. The Split Processor-Making Balanced B/S and P&L Reports Possible for Business Area, Profit Center, and Fund
    by Tami Becker, SAP America Inc.

    Do you want to produce balanced reports by elements lower than a company code, or by elements that cross company codes? The split processor, part of the FI Special Purpose Ledger, works well to provide balanced reporting for business area, profit center, and fund. The author shows how to use the split processor to get three additional fields for balanced financial reporting.

  73. The Surprising Relationship Between G/L "Relevant to Cash Flow" setting and A/R Standard Reports Showing Customer's Last Payment
    by Kurt Goldsmith, Senior Business Consultant, ICM America

    A little-known relationship between a G/L setting and an A/R standard report can result in a frustrating mystery for end users, who can see two different results on two different occasions from doing what they probably perceive to be the same cash-application steps. This article clears up the confusion.

  74. Three Ways to Ensure Accurate Depreciation Values in ECC
    by Nathan Genez, Managing Partner, Serio Consulting LLC

    The primary focus of the Asset Accounting (FI-AA) sub-ledger is to accurately calculate and track values for fixed asset records. Often it is possible that planned values stored in FI-AA do not reflect the existing system configuration and therefore are incorrect. You can use program RAAFAR00 (recalculate values) to ensure that calculated amounts are correct.

  75. Track Service Contract Prepayments in a Hidden Project System Option
    by Marco Jordy, Vice President of SAP Finance Consulting, ORBIS America, Inc.

    A common problem with service contracts is how to account for them correctly in financial statements, taking into account existing customer prepayments and revenue in excess. A customizing setting, hidden in the account determination of the Project System (PS), allows you to generate additional G/L entries to move customer prepayments into the receivables section of the balance sheet.

  76. Transport Customizing Settings Between SAP Environments Using Transport Requests
    by Kees van Westerop, Senior SAP Consultant, Atos Origin

    Learn how to easily transport a company code’s chart of accounts from a development system to other environments by modifying a transport request.

  77. Understanding the SAP Parallel Valuation Function
    by Kurt Goldsmith, Senior Consultant, ICM America LLC

    Learn how you can use this not-well-understood function to allow a single goods movement of a single material to trigger multiple and simultaneous postings to the G/L.

  78. Unearth the Hidden Secrets of Zero-Balancing in the New G/L
    by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software

    International financial regulations require you to zero-balance your financial data by certain characteristics, such as segments. See how to zero-balance characteristics in the new G/L, and how the system addresses the varying number of line items you may have.

  79. Use Document Simulation in the New G/L to See How the System Posts G/L Documents
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software

    The classic G/L offers a feature called document simulation that helps you determine how the system automatically generates accounting entries, troubleshoot and fix missing configuration settings, and identify and rectify any mistakes made before posting the accounting transaction. This feature has improved in the new G/L and adds particular benefit to document splitting. Using document splitting, you can balance the document for predefined characteristics at runtime rather than waiting until period-close.

  80. Use Reconciliation Account Determination with a Special G/L Indicator for More Flexible Invoicing
    by Rohana Gunawardena, Senior Consultant, Exium, Inc.

    The author demonstrates how to optimize reconciliation account determination. He introduces the fundamentals of reconciliation account determination, special G/L indicator configuration, and manual adjustments. With examples, he shows how to use reconciliation account determination with a special G/L indicator in the FI-A/R module.

  81. Use Your Program Variants More Effectively with the Help of TVARV Variables
    by Mitresh Kundalia, Director – SAP Practice, Quality Systems & Software Inc.

    Instead of manually changing the selections in a program variant, you can make the system change the variant values automatically. This saves time, especially if you are running hundreds of reports.

  82. Using the SAP Query to Solve Your Reporting Requirements
    by Tami Becker, Platinum Consultant, SAP America

    Have you ever asked yourself, "How can I create an easy report with only the fields I want to see on it?" The author suggests you try the SAP Query.

  83. Want to Automate Your Monthly or Yearly Accruals?
    by Tony Rogan, Senior Consultant, Hitachi Consulting

    SAP R/3 4.7 functionality offers the choice of automating your accrual processing. Learn about the SAP R/3 Accrual Engine and see how it compares to R/3's accrual/deferral feature.

  84. What You Need to Know to Migrate to the SAP General Ledger
    by Gary Fullmer, Solution Manager — Financials, SAP Labs LLC

    SAP has refined the migration process to the SAP General Ledger. Find out what is new and learn some best practices developed during 11 recently completed migration projects.

  85. What's an "Assignment Number," and How a Misunderstanding Can Give Your End Users an Unfriendly Surprise
    by Mitresh Kundalia, Senior FI/CO Consultant, Zen & Art

    A default sort allows you to sort accounts by different criteria, such as expense accounts by cost center and assets accounts by asset number. Its role is sometimes confusing, however, and therefore it is underused in the FI module. The author clears up two sources of confusion - terminology, and the possibility the system presents of setting up two defaults. The customer or vendor account number has a sort key setting in its master. And, the linked G/L account number has a second (and separate) sort key setting in its (G/L) master.

  86. Why Can't I Find My G/L Account?
    by Rohana Gunawardena, Principal Consultant, Exium, Inc.

    R/3 stores G/L account numbers differently depending on whether they are stored internally or externally. This can cause problems when a user searches for G/L account data using transactions SE16 or SE17. The author explains conversion exits and their implications and also provides tips for user-friendly G/L account searches.

RECENTLY ADDED

Structure Consumption Accounts to Reflect the True Cost of Sales

Use Search Strings with Electronic Bank Statements to Perform Automatic Clearing

How to Set Up Product Costing for Subcontracted Materials

Maintain Master Data Directly in the Production Client with SEM-BCS

Effectively Control and Monitor the Purchase Price Variance

Subscribe to the RSS feed

Subscribe to the RSS feed.

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@financialsexpertonline.com.
Financials Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.