sql-ledger-users — SQL-Ledger users

[SL] How to renumber all customers, then "start" the numbering?

[Andrew @ A. L. <atm...@km...>]

We have a client using SQL Ledger (we use it as well) however for some
reason as they have been entering customers ever single customer is number 1
(They have a little over 1000 of them entered, and are only on the letter
'M' so far...
 
I am hoping I am going to be able to find a way to renumber all of them,
(was hoping maybe an import / export would have worked) then sort out what
was wrong and get it fixed)
 
They started with version 2.8 I think, and I just upgraded them to 2.8.11
 
Any help would be great, thanks

[SL] Test to sql-ledger-users@lists.sourceforge.net

[Andrew @ A. L. <atm...@km...>]

Test only, no reply.

Re: [SL] Summary of Daily Sales, New Inventory and Remaining Inventory per Product

[Jerome J. A. <jer...@bo...>]

Michael, thanks for this.  This is not exactly what I needed but will do 
for what I need to do now.  Will also wait for ideas from other folks.

jerome

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Michael Hasse wrote:

>Can probably do this through AR -> Transactions and adjust the report  
>filtering as appropriate...?
>
>
>Thanks,
>
>Michael
>
>
>On Jan 14, 2008, at 1:45 AM, Jerome J. Auza wrote:
>
>  
>
>>Hi,  I have been looking for this feature in the SQL-Ledger interface
>>but couldn't find it:  I need to get the summary of daily sales, new
>>inventory and remaining inventory per product for a retail store.  Is
>>this option available at all?  If not, does anybody know how to get
>>something similar?  Looking at the Goods and Services, I can only get
>>the remaining inventory, but not the quantity in and out for the day.
>>
>>-- 
>>http://www.techsier.com - Blog
>>http://www.boholweb.com - Bohol tourism website
>>http://www.auza.net - enabling e-services in Bohol
>>
>>
>>---------------------------------------------------------------------- 
>>---
>>Check out the new SourceForge.net Marketplace.
>>It's the best place to buy or sell services for
>>just about anything Open Source.
>>http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
>>marketplace
>>_______________________________________________
>>sql-ledger-users mailing list
>>sql...@li...
>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>    
>>
>
>
>-------------------------------------------------------------------------
>Check out the new SourceForge.net Marketplace.
>It's the best place to buy or sell services for
>just about anything Open Source.
>http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>  
>

Re: [SL] Summary of Daily Sales, New Inventory and Remaining Inventory per Product

[Michael H. <mh...@it...>]

Can probably do this through AR -> Transactions and adjust the report  
filtering as appropriate...?


Thanks,

Michael


On Jan 14, 2008, at 1:45 AM, Jerome J. Auza wrote:

> Hi,  I have been looking for this feature in the SQL-Ledger interface
> but couldn't find it:  I need to get the summary of daily sales, new
> inventory and remaining inventory per product for a retail store.  Is
> this option available at all?  If not, does anybody know how to get
> something similar?  Looking at the Goods and Services, I can only get
> the remaining inventory, but not the quantity in and out for the day.
>
> -- 
> http://www.techsier.com - Blog
> http://www.boholweb.com - Bohol tourism website
> http://www.auza.net - enabling e-services in Bohol
>
>
> ---------------------------------------------------------------------- 
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Summary of Daily Sales, New Inventory and Remaining Inventory per Product

[Jerome J. A. <jer...@bo...>]

Hi,  I have been looking for this feature in the SQL-Ledger interface 
but couldn't find it:  I need to get the summary of daily sales, new 
inventory and remaining inventory per product for a retail store.  Is 
this option available at all?  If not, does anybody know how to get 
something similar?  Looking at the Goods and Services, I can only get 
the remaining inventory, but not the quantity in and out for the day.

-- 
http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

Luke wrote:
> When I am logged into admin.pl, and I attempt to add or delete a user, 
> the http connection hangs until it times out (several minutes), and I 
> am presented with a 500 internal server error.
>
> The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 
> and 8.1.
>   
Are other things working fine? Can you login and run the application 
using previously created users etc.
> I recently upgraded from 2.6.8, by doing a progressive upgrade through 
> the intermediary versions.
>
> While doing this, I ran into an error about a missing function which 
> the upgrade script was trying to drop.  Several of them actually, as I 
> removed one from the SQL file, another would come up.  Same for some 
> other attempts to drop triggers, a problem which the lock/unlock 
> solution wouldn't solve.  The upgrade was seemingly successful after I 
> removed the things that had already been dropped.
>
> I don't know if this is some how causing my problem now, but any 
> advice would be appreciated.
This missing procedures error can be some upgrade bug and can be ignored 
in my experience. The latest sql-ledger version does not install/use 
server side procedures (like procedures and triggers). Everything is now 
handled through the application. (so you dont need plpgsql in the 
database now).

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Running SQL-Ledger in Argentina

