sql-ledger-users — SQL-Ledger users

[SL] Anyone using SL for Brokering business in Oz?

[Phil R. <ph...@pr...>]

People,

Is anyone using SL for Brokering business in Oz or know of someone using
it for this sort of business? - specifically I am thinking of a Strata
Title insurance operation.

Thanks,

Phil.
-- 
Philip Rhoades

Pricom Pty Limited  (ACN 003 252 275  ABN 91 003 252 275)
GPO Box 3411
Sydney NSW      2001
Australia
Mobile:  +61:(0)411-185-652
Fax:     +61:(0)2-8221-9599
E-mail:  ph...@pr...

Re: [SL] Server error when adding new item (add part)

[Gloria A. <got...@gm...>]

Just in case anyone else encountered this problem, we've traced the
cause of the problem to apache's mod_security.

Adding the following lines to mod_security.conf fixed the problem.

<Location /sql-ledger/>
     SecFilterEngine Off
</Location>

[SL] integration with agora.cgi, anyone?

[Hugh E. <he...@re...>]

I'm curious to know if anyone here has done any work to integrate
agora.cgi with sql-ledger?  I'm exploring a project where I might try to
put them together.  It'd be great to get a leg up on that project, or to
find collaborators for such an animal.  

-- Hugh Esco
CampaignFoundations.com

[SL] Server error when adding new item (add part)

[Gloria A. <got...@gm...>]

Yesterday I downloaded and installed sql-ledger (2.6.22) on a Mandriva
server 2006.

The install proceeded ok and seems to be running fine.

I was able to edit the preferences, edit the system defaults, add to
the Chart of Accounts and add customers.  But when I try to add a
part, I get a server error after I enter the details and click on
save.

 --- 8< ----
Server error!

           The server encountered an internal error and was unable to
complete your request. Either the server is overloaded or there was an
error in a CGI script.

 If you think this is a server error, please contact the webmaster    Error 500

--- 8< ---

I've used it (2.6.3) on a Mandrake 8.2 and had no problems.  Also
tried to install it on a Mandriva 2006 and its working without the
problem.

 Can't see anything in the apache logs.  Any idea on what I might be
missing and where I might try to find possible causes?

Thanks

Re: [SL] Installing SQL Ledger on Win 2000

[Dieter S. <dsi...@sq...>]

On Thu, 14 Dec 2006, Mazhar Malik wrote:

> Hi guys,
>
> I am installing SQL Ledger for the first time on Windows 2000.
> According to the instructions available at
> http://www.sql-ledger.org/source/windows/install.pdf I need to
> download DBD-Pg.zip from http://www.edmund-mergl.de/export/ but I get
> file not found. So my first question to this list is that what are
> the alternatives available to this file.

http://pgfoundry.org/frs/?group_id=1000199&release_id=589

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

[SL] Installing SQL Ledger on Win 2000

[Mazhar M. <maz...@gc...>]

Hi guys,

I am installing SQL Ledger for the first time on Windows 2000. 
According to the instructions available at 
http://www.sql-ledger.org/source/windows/install.pdf I need to 
download DBD-Pg.zip from http://www.edmund-mergl.de/export/ but I get 
file not found. So my first question to this list is that what are 
the alternatives available to this file.

Thanks in advance.

mazhar
-- 

-----------------------------------------------------------------------

Instructional Development Specialist
Web Enabled Resources
Georgia College & State University
Campus Box 034
E-mail: maz...@gc...
Phone: (478) 445-2520

[SL] Assembly problem

[Ayen Y. <aye...@gm...>]

Hi everyone,

I found a problem in the assembly item.
If you make an assembly item consisting of other item and an Overhead
item, the Overhead item IS NOT calculated to the COGS on the Income
Statement report.
Is anyone ever experience this problem? Please help and thanks in advance.

From,
Ayen Yang

Re: [SL] Prepayment / Contract Services

[Matthew B. <mat...@co...>]

