We are using Bank Recs version 8.1D. We are multicurrency, and love that we can print reports in both source and home, in Accounts Payables, Accounts Receivables, Ledger.

Possible to print reports in BR in Home and Source?

Barb

Hi, Barb,

As long as this is set in the Company Profile for the data, yes. A number of the reports (eg. batch listings, posting journals, transactions) have an option on the print window to print/show Home equivalent amounts. When enabled, the report will show both source and home amounts.

Under company profile, if we go to the tab "Report Option" there is nothing we can see to change to enable us to get reports in Home and Source.

Please advise.

Hi, Barb,

What I was referring to in the Company Profile was the 'Use multicurrency?' setting on the Profile tab. If it's enabled in the data being used, then it is a MultiCurrency dataset and many report print windows (eg. Print Batch Listing window) will have a 'Print home equivalent amounts' option. (Some reports use a 'Show home equivalent amounts' option, slightly different wording is all.) When the 'Print home equivalent amounts' option on the print window is enabled, the report will show both source and home amounts.

The option on the report print window isn't available on single currency Bank Rec data.

Trust this is a little clearer.

Yes, that is clearer, but I may have not clarified to you what I am hoping to achieve. Let me try again!

We have 2 reports that we compare. One is Ledger (9.0D). Report is called Detail Listing, and we tick "source" and "home". Report shows each transaction, with a total for source and home at the bottom.

The other report is from Bank Recs (8.1D). It is called Bank Reconciliation, and it too has "source" and "home" amounts listed, but only the totals are shown, not each transaction.

Each month, the "source" amounts are the same on these 2 reports. The "home" amounts are not. On the Ledger report, I am shown each transaction, both "source" and "home" so I can see why and how the totals are arrived at. Because I cannot see each transaction on the BR report, I have no idea why the home amounts are always different.

The differences are substantial, and grow each month. For instance, at the end of November, our source amounts match, but our home amount is already out by 12,032.48, and that is just for 2 months out of our fiscal year.

Are you considering making the "home" currency available to view, same as I can view the Ledger report? At least that way I'd have some idea of what the differences are, and why.

Barb

Hi, Barb,

Thanks for the added information here.

I think the key word in BankRec is 'balance'. The option is to 'Show home equiv. balance', hence the source and home amounts printing for each account balance in the Cash Balances Summary portion of the report. Similarly, for bank account, the source and home balance is shown. You're correct that they do not print for each transaction.

The Ledger report prints for the particular bank account transactions that were posted for the periods being reported on.

The BankRec report prints for the particular bank account transactions that were reconciled, without any transactions necessarily being sent to Ledger as a result of the reconciliation, as at a particular date.

I'll enter your suggestion to R&D that, if possible, we include both Home and Source currency amounts for each entry on the Bank Reconciliation report.