Difference in the Balance between FS10N and Customer Balances in Local Curr

[Former Member]

Hi,

When i am trying to match the Balances between FS10N and Customer Balances in Local Currency for the Period 8, we are getting the difference, The reconcilliaton Account was changed on 30.08.2010.

Please help Us in tracing the differences between FS10N and Customer Balances in Local Currency.

What could be the possible reasons for the differences..

Thanks

[Former Member · Accepted solution]

Hi

You can pull out the data from tables.

1. Giving in selection criteria Reconciliation GL Accounts.

2. Giving in selection criteria date range for both Reconciliation Accounts.

Rgds

Vani

[Former Member]

Hi

Please check in through FBL3N for both the reconciliation accounts balances seperately and tally with customer balance.

Rgds

Vani

[Former Member]

Hi,

The Reconciliation Account will not have Line Item Display, so we will not be able to Pull up the Balance..We have to make use of FS10N, wherein we dont have Date option.

Thanks,

[Former Member]

Hi Varshani,

Please use the program/report SAPF070 to compare or reconcile your AR with GL balances. You can use SAPF071 to correct any inconsistencies. Provided below documentation for these programs.

SAPF070 - Compare Documents and Account Transaction Figures

Description

This program compares debit and credit transaction figures in customer, vendor, and G/L accounts with the debit and credit totals from documents posted in the corresponding posting period (accounting reconciliation). The sales totals are also compared for customer and vendor accounts. There is no separate comparison for special G/L transactions.

A comparison for G/L accounts can be made in company code currency and in parallel currencies (such as group currency). A comparison for customer and vendor accounts can only be made in company code currency.

After the program has finished, a message is issued to the user that started the program. This message summarizes the results of the reconciliation.

Output

The program compares the totals of an account on a periodic basis. If the debit and credit total differs between account and documents, the account is printed with the debit and credit totals and the difference.

Differences in G/L accounts are shown per transaction currency. The first line shows the amount in local currency, the second line shows the amounts in transaction currency.

If a document which falls within the selection range is posted during the program run, the program is terminated since a reliable result can no longer be delivered.

SAPF071 - Adjust Balances after Comparing Documents/Transaction Figures

Description

If a financial accounting comparative analysis (SAPF190) or a comparison of documents and transaction figures (SAPF070) shows that there are differences between documents and transaction figures, you can use this program to make an adjustment. The documents form the basis for this adjustment. The program adjusts the (redundant) transaction figures, which are only totals of amounts from documents.

Requirements

All of the following listed requirements must be fulfilled:

1. A financial accounting comparative analysis (SAPF190) or a comparison of documents and transaction figures (SAPF070) must be made, and differences must be found between documents and transaction figures.

2. There must not be any inconsistent documents found. These are listed in both SAPF070 and SAPF190 as well as in this program.

3. There cannot be any problems in the other modules. Caution: You have to check this yourself. Financial Accounting may be correct but the other modules may not be, and this will adversely affect the program run.

4. You can only make the adjustment in the ledgers which are compared by program SAPF070. This is ledger 00 or a user-defined ledger for all parallel local currencies except the group currency. (The program displays these ledgers). You have to adjust any additional ledgers as well as average balance ledgers yourself.

5. No documents during the period in which you are adjusting transaction figures can be archived. Caution: You must ensure that these documents are not archived by establishing appropriate organizational rules and procedures.

Only use this program after consulting with SAP or after checking the prerequisites thoroughly.

You should adjust all differences together for a single company code. By setting the program parameters you can limit the adjustment to G/L currency types or to balances in subledgers.

It is advisable to execute a test run first, which will list any differences that are found.

Further notes - Authorizations

Repair program authorization group (F_005)

Company code authorization (F_BKPF_BUK)

--

Thanks

Venkata Ganesh Perumalla

Edited by: Venkata Ganesh Perumalla on Sep 28, 2010 1:30 PM

[Former Member]

Hi

Please check both the reconciliation accounts balnces with Customer Balances.

1. Before 30.08 Reconciliation Account Balance

2. 30.08 changed Reconciliation Account Balance

Rgds

Vani

[Former Member]

Hi Vani,

I dont see any option of keying in the date in the Report S_Alr_87012172 to know the balance of the Reconciliaton Accoun till 30.08.2010

Thanks,

[Former Member]

Please check in FBL3N

Regards,

SDNer

[Former Member]

Hi,

If i have to view the Balance of Reconcilation Account for a Particular Period.

Please help me in knowing where i will be able to view it.

Thanks,