Seems to me it wouldn't go under AP or AR, but that it should be entered 
as some sort of Liability.  For example, we have set up (in QuickBooks, 
though) an account that is called Retainers as a Liability account.  
This account just has the dollar amount the client has paid.  As you 
execute the work, then realize the income, the money is pulled out of 
the Retainer account and placed in the Operating Account at that time.

Useful?

Steve Switzer wrote:

>I haven't received any further replies to this and figured I'd "bump"
>the thread. I need to have this ability shortly, as I'll be entering a
>contract very soon. I brainstormed a bit and tried to come up with a way
>to handle this with different AR entries. However, I quickly realized
>this won't work since the whole idea of an "AR" is to show that someone
>owes *you* money. So, I bill a customer for a bank of hours (they
>receive an invoice), and they pay it. The invoice is closed, since the
>payment was satisfied. What they were billed for must then go
>*somewhere* to cancel out the actual hours that I've logged. This almost
>seems like an AP/AR scenario against a part, where I've been paid for a
>part (really labor, but would need inventory), but then I have to pay a
>vendor and order the parts (the actual labor is performed). However, I
>cna't figure out how to get the time cards involved with this. Then
>again, should they be?
>Thoughts are greatly appreciated. *Somebody* must be doing this out
>there. Where are you? :)
>
>Thanks,
>Steve
>
>
>On Mon, 2006-11-06 at 10:34 -0500, Mark Bucciarelli wrote:
>
>  
>
>>On Mon, Nov 06, 2006 at 10:12:04AM -0500, Steve Switzer wrote:
>>    
>>
>>>Hello,
>>>   I currently use timecards / sales orders / invoices to track and bill
>>>for my time to a client. My client is now interested in going on a
>>>contact where they pay for 10 hour a week regardless of the time I spend
>>>there. However, it shoudl eventually balance out - I may spend 5 hours
>>>one week, 20 hours another week, 8 another, 2 another, 6 the next, etc.
>>>   What I need to happen is:
>>>1) Automatic invoicing for 10 hours every week. (easily done with
>>>recurring transactions)
>>>2) Tracking the balance of hours that they have paid for but not
>>>consumed
>>>3) Have timecards deduct from the balance of hours they prepaid
>>>4) Other jobs and product sales should not be intermingled with the
>>>hours. In other words, I don't want to track that they have $1000 worth
>>>of hours available, then sell them a $500 device to find that they have
>>>$50 worth of hours available... this should be completely separate.
>>>Also, I'd much rather track the available hours in *hours*, not
>>>*dollars*. :)
>>>5) Ability to report on hours balance is a must.
>>>
>>>Can anyone point out a way to do this with current features, or offer a
>>>quote for custom development?
>>>      
>>>
>>First idea I had is to poke around to see if you can use parts for
>>this, becase I know you can maintain inventory.   That would give
>>you hours.
>>
>>Thinking a bit more, it's probably much easier just to use a line
>>item on your chart of accounts.  If you get paid for ten hours,
>>but only work four, it seems like the value of that six hours
>>would be a liability.  This would track dollar value, not hours.
>>
>>I would think your invoice to the customer should crebit a
>>liability account (as that 10 hours is what you owe them), then
>>the invoice for actual time should debit that account.  I _think_
>>you could set the Income Account field for two different
>>Service's (one for the invoice to the customer and one for the
>>actual hours) to get what you want here.
>>
>>m
>>
>>-------------------------------------------------------------------------
>>Using Tomcat but need to do more? Need to support web services, security?
>>Get stuff done quickly with pre-integrated technology to make your job easier
>>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>>_______________________________________________
>>sql-ledger-users mailing list
>>sql...@li...
>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>    
>>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys - and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>  
>

Re: [SL] Prepayment / Contract Services

[Dr E. L. <el...@li...>]

It's a service, perhaps, not a part?

Create a suspense account for the client (PrePayment...)  and debit it
when they pay.  Then do your time cards, sales order and pay the
invoice from the PrePayment account by way of the Cash->Receipt.

el

on 12/14/06 6:34 AM Steve Switzer said the following:

