Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Banking details on statement.

Report design issues and solutions.
Post Reply
ian332isport
User
User
Posts: 6
Joined: 12 Jul 2016, 15:59
Sage Version: v2016 22 UK/Europe/Africa

Banking details on statement.

Post by ian332isport » 17 Aug 2020, 13:36

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.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4331
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Banking details on statement.

Post by brucedenney » 17 Aug 2020, 14:03

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.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

ian332isport
User
User
Posts: 6
Joined: 12 Jul 2016, 15:59
Sage Version: v2016 22 UK/Europe/Africa

Re: Banking details on statement.

Post by ian332isport » 17 Aug 2020, 14:43

Hi Bruce,

Massive thanks for that. Works perfectly.

Have a great day.

Best Regards,
Ian.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest