SageForum for UK versions of Sage 50- Help and support.

Hi,

I'm running Sage 50 accounts UK V26 with Foreign Trader enabled.

I would like to be able to display bank account and IBAN numbers on our statements, but based on the currency of the statement.

E.g.

Customer billed in GB pounds would only see our GBP bank account details on the statement.
Customer billed in US dollars would only see our USD bank account details on the statement.
Customer billed in Euros would only see our Euro bank account details on the statement.

By default, I don't see any company bank account records available in the Report Designer. I can see customer specific bank details under SALES_LEDGER, but nothing relating to our company bank accounts.

Does anyone know if it's possible to pull this information into the report?

Thanks,
Ian.

What you do is to make 3 text boxes, one for each currency and each with the details for that currency.

You then set the "SuppressPrint" property to True

Then in Conditional Formatting you say if the Curerency is USD then set SupressPrint to True

Stack all three boxes on top of each other only one will print and it will always be the right one for that currency.

Hi Bruce,

Massive thanks for that. Works perfectly.

Have a great day.

Best Regards,
Ian.