SAP Program FAGL_MM_RECON - Balance Reconciliation Between General Ledger and Materials Management

Purpose
You use this report to compare the totals of the valuated stocks fromthe material masters against the totals of the assigned balance sheetaccounts in a ledger in new General Ledger Accounting.
If the material ledger is activated for a valuation area, the reportdetermines the material stocks from the material ledger. If the materialledger is not activated, the report determines the material stocksdirectly from Materials Management. The stocks compromise the followingstock types:

  • Material Stock Valuation

  • Order Balance Valuation

  • Project Balance Valuation

  • Subcontracting Balance Valuation

  • Other than the balance sheet accounts in the general ledger, the reportalso determines the assigned G/L account assignments, provided that theyhave been activated in the ledger. The balances are compared at theaccount assignment level.
    You can run the analysis for the following G/L account assignments:
    • Business Area

    • Profit Center

    • Segment

    • Analysis is only possible when General Ledger Accounting and MaterialsManagement share the same the periods; the start date and end date ofthe posting periods need to be the same in Materials Management and inGeneral Ledger Accounting.
      &NOTE&
      A G/L account assignment must be uniquely assigned to a material stock.In the case of a variable assignment, such as when different segmentsare used for a profit center, a comparison for such a G/L accountassignment would not produce any valid results.
      &NOTE&
      The report requires the standard logic for deriving G/L accountassignments to be applied in the case of postings in special stock asper SAP Note 530578. With this logic, postings are made to the profitcenter or the business area of the material in stock items andoffsetting items until goods issue for delivery to the customer. Forthis reason, ensure that the solutions described in the SAP Note areimplemented.
      You can add additional G/L account assignments for the evaluation: Forthis, use the Business Add-In (BAdI) FAGL_MM_RECON in Customizingfor Financial Accounting (New) under General LedgerAccounting (New) -> Tools -> Customer Enhancements -> Business Add-Ins(BAdIs) -> Master Data Enhancement for Balance Reconciliation BetweenGeneral Ledger and Materials Management. Note the prerequisites forinsertable G/L account assignments described in theBAdI documentation.
      You can also run the report for periods occurring in the past. However,the report always applies the current assignments for the master data(such as the profit center assignment in the material master). Ifchanges have been made to the master data assignments between the timewhen the period was analyzed and the time when the analysis is run, thereport might output differences that did not actually exist at the timewhen the period was analyzed. We therefore recommend using the logfunction to save the analysis before reorganizing account assignmentsand analyzing past periods using the logs thus saved.
      &RECOMMENDATION&
      We recommend starting this report at regular intervals, such as atmonth-end or year-end.

      Integration
      When performing the analysis, the report does not lock thematerials. The system continues to update stock values and quantitiesand to make postings to the checked G/L accounts. For this reason, thereport might output differences even when there are no inconsistenciesin the system.

      Prerequisites
      To be able to run the report and to display the results, you need tohave the following authorizations:

      • Accounting Document: Authorization for Company Codes

      • Accounting Document: Display Authorization for G/L Accounts

      • General ledger: Display Authorization for Ledgers

      • Depending on the components that are activated in a ledger, youadditionally need to have the following authorizations:
        • Accounting Document: Display Authorization for Business Areas

        • General ledger: Display Authorization for Segments

        • Authorization Check on Area of Responsibility (Profit Center)
        • Selection

          • Company Code

          • Specify the company code for which you want to run the report.

            Period Selection in Materials Management

            • Fiscal Year

            • Specify the fiscal year of the posting period in Materials Managementfor which you want to run the report.
              • Posting Period

              • Specify the posting period in Materials Management for which you want torun the report.
                If the material ledger is not activated, you can only run the report forthe following periods:
                Current Posting Period
                Previous Posting Period
                Last Posting Period of the Previous Year
                If the material ledger is activated in all valuation areas of thespecified company code, you can select any posting period.

                General Ledger Selection

                • Ledger

                • Special the ledger in General Ledger Accounting for which you would liketo determine the balances. The report only valuates the balance-relevantG/L account assignments that are activated in that ledger.
                  In the analysis for the stocks in the material ledger, only currenciesactivated in this ledger are relevant for the comparison.
                  • G/L Account

                  • You can restrict the analysis to individual G/L accounts or ranges ofG/L accounts.

                    Output

                    • Log Parameters

                    • You can output the log immediately or save it for output at a laterdate. In this way, you can select the "Save Log" option, for example,when running the report in the background. You use the Logs pushbuttonto display saved logs at a later point in time and to analyze theminteractively.

                      Processing

                      • Parallel Execution

                      • To improve system performance, you can distribute the workloadinternally across multiple parallel processes.
                        However, it is only useful to use parallel execution if a large amountof the materials in the system are used in the selected company code.

                        Output
                        In the SAP List Viewer, the report shows the analysis result atthe balance sheet account level and at the level of the G/L accountassignments activated in the ledger.
                        By double-clicking one of the totals determined, you can navigate to adetail list:

                        • Material Total: Navigation to a list of the individual materials.
                        • From here, you can navigate to the report Display Material (whichdisplays the relevant material master data).
                          • General Ledger Total: Navigation to the report G/L Account
                          • Balance Display (which displays the balance on the balance sheetaccount)
                            &NOTE&
                            If you run the evaluation in a stored log, you navigate to the reportsDisplay Material, Material Price Analysis, and G/LAccount Balance Display for the current point in time. In this case,the stock displayed in the material master data, for example, does notmatch the stock displayed in the report.

                            Activities
                            To call this report, go to the SAP Easy Access menu and chooseAccounting -> Financial Accounting -> General Ledger -> PeriodicProcessing -> Closing -> Check/Count -> Balance Comparison: GeneralLedger - Materials Management.