> I haven't received any further replies to this and figured I'd
> "bump" the thread.  I need to have this ability shortly, as I'll be
> entering a contract very soon.  I brainstormed a bit and tried to
> come up with a way to handle this with different AR entries.
> However, I quickly realized this won't work since the whole idea of
> an "AR" is to show that someone owes *you* money.  So, I bill a
> customer for a bank of hours (they receive an invoice), and they pay
> it.  The invoice is closed, since the payment was satisfied.  What
> they were billed for must then go *somewhere* to cancel out the
> actual hours that I've logged.  This almost seems like an AP/AR
> scenario against a part, where I've been paid for a part (really
> labor, but would need inventory), but then I have to pay a vendor
> and order the parts (the actual labor is performed).  However, I
> cna't figure out how to get the time cards involved with this.  Then
> again, should they be?
>
> Thoughts are greatly appreciated.  *Somebody* must be doing this out
> there.  Where are you?  :)
>
> Thanks,
> Steve

Re: [SL] Prepayment / Contract Services

[Steve S. <st...@sw...>]

I haven't received any further replies to this and figured I'd "bump"
the thread. I need to have this ability shortly, as I'll be entering a
contract very soon. I brainstormed a bit and tried to come up with a way
to handle this with different AR entries. However, I quickly realized
this won't work since the whole idea of an "AR" is to show that someone
owes *you* money. So, I bill a customer for a bank of hours (they
receive an invoice), and they pay it. The invoice is closed, since the
payment was satisfied. What they were billed for must then go
*somewhere* to cancel out the actual hours that I've logged. This almost
seems like an AP/AR scenario against a part, where I've been paid for a
part (really labor, but would need inventory), but then I have to pay a
vendor and order the parts (the actual labor is performed). However, I
cna't figure out how to get the time cards involved with this. Then
again, should they be?
Thoughts are greatly appreciated. *Somebody* must be doing this out
there. Where are you? :)

Thanks,
Steve


On Mon, 2006-11-06 at 10:34 -0500, Mark Bucciarelli wrote:

> On Mon, Nov 06, 2006 at 10:12:04AM -0500, Steve Switzer wrote:
> > Hello,
> >    I currently use timecards / sales orders / invoices to track and bill
> > for my time to a client. My client is now interested in going on a
> > contact where they pay for 10 hour a week regardless of the time I spend
> > there. However, it shoudl eventually balance out - I may spend 5 hours
> > one week, 20 hours another week, 8 another, 2 another, 6 the next, etc.
> >    What I need to happen is:
> > 1) Automatic invoicing for 10 hours every week. (easily done with
> > recurring transactions)
> > 2) Tracking the balance of hours that they have paid for but not
> > consumed
> > 3) Have timecards deduct from the balance of hours they prepaid
> > 4) Other jobs and product sales should not be intermingled with the
> > hours. In other words, I don't want to track that they have $1000 worth
> > of hours available, then sell them a $500 device to find that they have
> > $50 worth of hours available... this should be completely separate.
> > Also, I'd much rather track the available hours in *hours*, not
> > *dollars*. :)
> > 5) Ability to report on hours balance is a must.
> > 
> > Can anyone point out a way to do this with current features, or offer a
> > quote for custom development?
> 
> First idea I had is to poke around to see if you can use parts for
> this, becase I know you can maintain inventory.   That would give
> you hours.
> 
> Thinking a bit more, it's probably much easier just to use a line
> item on your chart of accounts.  If you get paid for ten hours,
> but only work four, it seems like the value of that six hours
> would be a liability.  This would track dollar value, not hours.
> 
> I would think your invoice to the customer should crebit a
> liability account (as that 10 hours is what you owe them), then
> the invoice for actual time should debit that account.  I _think_
> you could set the Income Account field for two different
> Service's (one for the invoice to the customer and one for the
> actual hours) to get what you want here.
> 
> m
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] custom invoice paper size

[Stroller <lin...@my...>]

On 12 Dec 2006, at 05:37, Wan Ling wrote:
> ...
> my invoices are pre-printed forms of width 8.5in, height 5.5in,  
> which is
> half letter size. i have done all the necessary width and height  
> settings in
> invoice.tex, but still the canvas shows the standard letter size  
> when printing
> to screen and printer...

