Detail Trial balance report

Business Central/NAV User Forum
1

Hello,

Does anyone know how to display foreign currency on the detail trial balance report?

Thanks,

T

2

Hi,

Which detailed trial balance report are you referring to?

G/L is based on G/L entry table which is in LCY only - with the additional reporting currency figures.

possible on Customer detailed trial balance.

3

I want the forreign currencies displayed for my foreign bank account. I know there is a bank detail trial balance report which shows the foreign currencies as well as LCY. However the report doesn’t give me the opening balance for the date range entered. Is there a way to show that figure on the bank detail trial balance?

4

Hi,

The reason this doesn’t give an opening balance is that the transactions may not be posted in sequence (e.g. bank charges) - you could lookup the Bank Statement table if you are doing bank reconciliations.

5

We have not done any bank reconciliations. There is no other solution?

6

Hi,

You can calulate off the bank ledger entries but cannot guarantee that it is accurate.

7

why were the transactions not posted in sequence?

8

Hi,

I stated that the transactions may not be posted in sequence. The issue you have is that transactions like bank charges may not be picked up until the end of a month. Also you need to be careful when publishing bank balances and cheques may not be cash etc and if the customer read the report and checks a bank statement they may not agree.

9

I don’t understand. What is the solution? What should I do?

Please help.