Hi Mr_Mayor I have seen this problem too.  I investigated it further and found that the system appears (I don't know for sure, Sage Support will have to confirm) that regardless of what you attempt to submit in the Statement Currency field, the system is forcing the Functional Currency (in my case CAD instead of USD from the Excel sheet).  In the below example in Sage 300 2025 PU2, its option to overwrite the field with another currency is greyed out, forcing the existing functional currency value.  RVSPY confirms just before the error that its trying to insert the value in the Excel document - in this case USD.  I suspect this will need to go to Sage support and be submitted as a case for rectification.  If you're submitting a case already I'll leave it with you, if not, let me know and I'll submit a case with my findings.  All the best.

Hi All,

This was reported to Development.  It was determined to be a minor defect as there is nothing preventing the user from creating the Bank Code via the UI. 

Import\Export process is really for volumes of transactions/records.. Most companies don't have hundreds and hundreds of individual Bank Codes requiring the necessity to use Import/Export  and thus it was determined to be a minor defect. 

Regards,

DCrampton

the first part is understandable

the second part doesn't resonate well. even AP's payment codes or AR's Interest Profile can have 1 file but the import export still exists and works well

i have a client with 42 banks hence asking. 

is that the Sage position  that it wasn't necessary? 

you can import record. it just seems unnecessary to use the import function to add one record.. as for your client with 42 Bank Codes .. did they import all 42 Bank Codes at once or did they add them as they went along?

all banks are needed, it's a segmented company, and users have different banks for each segment

punching in all 42 seemed terrible. 

this option has always been working before

thanks to Cashbook, once you have all banks in, they are a functionality to auto load all banks. pretty cool

all banks are needed, it's a segmented company, and users have different banks for each segment

punching in all 42 seemed terrible. 

this option has always been working before

thanks to Cashbook, once you have all banks in, they are a functionality to auto load all banks. pretty cool

I still don't quite understand.. the 42 Banks are already added into Sage, correct?  the issue with this particular error is with importing a new bank code with currency option.. so they are importing 42 Bank Codes at a time?  

in my situation. Central Bank introduced a new currency as functional currency. 

you have to create a new database. Export and import setups 

everything else I can export and import expect this bank function. Now I have to do those 42 banks manually. Creating them 1 by 1