sql-ledger-users

[SL] currency changeover

[Vitaly P. <vit...@gm...>]

Hello everyone,

I am using sql-ledger as a simple accounting system.
I was wondering whether there is a way how to change base currency and
change all past transactions to be in new currency (euro)?
For example, i used USD for transactions and now i need to change all
transaction to be in Euro.
Is there an automated way or built in function in sql-ledger?


Regards,
Vitaly

Re: [SL] currency changeover

[Bob G. <bo...@rc...>]

Do you want to leave all your original transactions in dollars and just
'view' them in euros?

Or do you want to multiply all of the past transactions by the currency
exchange factor?

If the later, do you want to use the currency exchange factor which
existed on the date of the transaction, or do you wish to just use one
currency exchange factor for all of the transactions?

It is not a simple thing..

On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> Hello everyone,
> 
> I am using sql-ledger as a simple accounting system.
> I was wondering whether there is a way how to change base currency and
> change all past transactions to be in new currency (euro)?
> For example, i used USD for transactions and now i need to change all
> transaction to be in Euro.
> Is there an automated way or built in function in sql-ledger?
> 
> 
> Regards,
> Vitaly
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] currency changeover

[Vitaly P. <vit...@gm...>]

Hi,
I would like to multiply all transactions by the same exchange factor.
It would be a nightmare to convert them using exchange rate at that
date.

Vitaly

On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> Do you want to leave all your original transactions in dollars and just
> 'view' them in euros?
>
> Or do you want to multiply all of the past transactions by the currency
> exchange factor?
>
> If the later, do you want to use the currency exchange factor which
> existed on the date of the transaction, or do you wish to just use one
> currency exchange factor for all of the transactions?
>
> It is not a simple thing..
>
> On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > Hello everyone,
> >
> > I am using sql-ledger as a simple accounting system.
> > I was wondering whether there is a way how to change base currency and
> > change all past transactions to be in new currency (euro)?
> > For example, i used USD for transactions and now i need to change all
> > transaction to be in Euro.
> > Is there an automated way or built in function in sql-ledger?
> >
> >
> > Regards,
> > Vitaly
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] currency changeover

[Bob G. <bo...@rc...>]

Not necessarily a nightmare: You have the dates of all the transactions,
and the exchange rates can be downloaded for each day (even after the
day - historically). In fact SL has support for a script that
automatically downloads new exchange rates every day.

It would also be nice to just 'view' past transactions in another
currency, but SL doesn't have that code. SL must add and subtract
'corrections' for each currency translation :-(

Bob G

On Mon, 2008-02-25 at 20:44 +0100, Vitaly Popovich wrote:
> Hi,
> I would like to multiply all transactions by the same exchange factor.
> It would be a nightmare to convert them using exchange rate at that
> date.
> 
> Vitaly
> 
> On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> > Do you want to leave all your original transactions in dollars and just
> > 'view' them in euros?
> >
> > Or do you want to multiply all of the past transactions by the currency
> > exchange factor?
> >
> > If the later, do you want to use the currency exchange factor which
> > existed on the date of the transaction, or do you wish to just use one
> > currency exchange factor for all of the transactions?
> >
> > It is not a simple thing..
> >
> > On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > > Hello everyone,
> > >
> > > I am using sql-ledger as a simple accounting system.
> > > I was wondering whether there is a way how to change base currency and
> > > change all past transactions to be in new currency (euro)?
> > > For example, i used USD for transactions and now i need to change all
> > > transaction to be in Euro.
> > > Is there an automated way or built in function in sql-ledger?
> > >
> > >
> > > Regards,
> > > Vitaly
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] currency changeover

[Vitaly P. <vit...@gm...>]

So do you think it is possible to convert all items into another
currency using some sort of automated tool?

Vitaly