Can you post your whole invoice.tex, please?

Stroller.


PS: it's redundant having pre-printed invoices with SQL-Ledger. A  
LaTeX template can surely do everything you need; although some may  
find fonts limited, you can rule lines and include all the graphics &  
logos you need.

[SL] custom invoice paper size

[Wan L. <big...@ya...>]

my invoices are pre-printed forms of width 8.5in, height 5.5in, which is=0A=
half letter size. i have done all the necessary width and height settings i=
n=0Ainvoice.tex, but still the canvas shows the standard letter size when p=
rinting=0Ato screen and printer. how can i adjust it properly?=0A=0Ai am us=
ing miktex 2.5 on windows xp with sql ledger 2.6.19.=0A=0Athanks=0Awan ling=
=0A=0A=0A=0A=09=0A=0A=09=0A=09=09=0A__________________________________ =0AM=
eet your soulmate! =0AYahoo! Asia presents Meetic - where millions of singl=
es gather =0Ahttp://asia.yahoo.com/meetic =0A

Re: [SL] Is there a way to import a complete Chart of Accounts from any outside source?

[John W. F. <joh...@ve...>]

On Saturday 09 December 2006 09:37 am, Wallace Roberts Consulting wrote:
> On 12/9/06, John W. Foster <joh...@ve...> wrote:
> > I have a COA that I need installed, as either a MS Word doc or as an
> > Excell spreadsheet. I know I can alter the existing installed COA as
> > needed, but, it would be MUCH faster if I could import the COA that I
> > need.
>
> You can DIY (Do It Yourself) pretty easily.  First of all, login to
> your Postgres server and invoke an interactive SQL session as follows:
>
> $ psql yourDatabaseName yourSQLLedgerUserName
> Welcome to psql 7.4.11, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> yourDatabaseName=>
>
> Next, see how the CoA is organized:
>
> yourDatabaseName=> \d chart
>                    Table "public.chart"
>    Column    |     Type     |          Modifiers
> -------------+--------------+-----------------------------
>   id          | integer      | default nextval('id'::text)
>   accno       | text         | not null
>  description | text         |
>   charttype   | character(1) | default 'A'::bpchar
>  category    | character(1) |
>  link        | text         |
>  gifi_accno  | text         |
>
> yourDatabaseName=>
>
> Then, if you wish, you can see what a few rows look like:
>
> yourDatabaseName=> select * from chart;
>   id   | accno |            description            | charttype | category |
>                 link                      | gifi_accno
> -------+-------+-----------------------------------+-----------+----------+
>----- ------------------------------------------+------------
>  10001 | 1000  | CURRENT ASSETS                    | H         | A        |
>
>  10002 | 1060  | Checking Account                  | A         | A        |
> AR_p aid:AP_paid                               |
>  10003 | 1065  | Petty Cash                        | A         | A        |
> AR_p aid:AP_paid                               |
>  10004 | 1200  | Accounts Receivables              | A         | A        |
> AR
>
>  10005 | 1205  | Allowance for doubtful accounts   | A         | A        |
>
>  10006 | 1500  | INVENTORY ASSETS                  | H         | A        |
>
>   10007 | 1520  | Inventory / Hardware              | A         | A
>
>     | IC
>
>   10008 | 1530  | Inventory / Software              | A         | A       
> | IC ...
>
> >From here, you can easily see how the 'chart' table (the one that
>
> describes the CoA) is organized.  Given this information, you can take
> your M$-Word file that contains your desired CoA, massage it into a
> set of SQL INSERT commands (using global search-and-replace), then do
> a "Save as..." on the file, using a .txt (TEXT) format when you save
> it.  If you place a DELETE command at the beginning of the file,
Does this in fact delete all of the original entries from the database leaving 
an empty shell? If that is the case since I have a complete new chart of 
accounts...could I not just place the proper insert commands and import them 
into an empty database created by psql. Or is there something else happening 
here?
BTW: Thanks greatly for the excellent instructions. I really appreciate the 
help.

