slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Multi-Currency

Jerry Foster
Posts: 2

Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jan 08 1:18 PM

Hey guys,

In the SLX Administrator, I'm wondering where the "Enable Multi-Currency" boolean data is stored in the database.

Open up SLX Administrator >> Manage >> Currency. Multi-Currency is located in the 'Options' section.

Thank you,

Jerry

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Jan 08 3:28 PM

Even if you know.. it's not that simple.. once a db has been changed to MC.. that's it... no supported way to go back. .. or change the "base".

It's NOT a boolean.. it's what the value is in SYSTEMINFO.BASECURRENCY (or not)
--
RJLedger - rjlSystems

[Reply][Quote]

Rick Smith
Posts: 96

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Jan 08 10:53 AM

I have yet to find anyone who has successfully used MultiCurrency in a way that their organization has found to be useful, and still maintain that it was implemented by Sage in a backwards manner.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Jan 08 3:16 PM

There are certainly some holes in it.. MC is just a nasty thing to deal with.. period...
--
RJLedger - rjlSystems

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Jan 08 4:16 PM

Quote:

Originally posted by Rick Smith

... and still maintain that it was implemented by Sage in a backwards manner.

Hi Rick - I've not used MC much before and would be interested to hear in a little more detail what you mean.

Cheers
Phil

[Reply][Quote]

Jerry Foster
Posts: 2

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Jan 08 11:34 AM

Hmm, that's not very comforting. hehe.

Here's what I am trying to do:

I am working on a third party plugin that allows the user to select what currency they'd like to use. I'd like that data to default to the currency that is stored for the current user in the USEROPTIONS table...which I've done, but I'd like to add logic that would hide the currency selection combo box if 'enable multi-currency' has never been checked.

Can I just say if Systeminfo.basecurrency <> null? Would that work the same as I am trying to do?

Thank you,
Jerry

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Multi-Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Jan 08 7:34 AM

Quote:

Originally posted by Jerry Foster

Hmm, that's not very comforting. hehe.
......
Can I just say if Systeminfo.basecurrency <> null? Would that work the same as I am trying to do?

Thank you,
Jerry

Probably.... otherwise you have to look at (Slx internal) Global variables...
--
RJLedger - rjlSystems

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 4:37:16 PM