3416241 - Differences in amounts between the Ending Balance Company Currency and the Ending Balance Line Item Currency while trying to run the Trail Balance Report.

You run the Trail Balance Report - The issue is that the value derived by the system in the Line Item Currency does not appear to be related to the value in the Company Currency column.

For the Trial Balance you expect that the value presented in the Ending Balance Company Currency would be the GBP conversion of the Ending balance Line Item Currency which is in USD. When you drill down to the G/L line item you are unable to find how the system is deriving the value for the Ending Balance Line Item Currency.

So you want to understand why there is discrepancy between the Ending Balance Company Currency and the Ending Balance Line Item Currency.

SAP Business ByDesign.

1) Go to General Ledger Work center.

2) Under Reports sub view, go to list.

3) Search for the Report : Trail Balance.

4) Give these Data selection;

Company, Set of books, Accounting Period/year, G/L accounting report structure.

5) Here you will see the discrepancy in amounts between the Ending Balance Company Currency and the Ending Balance Line Item Currency.

Usually one of the reasons for this significant discrepancy might be, between the Ending Balance Company Currency and the Ending Balance Line Item Currency is due to Manual Journal Entry voucher. The system is ignoring the Manual Journal Entry Voucher when it comes to the Trial Balance Company Currency.

Firstly you should not try to post the Manual Journal Entries to the Cash subledger accounts, which is not recommended. Usually we don't recommend manual entries to any subledger accounts as manual postings. Also Cash subledger accounts will not update in the Cash Trial Balance. Line Item/Transactional Currency amount will flow from the actual transactional line items. 

So Company Currency column is showing amount from Manual Journal Entry Voucher and Line Items Currency Column is not showing this balance, this caused the huge difference in the Currency and Line Items Currency values. 

https://i7p.wdf.sap.corp/sap/support/notes/2768069

Ending Balance Company Currency, Ending Balance Line Item Currency, Trail Balance, Cash subledger accounts, Manual Journal Entry Voucher. , KBA , SRD-FIN-GL , General Ledger , Problem