> before any of the INSERTs (delete * from chart;), you easily can
> import this file & create your new CoA:
>
> $ psql yourDatabaseName yourSQLLedgerUser < yourImportFile.txt
>

-- 
John W. Foster

Re: [SL] help!! duplicate items appearing on invoices RESOLVED

[R P. <arc...@mt...>]

Any idea on why the sequence got out of sync ?

Cheers,
Roy

On Monday 11 December 2006 5:09 pm, Lenny Leblanc wrote:
> This did end up being the sequence numbers in the invoiceid sequence.
> 
> After using setval() to update the sequence number everything appears to
> be working fine, however I do still have to remove and re-add all of the
> invoices that have duplicate information.  I haven't noticed any
> oddities with older invoices but I'm hoping that none of the information
> has been overwritten.
> 
> --
> Lenny Leblanc
> 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of R
> Pennington
> Sent: Friday, December 08, 2006 11:57 AM
> To: sql...@li...
> Subject: Re: [SL] help!! duplicate items appearing on invoices
> 
> On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> > Hello List,
> > 
> > I've been running sql-ledger for a long time and just recently my
> > invoices have started showing up with duplicate items when I view or
> > print the invoice.  This only happens with new invoices that I enter.
> > All my older invoices show and print normal.
> > 
> > This appeared to start after entering a cash receipt for a customers
> > invoice that wasn't fully paid.  Rather than applying the payment to
> the
> > actual invoice sql-ledger created a separate blank transaction with
> only
> > the payment.
> > 
> > I also checked into the General Ledger transactions and I don't see
> the
> > duplicates there, in fact everything appears to be fine.
> > 
> > I do have backups and can try reverting to see if this resolves it,
> but
> > I thought I would check with the list first to see if there is an
> easier
> > way around it.
> > 
> > Anyone have any ideas?
> > 
> > --
> > Lenny Leblanc
> 
> 
> Hello Lenny.
> 
> I seem to remember a similar problem that was posted to the list
> recently.
> I believe it was caused by a problem with the sequence number generated
> by the database.
> Did you recently restore from a backup ?

Re: [SL] help!! duplicate items appearing on invoices RESOLVED

[Lenny L. <lle...@ma...>]

This did end up being the sequence numbers in the invoiceid sequence.

After using setval() to update the sequence number everything appears to
be working fine, however I do still have to remove and re-add all of the
invoices that have duplicate information.  I haven't noticed any
oddities with older invoices but I'm hoping that none of the information
has been overwritten.

--
Lenny Leblanc


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of R
Pennington
Sent: Friday, December 08, 2006 11:57 AM
To: sql...@li...
Subject: Re: [SL] help!! duplicate items appearing on invoices

On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> Hello List,
>=20
> I've been running sql-ledger for a long time and just recently my
> invoices have started showing up with duplicate items when I view or
> print the invoice.  This only happens with new invoices that I enter.
> All my older invoices show and print normal.
>=20
> This appeared to start after entering a cash receipt for a customers
> invoice that wasn't fully paid.  Rather than applying the payment to
the
> actual invoice sql-ledger created a separate blank transaction with
only
> the payment.
>=20
> I also checked into the General Ledger transactions and I don't see
the
> duplicates there, in fact everything appears to be fine.
>=20
> I do have backups and can try reverting to see if this resolves it,
but
> I thought I would check with the list first to see if there is an
easier
> way around it.
>=20
> Anyone have any ideas?
>=20
> --
> Lenny Leblanc


Hello Lenny.

I seem to remember a similar problem that was posted to the list
recently.
I believe it was caused by a problem with the sequence number generated
by the database.
Did you recently restore from a backup ?




------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] sql-ledger-users Digest, Vol 8, Issue 2

[Fausto Z. <fau...@gm...>]

Hello group

I try to install sql-ledger on windows machine, but in the moment to 
install the DBI package ( i use the DBI 1.4.53 downloaded from cpan.com) 
the ppm program say "the .pm file is not found".

Have another form to install sql-ledger more easy? .

