Trial balance Currency Rate SAP B1

[wojciech_wozniak]

Hello everyone.

I have a question, do you know at what rate the SC to LC amounts are converted in the Trial Balance report.

I thought that these are calculations from the account balance but not ...

[JesperB1 · Accepted solution]

Hello Wojciech,

The balance is indeed the sum of the transactions on the account for the period specified. However, there are various report criteria that can mix things up a bit.

If the period has gone through a period end there will be transaction that will only included if the options Opening or Closing Balances are included.

The query below can easily be adjusted for the dates and account you want to check. And I strongly advise analysing individual accounts to start with. In the query Opening and Closing Balances are not included (transtype -2 and -3).

select sum(debit)-sum(credit), sum(sysdeb)-sum(syscred)
from jdt1
where account = '11210000'
and refdate between '20120101' and '20120125'
and transtype not in (-2, -3)

I hope that helps,

Jesper