[Fefu <fe...@fe...>]

On Jan 10, 2008 10:46 AM, Dirk Enrique Seiffert <ds...@ca...> wrote:
> On spanish language installs I would recommend utf8 encoding. The dataset
> you will have to create on your own: You can load any dataset and edit it [...]

Thank you very much for your answer, Enrique !

>  [...] you might submit your results to Dieter Simader
> afterwards to be inluded in future releases.

Is there some how-to document I may use to submit those results to
Dieter Simader ?

Thank you again for your suggestions. Have a nice weekend.

[SL] Two small but useful patches for 2.8.11

[Armaghan S. <sa...@le...>]

Hi all,

I have made two small patches which might be useful to you.

Patch 1 allows you to display account activity (debit,credit,balance)
directly from GL Transactions report.

Patch 2 allows you to maintain inventory balances at warehouses from
sale and purchase invoices.

Download from http://www.ledger123.com/

Regards

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/


--

[SL] What's the best way of running UK quarterly VAT reports?

[Andrew C. <an...@ev...>]

Hi,

Does anyone have an efficient method of running their quarterly VAT reports?

And how does one put through the payment to HM Revenue & Customs? What 
purchases account do you use?

Cheers
Andrew Cope
--
DIRECTOR
Evergreen Computing Ltd

Websites, Web Databases, and E-Commerce Solutions

E : an...@ev...
W : http://evergreencomputing.com
T : +44 (0)1454 269 087
F : +44 (0)8707 515 596
A : 42 Woodlands Road, Charfield, GL12 8LS
C : Registered in England, 3747553.
Skype: evergreencomputing.com

Re: [SL] Thinking of upgrading

[Armaghan S. <sa...@le...>]

Jeff Roberts wrote:
> Hi All
>
> First of all my system is working and stable so I probably shouldn't 
> mess with it but I feel I may be missing out on features if I don't upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities available so 
> I end up printing pdfs to screen, saving them and then emailing them as 
> attachments.
>   
FreeBSD is perhaps the easiest *nix to configure for anything (thanks to 
ports collection) when compared to CentOS or OpenSolaris (the other two 
I use). On a new server, I go to "/usr/ports/mail/postfix" and run "make 
install". Once finished, I make few changes to "/etc/rc.conf" as 
presented by post-install message and mail server is done.

Run "tail /var/log/maillog"  and "mailq" commands and let me know what 
is there so I could help you rectify this issue.

> Is it worth the aggravation to upgrade it all? I'm assuming I can't 
> upgrade SQL-Ledger all the way without also upgrading PSQL and Apache so 
> it's looking like a big job with possible failures and catastrophies 
> along the way.
>
> Are those of you that are working with the latest version of SQL-Ledger 
> happy with the added functions and features? If you were me would you 
> spend the time upgrading to get those features?
>
> Jeff
>   
I don't thing you need to upgrade postgres. Apache should be fine too 
because sql-ledger is a cgi application and does not use any web server 
functionality.

 From README.

 REQUIREMENTS:
 -------------
 1 - Perl, 5+
 2 - http server (Apache, NCSA, httpi, thttpd, ...)
 3 - SQL Server (PostgreSQL 7.1+)
 4 - DBD (DBD-Pg)
 5 - DBI
 6 - LaTeX (optional)


And you can always test your upgrade by installing latest version in a 
different folder with the copy of database and your "user" and 
"templates" folder.

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Running SQL-Ledger in Argentina

[Dirk E. S. <ds...@ca...>]

> I will try to do so, but meanwhile, I would like to know which **
> Multibyte Encoding and Chart of accounts ** should I choose for the
> Dataset for an Argentine business.
>
> Thank you for your answer. I hope someone else can also help.

On spanish language installs I would recommend utf8 encoding. The dataset
you will have to create on your own: You can load any dataset and edit it
from the web interface, according to Argentinian regulations. This is some
hours of work, but you might submit your results to Dieter Simader
afterwards to be inluded in future releases.

Best wishes

Enrique

-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

