https://netsuiteprofessionals.com logo
#accounting
Title
# accounting
c

Chris

04/20/2022, 5:00 PM
Having a little issue with a report. We have a Balance sheet that shows subsidiaries and has the Amount and Amount (Foreign Amount). For a bank account under the subsidiary there is an amount under the "Foreign Amount", but $0 under the Amount (USD). When I click into the general ledger I don't see the amounts on the report listed there in either views (Consolidated or Subsidiary specific) No other subsidiaries bank account acts like this. I did it with another account and it both values that are in the balance sheet report are present in the general ledger when viewing consolidated or subsidiary specific.
k

Karina

04/20/2022, 10:10 PM
how big is the FX balance? is it possible someone just tried to clear the balance but did it in USD vs the bank acct currency?
✔️ 1
c

Chris

04/21/2022, 1:59 PM
It's about 4800 CAD
k

Karina

04/25/2022, 4:24 PM
see if there are any non CAD activities booked via journals
c

Chris

05/01/2022, 2:45 PM
So there were 2 GBP transactions under that account, but I was confused because it didn't seem to total out. What it was is that the Amount - Foreign Currency column just totals the columns regardless of currency and acts the same way a save search would. So the difference between CAD and GBP was the 4800. It's also why when I clicked into see details the $4800 would go away.
👍🏻 1
2 Views