Skip to Content
0

Trail balance mismatch after running program SAPF070&SAPF071

Mar 21, 2017 at 11:38 AM

87

avatar image

Respected Gurus,

Business has raised an issue in FY-2017 January 10th that there was a FS10N balance mismatch for vendor reconciliation GL-200000 and total vendor balances and GL-line item display for period 09 credit balance for FY 2016 in 4.6c system.

After completion of all investigations my senior colleague has suggested to run first report SAPF070 and SAPF071 to correct/adjust balance's has clearly shown that there was credit balance mismatch 13,564.07,so we ran SAPF071 in Jan-30-FY 2017,system has clearly shown that only for GL-2000000 updated with credit balance for period 09 for local currency with ledger -00,now FS10N and FBL3N matched,issue was closed.

We have already ran F.16 to carry forward balances from FY 2016 to FY 2017.Now when we run trail balance-F.01 from period 01 to 08,every thing was matched,when we take period 01 to 09, there is credit balance mismatch of 13,564.07.If system might have added credit balance in Trail balance report then it matches. from FY 2016 period 09 to till current period 03-FY2017 same credit balance is showing as mismatch.

when we compare GL-2000000 in FS10N and trail balance ,GL line item values matching,only in total credit balance of trail balance it has not updated.Before i ran programs SAPF070/SAPF071, TB was matching.

SAP has told that you should not run this program. Only SAP experts has to run this program.Earlier my colleague ran this program in ECC 6.0,no issues faced.only in 4.6C i am facing this issue.SAP expecting some paid service for 4.6C which is not being approved by my client side.Request you to check and suggest feasible solution.

Thanks in Advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Eli Klovski
Mar 21, 2017 at 02:47 PM
0

Hi,

If it's a reconciliation account for vendors, make sure that YE steps are performed also after you executed SAPF070(1). You mentioned that you ran F.16, but did you equally run F.07? If it doesn't help, provide, the data from the relevant tables. It would be GLT0 and BSIK/BSAK, if it's reconciliation account. Also, make sure that no direct postings to this account were done.

Regards,

Eli

P.S. Of course, SAPF070(1) should have been launched with great precaution foreseeing in advance the desired effect of such action. Best thing to do would have been running it first in a test environment.

Share
10 |10000 characters needed characters left characters exceeded
Sai Chakka Mar 22, 2017 at 01:20 PM
0

Hi Eli,

Thanks for your valuable Inputs.

Here issue not with not year end balances.I ran SAPF070 in test mode,system shown clearly that there was a credit balance mismatch for period 09,FY 2016,so i ran SAPF071 in Live mode,output shown as credit balance 13,564.07 updated for reconciliation GL-2000000 in company code GBxx in currency type 10 with ledger-00.

I have checked earlier that there was no posting directly to vendor reconciliation-2000000.When you compare GL balances(S_ALR_87012277) for period 1 to 9,FY2016 with FS10N GL balances,figures are matched exactly.As you know S_ALR_87012277 reflects trail balance report.But same S_ALR**** report shown some credit balance 13,564.07 pending with out mismatch at total level,same reflecting in F.01(TB) report total level credit balance mismatch.Is there any program by which we can reverse or correct this inconsistency?

Thanks in advance

Sai

Share
10 |10000 characters needed characters left characters exceeded