On Thu, 10 Jan 2008, Armaghan Saqib wrote:

> Luke wrote:
> > When I am logged into admin.pl, and I attempt to add or delete a user, the 
> > http connection hangs until it times out (several minutes), and I am 
> > presented with a 500 internal server error.
> >
> > The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 and 
> > 8.1.
> >   
> Are other things working fine? Can you login and run the application 
> using previously created users etc.

Yes.

Luke

Re: [SL] Thinking of upgrading

[Armaghan S. <sa...@le...>]

Jeff Roberts wrote:
> Hi All
>
> First of all my system is working and stable so I probably shouldn't 
> mess with it but I feel I may be missing out on features if I don't 
> upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities available 
> so I end up printing pdfs to screen, saving them and then emailing 
> them as attachments.
>   
FreeBSD is perhaps the easiest *nix to configure for anything (thanks to 
ports collection) when compared to CentOS or OpenSolaris (the other two 
I use). On a new server, I go to "/usr/ports/mail/postfix" and run "make 
install". Once finished, I make few changes to "/etc/rc.conf" as 
presented by post-install message and mail server is done.

Run "tail /var/log/maillog"  and "mailq" commands and let me know what 
is there so I could help you rectify this issue.

> Is it worth the aggravation to upgrade it all? I'm assuming I can't 
> upgrade SQL-Ledger all the way without also upgrading PSQL and Apache 
> so it's looking like a big job with possible failures and 
> catastrophies along the way.
>
> Are those of you that are working with the latest version of 
> SQL-Ledger happy with the added functions and features? If you were me 
> would you spend the time upgrading to get those features?
>
> Jeff
>   
I don't thing you need to upgrade postgres. Apache should be fine too 
because sql-ledger is a cgi application and does not use any web server 
functionality.

 From README.

REQUIREMENTS:
-------------
1 - Perl, 5+
2 - http server (Apache, NCSA, httpi, thttpd, ...)
3 - SQL Server (PostgreSQL 7.1+)
4 - DBD (DBD-Pg)
5 - DBI
6 - LaTeX (optional)


And you can always test your upgrade by installing latest version in a 
different folder with the copy of database and your "user" and 
"templates" folder.

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

Luke wrote:
> When I am logged into admin.pl, and I attempt to add or delete a user, the 
> http connection hangs until it times out (several minutes), and I am 
> presented with a 500 internal server error.
>
> The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 and 
> 8.1.
>   
Are other things working fine? Can you login and run the application 
using previously created users etc.
> I recently upgraded from 2.6.8, by doing a progressive upgrade through the 
> intermediary versions.
>
> While doing this, I ran into an error about a missing function which the 
> upgrade script was trying to drop.  Several of them actually, as I removed 
> one from the SQL file, another would come up.  Same for some other 
> attempts to drop triggers, a problem which the lock/unlock solution 
> wouldn't solve.  The upgrade was seemingly successful after I 
> removed the things that had already been dropped.
>
> I don't know if this is some how causing my problem now, but any advice 
> would be appreciated.
This missing procedures error can be some upgrade bug and can be ignored 
in my experience. The latest sql-ledger version does not install/use 
server side procedures (like procedures and triggers). Everything is now 
handled through the application. (so you dont need plpgsql in the 
database now).

Regards

--
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Thinking of upgrading

[Michael H. <mh...@it...>]

We stayed on 2.6.22 for a long time and only just recently upgraded  
for something feature or the other, (I forget what exactly!).  I.e.,  
unless you need a feature or bugfix in a newer version there's really  
no case for upgrading.
    As for the email, that's completely unrelated to the upgrade.   
However your email is now is how it will be after the upgrade.
    If you do not have email functionality currently you could  
probably post the symptoms/errors/etc here and somebody would be  
happy to chime in and help get you going in the right direction.


Thanks,

Michael


On Jan 9, 2008, at 7:07 PM, Jeff Roberts wrote:

> Hi All
>
> First of all my system is working and stable so I probably shouldn't
> mess with it but I feel I may be missing out on features if I don't  
> upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities  
> available so
> I end up printing pdfs to screen, saving them and then emailing  
> them as
> attachments.
>
> Is it worth the aggravation to upgrade it all? I'm assuming I can't
> upgrade SQL-Ledger all the way without also upgrading PSQL and  
> Apache so
> it's looking like a big job with possible failures and catastrophies
> along the way.
>
> Are those of you that are working with the latest version of SQL- 
> Ledger
> happy with the added functions and features? If you were me would you
> spend the time upgrading to get those features?
>
> Jeff
>
>
> ---------------------------------------------------------------------- 
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Thinking of upgrading