Thanks

Fausto Zarria
Ecuador
South America




-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.

[SL] POS Receipt

[Peter D. <mer...@ma...>]

Hi,
I'm got Epson TMJ2100 POS printer and want to use it with sql-ledger for
printing POS receipts. Printer got parallel interface and I'm able to print
receipts. My question is, is anybody could give me some hints how to include
printer control commands into pos_invoice.txt template?
I want to include Company logo and manipulate look of receipts.
Printer is capable to print images and colour.
Thanks
Peter

--=20

Search for products and services at:=20
http://search.mail.com

Re: [SL] Is there a way to import a complete Chart of Accounts from any outside source?

[Wallace R. C. <wrc...@gm...>]

On 12/9/06, John W. Foster <joh...@ve...> wrote:
> I have a COA that I need installed, as either a MS Word doc or as an Excell
> spreadsheet. I know I can alter the existing installed COA as needed, but, it
> would be MUCH faster if I could import the COA that I need.

You can DIY (Do It Yourself) pretty easily.  First of all, login to
your Postgres server and invoke an interactive SQL session as follows:

$ psql yourDatabaseName yourSQLLedgerUserName
Welcome to psql 7.4.11, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

yourDatabaseName=>

Next, see how the CoA is organized:

yourDatabaseName=> \d chart
                   Table "public.chart"
   Column    |     Type     |          Modifiers
-------------+--------------+-----------------------------
  id          | integer      | default nextval('id'::text)
  accno       | text         | not null
 description | text         |
  charttype   | character(1) | default 'A'::bpchar
 category    | character(1) |
 link        | text         |
 gifi_accno  | text         |

yourDatabaseName=>

Then, if you wish, you can see what a few rows look like:

yourDatabaseName=> select * from chart;
  id   | accno |            description            | charttype | category |
                link                      | gifi_accno
-------+-------+-----------------------------------+-----------+----------+-----
------------------------------------------+------------
 10001 | 1000  | CURRENT ASSETS                    | H         | A        |
                                          |
 10002 | 1060  | Checking Account                  | A         | A        | AR_p
aid:AP_paid                               |
 10003 | 1065  | Petty Cash                        | A         | A        | AR_p
aid:AP_paid                               |
 10004 | 1200  | Accounts Receivables              | A         | A        | AR
                                          |
 10005 | 1205  | Allowance for doubtful accounts   | A         | A        |
                                          |
 10006 | 1500  | INVENTORY ASSETS                  | H         | A        |
                                          |
  10007 | 1520  | Inventory / Hardware              | A         | A
    | IC
                                          |
  10008 | 1530  | Inventory / Software              | A         | A        | IC
...

>From here, you can easily see how the 'chart' table (the one that
describes the CoA) is organized.  Given this information, you can take
your M$-Word file that contains your desired CoA, massage it into a
set of SQL INSERT commands (using global search-and-replace), then do
a "Save as..." on the file, using a .txt (TEXT) format when you save
it.  If you place a DELETE command at the beginning of the file,
before any of the INSERTs (delete * from chart;), you easily can
import this file & create your new CoA:

$ psql yourDatabaseName yourSQLLedgerUser < yourImportFile.txt

Voila!

> It is very
> specialized but seems to pretty well follow the installed COA, except very
> detailed & specefic to the building industry. It is available publicly from
> the NAHB web site. It is for home builders. It might be something worth
> adding to the distribution anyway.

If you follow the above directions, you can send your .txt file to DWS
for inclusion in his distribution & contribute to the continued
success of SQL-Ledger.
-- 
Best Regards,
Wallace

[SL] Is there a way to import a complete Chart of Accounts from any outside source?

[John W. F. <joh...@ve...>]

I have a COA that I need installed, as either a MS Word doc or as an Excell 
spreadsheet. I know I can alter the existing installed COA as needed, but, it 
would be MUCH faster if I could import the COA that I need. It is very 
specialized but seems to pretty well follow the installed COA, except very 
detailed & specefic to the building industry. It is available publicly from 
the NAHB web site. It is for home builders. It might be something worth 
adding to the distribution anyway.
Thanks!
John