On 2/26/08, Bob Gustafson <bo...@rc...> wrote:
> Not necessarily a nightmare: You have the dates of all the transactions,
> and the exchange rates can be downloaded for each day (even after the
> day - historically). In fact SL has support for a script that
> automatically downloads new exchange rates every day.
>
> It would also be nice to just 'view' past transactions in another
> currency, but SL doesn't have that code. SL must add and subtract
> 'corrections' for each currency translation :-(
>
> Bob G
>
> On Mon, 2008-02-25 at 20:44 +0100, Vitaly Popovich wrote:
> > Hi,
> > I would like to multiply all transactions by the same exchange factor.
> > It would be a nightmare to convert them using exchange rate at that
> > date.
> >
> > Vitaly
> >
> > On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> > > Do you want to leave all your original transactions in dollars and just
> > > 'view' them in euros?
> > >
> > > Or do you want to multiply all of the past transactions by the currency
> > > exchange factor?
> > >
> > > If the later, do you want to use the currency exchange factor which
> > > existed on the date of the transaction, or do you wish to just use one
> > > currency exchange factor for all of the transactions?
> > >
> > > It is not a simple thing..
> > >
> > > On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > > > Hello everyone,
> > > >
> > > > I am using sql-ledger as a simple accounting system.
> > > > I was wondering whether there is a way how to change base currency and
> > > > change all past transactions to be in new currency (euro)?
> > > > For example, i used USD for transactions and now i need to change all
> > > > transaction to be in Euro.
> > > > Is there an automated way or built in function in sql-ledger?
> > > >
> > > >
> > > > Regards,
> > > > Vitaly
> > > >
> > > > -------------------------------------------------------------------------
> > > > This SF.net email is sponsored by: Microsoft
> > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > _______________________________________________
> > > > sql-ledger-users mailing list
> > > > sql...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] currency changeover

[Bob G. <bo...@rc...>]

Of course. Software can do anything..

It just takes time and talent to create it.

Bob G

On Tue, 2008-02-26 at 18:38 +0100, Vitaly Popovich wrote:
> So do you think it is possible to convert all items into another
> currency using some sort of automated tool?
> 
> Vitaly
> 
> On 2/26/08, Bob Gustafson <bo...@rc...> wrote:
> > Not necessarily a nightmare: You have the dates of all the transactions,
> > and the exchange rates can be downloaded for each day (even after the
> > day - historically). In fact SL has support for a script that
> > automatically downloads new exchange rates every day.
> >
> > It would also be nice to just 'view' past transactions in another
> > currency, but SL doesn't have that code. SL must add and subtract
> > 'corrections' for each currency translation :-(
> >
> > Bob G
> >
> > On Mon, 2008-02-25 at 20:44 +0100, Vitaly Popovich wrote:
> > > Hi,
> > > I would like to multiply all transactions by the same exchange factor.
> > > It would be a nightmare to convert them using exchange rate at that
> > > date.
> > >
> > > Vitaly
> > >
> > > On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> > > > Do you want to leave all your original transactions in dollars and just
> > > > 'view' them in euros?
> > > >
> > > > Or do you want to multiply all of the past transactions by the currency
> > > > exchange factor?
> > > >
> > > > If the later, do you want to use the currency exchange factor which
> > > > existed on the date of the transaction, or do you wish to just use one
> > > > currency exchange factor for all of the transactions?
> > > >
> > > > It is not a simple thing..
> > > >
> > > > On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > > > > Hello everyone,
> > > > >
> > > > > I am using sql-ledger as a simple accounting system.
> > > > > I was wondering whether there is a way how to change base currency and
> > > > > change all past transactions to be in new currency (euro)?
> > > > > For example, i used USD for transactions and now i need to change all
> > > > > transaction to be in Euro.
> > > > > Is there an automated way or built in function in sql-ledger?
> > > > >
> > > > >
> > > > > Regards,
> > > > > Vitaly
> > > > >
> > > > > -------------------------------------------------------------------------
> > > > > This SF.net email is sponsored by: Microsoft
> > > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > > _______________________________________________
> > > > > sql-ledger-users mailing list
> > > > > sql...@li...
> > > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > >
> > > > -------------------------------------------------------------------------
> > > > This SF.net email is sponsored by: Microsoft
> > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > _______________________________________________
> > > > sql-ledger-users mailing list
> > > > sql...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > >
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users