cancel
Showing results for 
Search instead for 
Did you mean: 

Cumulative Balance 0f 0FI_GL_10 is not matching with FS10N Cumulative Balance data

Former Member
0 Kudos

Hello,

I'm designing GL summary report. We know that New GL data stores in FAGLFLEXT table.

0FI_GL_10 extracts data from FAGLFLEXT table.

before creating report, I did initial level of data validation 0FI_GL_10 data with SAP provided GL summary Tcode FS10N data.

but Cumulative balance of 0FI_GL_10 extractor is not matching with FS10N cumulative Balance.

Santhosh

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member202718
Active Contributor
0 Kudos

Hi Santosh,

Get in touch with FI Consultant as to which T.Code it should match.

The FI_GL_10 should match with FBL1N.

Rgds

SVU

former_member197610
Active Contributor
0 Kudos

SVU,

FBL1N is related to vendor line item... this will not be helpful to tie-out FLEXT and the GL  data.

former_member202718
Active Contributor
0 Kudos

yes Suresh,its FBL3N.

We usuallly try to match the data with FBL3N.

rgds

SVU

former_member197610
Active Contributor
0 Kudos

SVU,

Yes, FBL3N but you said FBL1N.

Santhosh,

You can try using the Txn - F.08 too to check the accumulated Balances.

Hope this helps...

former_member202718
Active Contributor
0 Kudos

Hi Suresh,

My apologies ,that was a typo....will correct it.

Matching...Accumulated Balances and GL Account..we need to Figure out

but certainly FBL1N,FBL3N and FBL5N can be matched with 0FI_GL_10 with GL restrictions...

rgds

SVU

former_member197610
Active Contributor
0 Kudos

Santhosh,

Check this, in case if you miss anything.

Former Member
0 Kudos

Hi Santhosh,

Did you maintain the Key fields properly in the DSO data flow as i remember the key fileds of standard DSO were not suffice to get all the records.And for the certain GL check the FAGLFLEXT & FAGLFLEXP table also.Which will give you an idea what was happening.

Regards,

Rambabu