[SL] New version of timecardimport script now imports time records from iBiz

[Jeremy M. <Je...@Ma...>]

I'm not sure if the original announcement of my timecardimport script 
got through to the Announce list (I never saw it), but I have now 
released a more mature version 0.3 which now allows records to be 
imported from the iBiz time billing application for Mac OS X (as well as 
from GnoTime for Unix/Linux and Timesheet for Palm OS which were 
previously supported).

Please test it out and let me know if it works for you.  You can 
download it from
http://www.malcolm.id.au/files/software/unix/timecardimport/timecardimport-0.3.tgz.

-- 
Jeremy Malcolm LLB (Hons) B Com
Internet and Open Source lawyer, IT consultant, actor
host -t NAPTR 1.0.8.0.3.1.2.9.8.1.6.e164.org|awk -F! '{print $3}'

Re: [SL] DIY Accounting

[Dieter S. <dsi...@sq...>]

Not a mystery at all. I have two servers running www. They may not have
been synchronized at the same time, so it depends which one you were
seeing. I have no control over which server is the main or the slave.

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Sat, 9 Dec 2006, david wrote:

> Thanks Paul... it has now returned! One of life's great mysteries ;-)
>
> http://www.sql-ledger.com/cgi-bin/nav.pl?page=contrib/contributors.html&title=Contributors
>
> On Fri, 2006-12-08 at 09:47 +0100, Paul Tammes wrote:
> > david schreef:
> > > On Thu, 2006-12-07 at 21:05 -0600, John Hasler wrote:
> > >
> > >> And now it's back.
> > >>
> > >
> > > but now gone again.....
> > >
> > >
> > Hi all,
> >
> > I happen to have a copy here, it is only chapter1 and in draft form at that.
> > The idea is to give some basic explanation to non-beancounters as to the
> > logic of some things.
> >
> > If you are interested, mail me offlist and i can reply with a copy if it
> > keeps dissapearing.
> >
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > opinions on IT & business topics through brief surveys - and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] help!! duplicate items appearing on invoices

[Lenny L. <lle...@ma...>]

No I haven't recently restored from backup.  This just seemed to happen
out of the blue.

--
Lenny Leblanc
=20
628 Leila Avenue
Winnipeg, Manitoba  R2V 3N7
P: 204.338.0233
=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of R
Pennington
Sent: Friday, December 08, 2006 11:57 AM
To: sql...@li...
Subject: Re: [SL] help!! duplicate items appearing on invoices

On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> Hello List,
>=20
> I've been running sql-ledger for a long time and just recently my
> invoices have started showing up with duplicate items when I view or
> print the invoice.  This only happens with new invoices that I enter.
> All my older invoices show and print normal.
>=20
> This appeared to start after entering a cash receipt for a customers
> invoice that wasn't fully paid.  Rather than applying the payment to
the
> actual invoice sql-ledger created a separate blank transaction with
only
> the payment.
>=20
> I also checked into the General Ledger transactions and I don't see
the
> duplicates there, in fact everything appears to be fine.
>=20
> I do have backups and can try reverting to see if this resolves it,
but
> I thought I would check with the list first to see if there is an
easier
> way around it.
>=20
> Anyone have any ideas?
>=20
> --
> Lenny Leblanc


Hello Lenny.

I seem to remember a similar problem that was posted to the list
recently.
I believe it was caused by a problem with the sequence number generated
by the database.
Did you recently restore from a backup ?




------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] help!! duplicate items appearing on invoices

[R P. <arc...@mt...>]

On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> Hello List,
> 
> I've been running sql-ledger for a long time and just recently my
> invoices have started showing up with duplicate items when I view or
> print the invoice.  This only happens with new invoices that I enter.
> All my older invoices show and print normal.
> 
> This appeared to start after entering a cash receipt for a customers
> invoice that wasn't fully paid.  Rather than applying the payment to the
> actual invoice sql-ledger created a separate blank transaction with only
> the payment.
> 
> I also checked into the General Ledger transactions and I don't see the
> duplicates there, in fact everything appears to be fine.
> 
> I do have backups and can try reverting to see if this resolves it, but
> I thought I would check with the list first to see if there is an easier
> way around it.
> 
> Anyone have any ideas?
> 
> --
> Lenny Leblanc


