FAGLB03 Report total balance in Group Currency

[former_member587145]

Hi All,

I need a clarification on how the FAGLB03 report total balance gets converted to group currency. Total amount in document currency gets converted to the group currency by the exchange rate maintained to the date or is it an average amount?

I have the same question related to FBL3N report as well

Thank you,

Dhanushi

[sanilbhandari · Accepted solution]

Hi dhanushi.seneviratne

The conversion to Group Currency is based on the configurations set up in OB22 in ECC or FINSC_LEDGER in S/4HANA. The conversion can happen from local currency or document currency as the base and exchange rate type specified in the configuration. In every document posting, this translation happens and information is stored at line item level in BSEG and FAGLFLEXA tables in ECC. The totals are stored in FAGLFLEXT per GL Account in ECC

In case of S/4HANA, this information at line item level recorded in BSEG and ACDOCA.

When the FBL3N is executed, data is drawn from line item tables like BSEG and FAGLFLEXA ffor line item data and FAGLFLEXT for totals data. In case of S/4HANA this data comes from BSEG and ACDOCA

In case of FAGLB03, the data is called from ACDOCA in S/4HANA and FGALFLEXT in ECC.

If you want to understand further in details the configuration and translation, please review the wiki document below, where it is explained beautifully.

https://wiki.scn.sap.com/wiki/display/ERPFI/Additional+currencies+and+allowed+changes+in+OB22

It has also reference to all the relevant OSS Notes related to this topic.

Thanks & Regards

Sanil Bhandari

[former_member587145 · Accepted solution]

Hi Sanil,

Thank you for your reply

But my concern here is how does the FBL3N or FAGBL03 total converts to the Group currency? For an example if the total is 75,045.63 CNY how does it converts to Group currency which is USD. What is the logic or the base for it, does it take the current date exchange rate?

Data picks from FAGLFLEXT for totals data, but what is the logic or the formula to convert the line item conversion to total?

Best Regards,

Dhanushi

[sanilbhandari · Accepted solution]

Hi dhanushi.seneviratne

It takes up the exchange rate when the document was posted and updates the total and line item tables. Assuming you have twelve periods in your Fiscal Year variant. Now assume your LC is CNY and GC is USD. Assuming you have posted the below entries on day 1 of period 1

Day 1 : Ex Rate Type M CNY to USD =0.15

Expense GL Dr CNY 100

To Accrual GL CNY 100

if you set up the data to read from local currency and use ex rate type M, than the above figure will reflect in Group Currency as

Expense GL Dr USD 15

To Accrual GL USD 15

So the field FAGLFLEXT-KSL01 (Field for balance in Group Currency in Table FAGLFLEXT) will have a balance of USD 15 for Accrual GL

Day 2 Ex Chg Rate Type M CNY to USD=0.17

Expense GL Dr CNY 10

To Accrual GL CNY 10

In Group Currency this would look as below

Expense GL Dr USD 1.7

To Accrual GL USD 1.7

Now the field FAGLFLEXT-KSL01 will have a balance of USD 16.7. This will contain USD 15 from Day 1 and USD 1.7 from Day 2. The exchange rate type used will be M based on your company code configuration in OB22.

When you execute FAGLB03 for the period, assuming that only two entries are posted for accrual gl, than you should see the balance as USD 16.7

This is how the standard design is expected to work. If there is a custom development, where you are keying in the local currency and Group Currency in FB01 based development, than it can be a different thing.

Hope this helps

Thanks & Regards

Sanil Bhandari

[former_member587145 · Accepted solution]

Hi Sanil,

Thank you for your explanation

If I take your example and see this in FAGLB03 or FBL3N report for Local currency it will show as 110 CNY (Local Currency Total) and 16.7 USD (Group currency total). So basically if we try to take the exchange rate for this, it would be 6.586 which is logical

In our report it shows as 75,045.63 CNY total and 0.23 USD total which is not realistic. There is no postings to this GL since 2016 and the totals shows as this. We have performed the revaluation as well yet the balances are abnormal

Best Regards,

Dhanushi

[sanilbhandari · Accepted solution]

Hi dhanushi.seneviratne

The explanation that I provided is how it should work in a standard way.

Now coming to your specific issue of your unrealistic balance in a specific GL Account and how to identify the problematic document(s), I agree to your statement that the balances are unrealistic. You can check the below steps to find out the source of error:

1) Download the documents period by period in an excel sheet from BKPF and FAGLFLEXA. The key fields to look for would be exchange rate, amount in LC and GC. Than in the exchange rate look for any document for any such exceptional exchange rate.

2) From the document list in point 1 above, check if there is any document, which has been uploaded by a custom program or interface. I have seen lot of customers use custom upload program for journal entries. Check for such documents where Reference Transaction (BKPF-AWKEY=BKPFF). Generally in such kind of postings, one would pass the transaction currency, local currency and group currency. if that is the case, there is a chance of a wrong entry due to which you see abnormal balances

3) I am not sure, when did you go live on SAP. However, there could also be a chance that this balance is a result of an incorrect entry in opening balances.

4) If your customer has ever migrated from classical GL to New GL, than opening balances in New GL are updated using transaction code FBCB. This transaction allows entries in Local Currency and Group Currency. In this case, system does not look at exchange rate type as normally it should and depends on manual entries through the transaction

These are some of the ways, one can start looking at for such wiered exchange rates as you mentioned.

Thanks & Regards

Sanil Bhandari

[former_member587145 · Accepted solution]

Thank you Sanil for the explanation

[former_member698447]

Hi Dhanushi,

Total value is coming from the line items only, Am i correct.

Still if you are looking for more analysis, Can you please help us with any screenshot for more details.

[former_member698447]

Hi Dhanushi,

On the above example if the total is 75045.63 CNY(Suppose in this amount there are two Invoices one has been posted on 1st Jan & Next it has been posted on 1st Feb.

On this dates whatever the exchange rate has been maintained it will pick that amount only, it will not take the current date exchange rate & For this base will be document only, you can check in document display Currency tab what ever the currencies has been maintained it will display according to that.

Best Regards,

Repakula Manoj

[former_member587145]

Hi Manoj,

Yes if total is 75045.63 CNY, how does it get converts to the USD total value not the line item value

Best Regards,

Dhanushi