[Jeff R. <je...@jr...>]

Hi All

First of all my system is working and stable so I probably shouldn't 
mess with it but I feel I may be missing out on features if I don't upgrade.

I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
I then have SQL-Ledger 2.6.22 running with it.

It's working OK with CUPS but I have no email capabilities available so 
I end up printing pdfs to screen, saving them and then emailing them as 
attachments.

Is it worth the aggravation to upgrade it all? I'm assuming I can't 
upgrade SQL-Ledger all the way without also upgrading PSQL and Apache so 
it's looking like a big job with possible failures and catastrophies 
along the way.

Are those of you that are working with the latest version of SQL-Ledger 
happy with the added functions and features? If you were me would you 
spend the time upgrading to get those features?

Jeff

Re: [SL] Running SQL-Ledger in Argentina

[Fefu <fe...@fe...>]

Michael Hasse <mh...@it...> wrote:
> I realize this has nothing to do with the question below, but why not
> use a more recent version of SL...?

Thank you very much for your suggestion, Michael !

I was using that version because of the automatic security-updates I
receive from Debian package system.

I will try to do so, but meanwhile, I would like to know which **
Multibyte Encoding and Chart of accounts ** should I choose for the
Dataset for an Argentine business.

Thank you for your answer. I hope someone else can also help.

--
Federico Ponce de Le=F3n
http://www.fefu.com.ar

Re: [SL] Switching to sql-ledger for real, finally

[Dirk E. S. <ds...@ca...>]

> Basically, I'd like most or all account balances to be zeroed out. But
> I'd still like to be able to look back at old quotes and invoices. And
> there are some quotes and invoices which are actually open, too.

If you want to use the historical information like invoices etc. you could
do the following:

1) Call a trial balance as of 31 of dec.
2) Ad a GL transaction, exactly as the above trial balance but with
NEGATIVE values.
3) Check your balance as of 31 of dec. Should be all in cero!
4) Call a trial balance from your old accounting system, transcribe it as
a GL transaction.

Now your balances in both accounting systems should be excatly the same.
Open invoices should show up in your statements. If everything looks fine
you should use the year end function and close last year.

Hope it helps

Enrique


-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Switching to sql-ledger for real, finally

[Paul T. <pt...@wa...>]

A little more on the same issue:

Usual bookkeeping programs totally empty out all profit and loss acoounts
and move the result to a balance sheet account, normally Result Bookyear or
something similar. Then you start next year with a clean set of accounts for
profit and loss part.

SQL-ledger makes a year-end booking, say dec 31 2007, with the same effect,
but leaves all entries where tehy are.

So if you run a P&L report from jan 1 till dec 30 of any year you see the
amounts of all entries for the year.
If you do the same for jan 1 till dec 31 (after a year end J/E) you see all
zero.
Nice for comparison between say jan -dec 30 year minus one and current year
to begin with ;-)


2008/1/8, Rich Shepard <rsh...@ap...>:
>
> On Tue, 8 Jan 2008, Ben Dugan wrote:
>
> > Thanks. I have tried this in a 'sandbox' copy of our accounts, and now
> I'm
> > trying to understand what it did. These things take time for me to
> > understand, but I wanted to say thanks right away.
>
> Ben,
>
>   The year end function creates a G/L transaction offsetting income and
> expense accounts to zero. It also does not remove transactions or close a
> period; you may run the year end anytime. The Journal entry is the same as
> other G/L entries, but the transaction will be on income statements.
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.
> |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] Switching to sql-ledger for real, finally

[Rich S. <rsh...@ap...>]

On Tue, 8 Jan 2008, Ben Dugan wrote:

> Thanks. I have tried this in a 'sandbox' copy of our accounts, and now I'm
> trying to understand what it did. These things take time for me to
> understand, but I wanted to say thanks right away.

Ben,

  The year end function creates a G/L transaction offsetting income and
expense accounts to zero. It also does not remove transactions or close a
period; you may run the year end anytime. The Journal entry is the same as
other G/L entries, but the transaction will be on income statements.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Switching to sql-ledger for real, finally

[Ben D. <bd...@cu...>]