Hello Lenny.

I seem to remember a similar problem that was posted to the list recently.
I believe it was caused by a problem with the sequence number generated by the database.
Did you recently restore from a backup ?

[SL] Only big hurdle I have with SQL-Ledger...

[R P. <arc...@mt...>]

Consider this sequence of buying and selling products purchased in a foreign currency with a credit card.
Using a credit card is becoming the most common method to pay vendors in North America. 
Even the gov't departments that buy products from us use corporate credit cards.


Hopefully someone has a suggestion on how to handle this.

Note: In the follooing example, the credit card exchange rate is calculated by the bank at the end of the business day. This is important to remember.

1) Enter the purchase order
	SL wants to know the exchange rate.... but I can't determine the exchange rate I would be charged until the day is over (when the markets close)
        Solution ?:   Enter the sale order in CDN funds and then alter it to USD tomorrow to reflect the correct exchange rate

2) Shipment arrives
	When using the "ship" or "vendor invoice" functionality to receive the item into inventory, SL wants to know the exchange rate.
	Problem: I can't find this out until the next day. 
	Partial Solution: Don't receive the item into inventory until the next day. This prevents me from selling the items until the day after the shipment arrives.
				This can only be done with an invoice, since you can't manually enter the date when using the "receive" shipment function.
				Which leads to a 2nd problem....
	Problem#2: When I turn the Order into an invoice, SL wants to know TODAY"S exchange rate. even though the invoice is NOT for today's date.
				After all.. you rarely have a copy of the invoice on the same date it was created by your vendor.
				It would be nice if SL only asked for exchange rates when the invoice is posted. NOT before it's even created
				Since I have no way to know what TODAY"S exchange rate is......and i'm forced to enter the exchange rate for today.....
				I enter a fake exhange rate for today, THEN enter the actual invoice date and exchange rate for THAT date and post the invoice.
				I then have to go into the database and delete the fake exchange rate I entered for today.   :P

3) Pay the vendor invoice
	I pay the invoice with a credit card.....wait a day until I know what exchange rate I was charged.....then enter the payment into SL.


Is there a way to handle these invoices in native currency and then just do GL entries to handle the Foreign exchange rate charged when the vendor is paid ?


Regards,
Roy P

P.S.

Not only is this whole process a hassle... 
It would be much nicer if SL calculated COGS when a report was run., not when both a vendor invoice and customer invoice are created.
This would allow you sell items before all this foreign exchange rate was entered. and prevent the dreaded COGS out of order issue we all know about.

Ultimately I'd like to see:
1) Exchange rate to be entered when an vendor invoice is posted, NOT before you even get a chance to enter the invoice's date.
2) Make SL capable of avoiding the whole thing altogether and only handle the PAYMENTS in foreign currency. 
	Of course this would be for those who don't care about foreign exchange gain/loss
3) COGS dynamically calculated when a report is run, NOT when goods are sold.
4) Support for multiple exchange rates (to handle multiple foreign currency transactions done in a single day using multiple methods)

[SL] help!! duplicate items appearing on invoices

[Lenny L. <lle...@ma...>]

Hello List,

I've been running sql-ledger for a long time and just recently my
invoices have started showing up with duplicate items when I view or
print the invoice.  This only happens with new invoices that I enter.
All my older invoices show and print normal.

This appeared to start after entering a cash receipt for a customers
invoice that wasn't fully paid.  Rather than applying the payment to the
actual invoice sql-ledger created a separate blank transaction with only
the payment.

I also checked into the General Ledger transactions and I don't see the
duplicates there, in fact everything appears to be fine.

I do have backups and can try reverting to see if this resolves it, but
I thought I would check with the list first to see if there is an easier
way around it.

Anyone have any ideas?

--
Lenny Leblanc