Page 1 of 1

Customer's currency changed

Posted: 23 Sep 2009, 03:46
by rhyven
Hi,

One of our customers set up in Line 50 (v10) has suddenly changed from NZD (Currency #19) to Pounds Sterling (Currency #1) after being OK for over a year. There was one invoice/payment raised under the incorrect currency. It seems impossible to change it back to the desired NZD currency (the selection box is greyed out). Is there any way that I can do this, or is it only possible via data repair?

Cheers,
- Eric

Re: Customer's currency changed

Posted: 23 Sep 2009, 13:35
by brucedenney
The currency is associated with the account.

You need to create a new account for the new currency.

Any invoices raised in the old currency that will be paid in the new currency need to be credited in the old currency to the old account and matched off. New invoices in the new currency need to be raised to complete the process

Re: Customer's currency changed

Posted: 24 Sep 2009, 02:17
by rhyven
Hi Bruce,

Sorry I didn't explain that very well. There is no new currency desired - the customer was set up years ago with the correct currency (NZD), and transactions etc were made quite happily until some weeks ago the customer in question was set to Pounds Sterling and as such we weren't able to reciept their payments of NZD into our NZD bank account, becuase Sage thinks they're depositing Pounds.

One other development from what I'd said in the opening post - the currency setting has spontaneously changed for two of the customers in the Line50 database (at least). We don't know how that is going to affect all the previous transactions made or the financial side of things, but it's causing some serious trouble for reciepting payments.

Does that make things clearer?

Cheers!
- Eric

Re: Customer's currency changed

Posted: 24 Sep 2009, 12:14
by brucedenney
If the currency has changed then it is probably caused by something like importing customer details, there is a warning about this in earlier versions. In later versions you can import a currency flag.

I have some tools that can fix this and put the flag back to the right currency. But would need your data and would have to charge, assuming it is not a hundred thousand transactions you are looking at about an hour to do it so about £50

Re: Customer's currency changed

Posted: 26 Sep 2009, 04:52
by rhyven
Thanks again Bruce. There wouldn't be many transactions - I think it's a dozen at most. Only the latest has been entered in as the wrong currency I believe but I'm not completely sure. Will check with my client re the service, thanks.

We've been having a host of strange issues with Line 50 and Job Costing for months now... Issues have included database corruption, lockouts, missing jobs, etc... This is just one more. We haven't done any importing etc. Do you have any tools that will scan for strange irregularities and errors in the databases? Most of the issues we've had are able to be resolved with a simple "Compact and Repair" in MS Access but it leaves me feeling distinctly uneasy. Particularly when Sage Support advises my client to open the JC database via the ODBC control panel and repair the database. Just this week they managed to destroy the database completely and irrecoverably with that tool (had made a backup a mere two hours prior, thank god!).

Re: Customer's currency changed

Posted: 28 Sep 2009, 16:41
by brucedenney
I think it might be worth looking at the Project costing module and seeing if it could be used in place of Job costing.