Rich Shepard wrote:
> On Tue, 8 Jan 2008, Ben Dugan wrote:
> 
>> Can anyone recommend the best way for me, in this imperfect
>> situation, to begin 2008 accounts in the optimum way?
> 
> Log in, select the System menu, then the Yearend option.

Thanks. I have tried this in a 'sandbox' copy of our accounts, and now
I'm trying to understand what it did. These things take time for me to
understand, but I wanted to say thanks right away.

Ben

Re: [SL] Switching to sql-ledger for real, finally

[Rich S. <rsh...@ap...>]

On Tue, 8 Jan 2008, Ben Dugan wrote:

> Can anyone recommend the best way for me, in this imperfect situation,
> to begin 2008 accounts in the optimum way?

   Log in, select the System menu, then the Yearend option.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Apache error running summary reports

[William M. <wi...@kn...>]

On Mon, Jan 07, 2008 at 09:34:39PM -0800, Michael Hasse wrote:
> Just an update on this.  Permissions are all fine and the reports run  
> with no problems in our test company.  Reading up a bit on the errors  
> it looks like a simple timeout problem where Apache is giving up on  
> the script before it finishes due to the amount of data we have  
> slowing the script down.  (System resources are okay so we're not  
> running out of memory or anything).

Interesting, I hadn't considered timeout error causing that message.


>     Suggestions/advice are welcome and we'll keep plugging away at it  
> and post back if we figure it out.

Have you checked out the TimeOut directive[1]? I've seen some people
comment the TimeOut does not affect CGI scripts, but Apache security
tips[2] say the following:

 "As TimeOut is currently used for several different operations, setting
 it to a low value introduces problems with long running CGI scripts."

I've seen others suggest using FastCGI. Keep us posted on your progress.


Good luck,
William

[1] http://httpd.apache.org/docs/2.0/mod/core.html#timeout
[2] http://httpd.apache.org/docs/trunk/misc/security_tips.html#dos

-- 
Knowmad Technologies - Web Site Development & Programming
W: http://www.knowmad.com | E: wi...@kn...
P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee

[SL] Switching to sql-ledger for real, finally

[Ben D. <bd...@cu...>]

We've been using sql-ledger in a limited way for several years.
Basically, we have used it to generate quotations, purchase orders,
shipping documents, and, finally, invoices. But, strange as this
probably sounds, we have not used it for actual accounting. (We have
been using a 'legacy' (!) Mac running MYOB for that.)

I want to begin immediately to use sql-ledger properly for the whole
accounting work flow for 2008 (i.e., as of 8 days ago).

We have a lot of data in sql-ledger that is valuable to us at this
point. Mostly, its the contact information. But the invoices we have
generated over the last few years show us what customers have bought,
when they bought, etc.

Can anyone recommend the best way for me, in this imperfect situation,
to begin 2008 accounts in the optimum way?

Basically, I'd like most or all account balances to be zeroed out. But
I'd still like to be able to look back at old quotes and invoices. And
there are some quotes and invoices which are actually open, too.

I'm sorry this question is rather open-ended. I have bills that I would
like to pay next week using sql-ledger, so I am trying to get things
reasonably set up before that.

Thanks in advance.

Ben

Re: [SL] Running SQL-Ledger in Argentina

[Michael H. <mh...@it...>]

I realize this has nothing to do with the question below, but why not  
use a more recent version of SL...?


Thanks,

Michael


On Jan 7, 2008, at 11:19 PM, Federico Ponce de Leon wrote:

> Good morning !  I'm glad to subscribe to this list and find so many
> professionals in it. I'm delighted to meet you all.
>
> I've recently installed SQL-Ledger 2.6.22 in a Debian 4.0 (etch). I
> was able to start playing with the "SQL-Ledger Accounting
> Administration" and successfully creating some testing Datasets.
>
> They all seem to work fine, but I'm asking myself  *** which would be
> the best combination between "Multibyte Encoding" and "Chart of
> Accounts" to be used in Argentina? *** (Spanish-spoken Country).
>
> Multibyte Encoding I would choose:
>  * ISO-8859-15 (Latin alphabet no.9)
>  * Unicode (UTF-8)
>
> Chart of accounts I would use:
>  * Colombia-PUC
>  * Colombia-utf8-PUC
>  * Spain-ISO
>  * Spain-UTF8
>  * Paraguay
>  * Venezuela_Default
>
> I appreciate you suggestions, hoping they may result useful for other
> users in this same initial stage.
>
> Thank you very much for your time. Have a nice week.
>
> ---------------------------------------------------------------------- 
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users