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.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Banking details on statement.
-
- User
- Posts: 12
- Joined: 12 Jul 2016, 15:59
- Sage Version: v2016 22 UK/Europe/Africa
- brucedenney
- Site Admin
- Posts: 4628
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Banking details on statement.
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.
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 :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 12
- Joined: 12 Jul 2016, 15:59
- Sage Version: v2016 22 UK/Europe/Africa
Re: Banking details on statement.
Hi Bruce,
Massive thanks for that. Works perfectly.
Have a great day.
Best Regards,
Ian.
Massive thanks for that. Works perfectly.
Have a great day.
Best Regards,
Ian.
Who is online
Users browsing this forum: No registered users and 3 guests