sql-ledger-users — SQL-Ledger users

Re: [SL] New customer does not show on Edit Sales Invoice screen

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

This may have something to do with the customers Start Date.  I believe
if the start date is set before the invoice date then the customer won't
show up in the list.  This is an editable field in the customers
details.

--
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
Craig Isdahl
Sent: Tuesday, January 09, 2007 10:24 AM
To: sql...@li...
Subject: [SL] New customer does not show on Edit Sales Invoice screen

Happy New Year Everyone!!

I have a small issue with which I hope someone can provide guidance.

We have an existing customer who has split their business to create 2
separate entities.  We previously invoiced 100% of our services to the
original entity but now they would like 50% of our services invoiced to
each
entity.  No problem.

In SL I did the following:
- pulled up the (original) 1/5/07 invoice and issued a credit memo
- pulled up the (original) 1/5/07 invoice and edited; did a "post as
new"
- pulled up the (original) 1/5/07 invoice and edited; did a "post as
new"

I now have reversed the original invoice and created 2 new invoices (50%
of
our services on each).  At this point both new invoices are still
assigned
to the original entity.

In SL I did the following:
- added the new entity (company) to SL
- pulled up the new invoice I created above which should be assigned to
the
new entity.  The new entity is not available for selection from the
"company" dropdown list.

I have tried "refreshing" from every relevant screen in all ways in
which I
know how to "refresh".  I have logged out and back in to the system.  I
restarted postgresql.  I waited over 24 hours thinking it might be
cached
someplace.  No luck.

How can I re-assign this invoice to the new entity (company)?

We provide services and do not have inventory so reposting an invoice is
not
a concern for us.

Thanks!
Craig


------------------------------------------------------------------------
-
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

[SL] New customer does not show on Edit Sales Invoice screen

[Craig I. <cr...@da...>]

Happy New Year Everyone!!

I have a small issue with which I hope someone can provide guidance.

We have an existing customer who has split their business to create 2
separate entities.  We previously invoiced 100% of our services to the
original entity but now they would like 50% of our services invoiced to each
entity.  No problem.

In SL I did the following:
- pulled up the (original) 1/5/07 invoice and issued a credit memo
- pulled up the (original) 1/5/07 invoice and edited; did a "post as new"
- pulled up the (original) 1/5/07 invoice and edited; did a "post as new"

I now have reversed the original invoice and created 2 new invoices (50% of
our services on each).  At this point both new invoices are still assigned
to the original entity.

In SL I did the following:
- added the new entity (company) to SL
- pulled up the new invoice I created above which should be assigned to the
new entity.  The new entity is not available for selection from the
"company" dropdown list.

I have tried "refreshing" from every relevant screen in all ways in which I
know how to "refresh".  I have logged out and back in to the system.  I
restarted postgresql.  I waited over 24 hours thinking it might be cached
someplace.  No luck.

How can I re-assign this invoice to the new entity (company)?

We provide services and do not have inventory so reposting an invoice is not
a concern for us.

Thanks!
Craig

[SL] Currency Field Type

[Les R <ope...@gm...>]

Hi,

What kind of SQL field type is used to store currency values in Sql-Ledger?

Thanks,

Les Richardson
Open Admin for Schools

[SL] returning goods

[ma ga <ma_...@ya...>]

Hello All,=0A  First, thanks a lot for this informative list.=0A  After wro=
king for some time with the package, one of my customers wanted to return t=
o me some goods.  How can I do this in the system to affect the inventory. =
   One fast solution is to update my invoice by deleting the returned item?=
 but  I am not sure if this is the correct way as I would like to track ite=
ms returned....,=0AThe optimum is to create an account for sales returns, a=
nd affect it....=0A=0AAny thoughts are appreciated,=0A-Mahmoud=0A=0A_______=
___________________________________________=0ADo You Yahoo!?=0ATired of spa=
m?  Yahoo! Mail has the best spam protection around =0Ahttp://mail.yahoo.co=
m 

Re: [SL] Check printing problem

[Tom D. <td...@ro...>]

On Sun, 7 Jan 2007, Mark Lubratt wrote:

> Hello!
>
> I just suffered from over-active finger syndrome.  I was going to
> print out some checks from the Cash->payments screen. I selected the
> payments I wanted to make; entered the check numbers in the source
> field; and instead of hitting "Update", I accidentally hit "Post".  I
> still need to print the actual checks and now I can't seem to figure
> out how to do that from any screen.
>
> So, I thought I might need to "undo" in the database a little bit.
> After backing up (c:= , I set the paid and datepaid fields to null in
> the ap table for those invoices I'm trying to print checks for and
> also deleted the gl table entries that moved the money from the
> checking account to accounts payable.  This didn't seem to do
> everything I needed to since I still couldn't see those invoices
> again on the Cash->payments screen.  After perusing the database, I
> can't seem to figure out what more I need to do.
>
> I've restored the database back from my backup.

You are working way too hard. :-)

>
> Can anyone tell me where I can reprint those checks from?  Or, what
> else do I need to do in the database to "undo" the check payment that
> never happened.

Goto ap -> transactions -> select the vendor and check the closed
box -> At the bottom select check from the drop down box on the
print line.


Regards,

Tom

Re: [SL] Editing data entry pages

[Jeff R. <Jef...@te...>]

Thanks Dieter

I've printed Chapter 19 and am trying to figure it all out, I was hoping 
to do a quick hack but since you've taken the time to allow extras to be 
integrated I figure I should take the time to make the changes properly. 
More questions to come I'm sure but I'm excited to see this software 
come to life and begin to work!

Jeff Roberts

Dieter Simader wrote:
> Add a language, see chapter 19.8
>
>   

[SL] Check printing problem

[Mark L. <mar...@in...>]

Hello!

I just suffered from over-active finger syndrome.  I was going to  
print out some checks from the Cash->payments screen. I selected the  
payments I wanted to make; entered the check numbers in the source  
field; and instead of hitting "Update", I accidentally hit "Post".  I  
still need to print the actual checks and now I can't seem to figure  
out how to do that from any screen.

So, I thought I might need to "undo" in the database a little bit.   
After backing up (c:= , I set the paid and datepaid fields to null in  
the ap table for those invoices I'm trying to print checks for and  
also deleted the gl table entries that moved the money from the  
checking account to accounts payable.  This didn't seem to do  
everything I needed to since I still couldn't see those invoices  
again on the Cash->payments screen.  After perusing the database, I  
can't seem to figure out what more I need to do.

I've restored the database back from my backup.

Can anyone tell me where I can reprint those checks from?  Or, what  
else do I need to do in the database to "undo" the check payment that  
never happened.

SL 2.6.22

Thanks!
Mark

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

Yes, you are absolutely, 100% correct!  Good old grep had no trouble at all
finding it.  Thank you!

I edited the backup file _correctly_ this time and restored.  I made a
couple of invoices which had previously caused me grief and they were fine.
The first new part I entered was fine.  Every subsequent part I enter
'doubles itself' and sets an arbitrary value for stock for just one of
them.  Since I have been using an improperly restored SL since early
October, I think I have created some very large problems!  I compared the
sequence numbers from previous backups and it looks like they should be
continually increasing:

Backup from Jan 29/06:
id -> 11716
invoiceid -> 2056
orderitemsid -> 6


Backup from May 22/06:
id -> 12078
invoiceid -> 2620
orderitemsid -> 10

(last backup before I wrecked things)
Backup from Oct 7/06:
id -> 12445
invoiceid -> 3141
orderitemsid -> 11

Backup from Dec 30/06:
id -> 10151
invoiceid -> 207
orderitemsid -> 2

Uh-oh!  I'll bet my improper restoration in October was using id, invoiceid
and orderitemsid values of 10000, 0 and 0 (respectively).  (Does that mean
I've overwritten 360 other 'transactions'?)

I can see one way to fix this (although I don't like the thought of it):
restore the backup from October 7th and re-enter everything that was entered
since then.  Could I use the Oct 7th id, invoiceid and orderitemsid values
to restore my Dec 30th backup, expecting to have no further trouble, and
knowing that some damage has been done already that I'll fix as time
permits?

Thanks,

Jason Kay.


On 1/6/07, Dieter Simader <dsi...@sq...> wrote:
>
> Trust me, there is a value in the backup file.


<snipped! >

Dieter Simader

Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

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

On Fri, 5 Jan 2007, Jason Kay wrote:

> Well, that didn't help.  There aren't any sequence number values for
> the invoiceid or orderitemsid in my older backups.  I did find some
> values for them in a backup I had made using pg_dumpall quite a long
> time ago.  I thought I would try putting them in my recent backup file
> and restoring it anyway, but I still get old payments and such showing
> up on new invoices.

Trust me, there is a value in the backup file.

This is from a v2.4 backup

search for 'DROP SEQUENCE' and you'll see the starting numbers.

DROP SEQUENCE id ;
CREATE SEQUENCE id START 17515;
--
DROP SEQUENCE invoiceid ;
CREATE SEQUENCE invoiceid START 17006;
--
DROP SEQUENCE orderitemsid ;
CREATE SEQUENCE orderitemsid START 475;

-- 
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 ================

Re: [SL] Editing data entry pages

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

Add a language, see chapter 19.8

-- 
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 Fri, 5 Jan 2007, Jeff Roberts wrote:

> Hello All
>
> I'm looking to edit the data entry page "Add Sales Invoice"
>
> I've found the templates for printing out the invoice and changed them
> so the printed invoice looks correct, now I'd like to change the data
> entry page so that I can see the customers account status (Terms) and
> shipping preference while I'm building his invoice.
>
> In particular I want to change the "Shipping Point" field to
> title="Terms" and have the field pick up <shiptofax> which I'm re-purposing
>
> I'd also like to change the field "Ship Via" from a data entry field to
> pick up <shiptoemail> which I've also re-purposed.
>
> I assume this page is built with HTMl since it's displayed in my browser
> but I can't seem to find where it's stored so that I can edit it. Can
> someone point me to where I need to look?
>
> Jeff
>
>
> -------------------------------------------------------------------------
> 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] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <jas...@gm...>]

Well, that didn't help.  There aren't any sequence number values for
the invoiceid or orderitemsid in my older backups.  I did find some
values for them in a backup I had made using pg_dumpall quite a long
time ago.  I thought I would try putting them in my recent backup file
and restoring it anyway, but I still get old payments and such showing
up on new invoices.

Anybody have any suggestions?

Thanks,

Jason Kay.

---------- Forwarded message ----------
From: Jason Kay <ja...@no...>
Date: Wed, 3 Jan 2007 14:42:47 -0800
Subject: Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3
To: sql...@li...

Okay, good.  That's what I did.

I'm going to look at some of my older backups (from before I messed
everything up) to see if I can find some values for the invoiceid and
orderitemsid sequences and see what that does.

Thanks,

Jason Kay.

[SL] Check template including employee name

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

I want to include the employee name in my payment receipts/checks. The
value <%employee%> works on most templates, not on check.tex - How do I
include this, do I have to modify the code?

This should be more or less the query, but where should I put it?

SELECT name FROM employee WHERE login =3D '$form->{login}'


Thanks for any hint!

Enrique

--=20
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] CSV files and importing

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

> I downloaded the import script but it says that I must have my data in
> tab delineated fixed length format and I'm having trouble finding a
> program that will save in fixed length format. My current data is in
> .DBF format and I've tried Paradox and Star Office 6.0 but neither give=
s
> an option to save in a fixed length. My workstation computers are Linux
> so a solution from EMS is out of the question, any suggestions?


You can convert with OpenOffice from dbf to csv and import with=20
phppgadmin: http://phppgadmin.sourceforge.net/ - Worked for me.

--=20
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] printing invoices from the command lines

[C. D. H. <Du...@Du...>]

Dr Eberhard Lisse wrote:
> Has anyone been able to print invoices from the command line?
>
> I need to have a large number of invoices printed, by invoice number.
>
> There is an example in the manual but it doesn't work, and I am too
> stupid to figure it out.
>
> Has anyone got a script ready that can do this?
>
>   
We print invoices, pick slips, and pack slips from the command line 
(using the API).  In addition, we eMail POs essentially from the command 
line (using WWW::Mechanize).  My personal opinion is that using a Perl 
wrapper, such as LWP or Mechanize is a heck of a lot easier then using 
the API - but your results may vary.  Why don't you post the command 
line that you're trying to use and we'll tell you what's wrong with it.


Dunc

Re: [SL] Upgrading postgresql - 8.0.8 -> 8.0.9

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

I'd do a pg_dumpall....
I'd also backup any postgresql config files that you customized......pg_hba.conf for example.

I'd also take a look at the upgrade documentation for the version you are upgrading to.
http://www.postgresql.org/docs/8.0/interactive/install-upgrading.html

Also check the docs for the package you are upgrading to.
Sometimes the package for your distribution will do things not shown in the postgresql docs.
For example....the recent Mandriva package tries to automatically backup, upgrade and restore the database. It failed on my machine... 
I had a  backups of the database and all my config files so it wasn't a big problem.

Cheers,
Roy



On Thursday 04 January 2007 9:18 pm, Stroller wrote:
> Hi there,
> 
> My distro is offering me upgrades of postgresql and libpq, both from  
> versions 8.0.8 to 8.0.9.
> 
> I do daily backups of my database using pg_dumpall - which I think is  
> completely comprehensive - but I thought I'd check here first to see  
> if there're any gotyas to be considered before I risk breaking  
> anything. This will be my first postgresql upgrade since going live  
> with SL; my distro demands that I uninstall the old version of  
> postgresql before installing the new one, so I will be sure to stop  
> it from the init scripts first.
> 
> Thanks in advance for any pointers of words of encouragement,
> 
> Stroller.

[SL] printing invoices from the command lines

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

Has anyone been able to print invoices from the command line?

I need to have a large number of invoices printed, by invoice number.

There is an example in the manual but it doesn't work, and I am too
stupid to figure it out.

Has anyone got a script ready that can do this?

el
-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

[SL] Editing data entry pages

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

Hello All

I'm looking to edit the data entry page "Add Sales Invoice"

I've found the templates for printing out the invoice and changed them 
so the printed invoice looks correct, now I'd like to change the data 
entry page so that I can see the customers account status (Terms) and 
shipping preference while I'm building his invoice.

In particular I want to change the "Shipping Point" field to 
title="Terms" and have the field pick up <shiptofax> which I'm re-purposing

I'd also like to change the field "Ship Via" from a data entry field to 
pick up <shiptoemail> which I've also re-purposed.

I assume this page is built with HTMl since it's displayed in my browser 
but I can't seem to find where it's stored so that I can edit it. Can 
someone point me to where I need to look?

Jeff

Re: [SL] Upgrading postgresql - 8.0.8 -> 8.0.9

[Hamish B. <hw...@be...>]

On Friday 05 January 2007 16:18, Stroller wrote:
> My distro is offering me upgrades of postgresql and libpq, both from
> versions 8.0.8 to 8.0.9.
<snip>
> Thanks in advance for any pointers of words of encouragement,

AAMOI I'm running SL and postgresql-8.0.9-r1 on Gentoo now with no problems, 
but haven't had to do a restore as yet.

Hamish
   
-- 
Sent via KMail 1.9.5, Gentoo 1.12.6, Linux-2.6.18-gentoo-r3

Re: [SL] Numbers

[C. D. H. <Du...@Du...>]

Florian Reitmeir wrote:
> Hi,
>
> i've to deploy sql-ledger to my company.. and i've read the manual, and
> changed some of the german translations. (if there is some intrest in this,
> to whom can i send them?)
>
> the number, like 'order number', 'Invoice Number', 'Quotation Number' .. are
> these generated automatic? or semi automatic? And how can this numbers
> controlled, so is it possible to change/jump number by year? or are these
> just counters?
>
>
> e.g. we want .. 
>
> year 2006
> starting by 1000
>
> year 2007
> starting by 5000
>   
The kind of numbering that you're looking at - ranges for years - can't 
be done automatically with SQL-Ledger.  SQL-Ledger will maintain a 
sequence for you and can insert Year, Month, etc.  For example, I use 
A<%yy%>.13334 for my invoices.  This builds invoice numbers in the 
A07.13334 fashion.  07 will go to 08 next year, and the number will 
increase by 1 with each invoice.  On the part side of things I 
autonumber parts with <%description 3%><%yy%>.15428 - which uses the 
first 3 characters of my partname, the year, followed by a sequential 
number. 

If you're looking to change your invoice number by 4000 between years 
I'd either go in and change the seed on Jan 1, or I'd write a trigger 
that did it for me.

Dunc

[SL] Upgrading postgresql - 8.0.8 -> 8.0.9

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

Hi there,

My distro is offering me upgrades of postgresql and libpq, both from  
versions 8.0.8 to 8.0.9.

I do daily backups of my database using pg_dumpall - which I think is  
completely comprehensive - but I thought I'd check here first to see  
if there're any gotyas to be considered before I risk breaking  
anything. This will be my first postgresql upgrade since going live  
with SL; my distro demands that I uninstall the old version of  
postgresql before installing the new one, so I will be sure to stop  
it from the init scripts first.

Thanks in advance for any pointers of words of encouragement,

Stroller.

Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

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

Thanks Adrian & Enrique

Edited backup and reinstalled.
At the moment everything working fine

Peter

> ----- Original Message -----
> From: "Adrian Blake" <adr...@ie...>
> To: sql...@li...
> Subject: Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5
> Date: Thu, 04 Jan 2007 05:58:30 +1100
>=20
>=20
> Peter,
>=20
> I did the same a few days ago. see Enrique's comments. Was the=20
> SQL-Ledger the latest version or near latest?
>=20
> Adrian
>=20
> Peter Dabrowski wrote:
> > Hi,
> > I just updated my system with Mandriva 2007 which comes with=20
> > Postgresql 8.x. My previous db was postgresql 7.4.4
> > Before rebuilding my system checked with sql-ledger FAQ which=20
> > mention about some problems with older versions.
> > So I done global backup of my db's using pg_dumpall
> > After restoring the dump onto new system and connecting=20
> > Sql-Ledger to it I encountered a problem during trying
> > to create sales order. (it was my first transaction after restore)
> >
> > DBD::Pg::st execute failed: ERROR: column "oid" does not exist
> > Error!
> > SELECT oid AS oid, qty,
> >  (SELECT SUM(qty) FROM inventory
> >  WHERE trans_id =3D 10559
> >  AND orderitems_id =3D ?) AS total
> >  FROM inventory
> >  WHERE trans_id =3D 10559
> >  AND orderitems_id =3D ?
> > ERROR: column "oid" does not exist
> >
> > What will be the best approach in this case to correct this?
> >
> > Thanks
> > Peter
> >
>=20
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>=20
> http://150.101.125.30
>=20
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

>


--=20
Low Prices, Wide Selection of Gas Masks
Everyday low price guarantee. We offer special police discounts and an extr=
emely wide selection of gas masks, filters and huge selection of preparedne=
ss gear.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=3D24e08df2353d2e6cb9bae=
3a0e3c8c61e

Re: [SL] CSV files and importing

[Gerardo R. <gre...@ti...>]

On Wednesday 03 January 2007 11:29, Jeff Roberts wrote:
> Hello People
>
> My name is Jeff and I've been playing with SQL-Ledger for a few years
> but have decided this year I'd get it fully running in my business
> (electronic repair). I've got it installed on a server running BSD 5.3
> with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and
> I've already entered all of my GL accounts in.
>
> My next step is to import my customers, vendors and inventory
> items(services).
>
> I downloaded the import script but it says that I must have my data in
> tab delineated fixed length format and I'm having trouble finding a
> program that will save in fixed length format. My current data is in
> .DBF format and I've tried Paradox and Star Office 6.0 but neither gives
> an option to save in a fixed length. My workstation computers are Linux
> so a solution from EMS is out of the question, any suggestions?

Jeff,

Hello.

You could use dbview to deal with dbf files. I have used it to read xbase 
files and it does a good work converting to csv format.

Personally I do not use BSD, but I can you could take a look to this link to a 
[http://www.freshports.org/databases/dbview/].

Good luck.

Gerardo Reynoso

Re: [SL] Numbers

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

> year 2007
> 2007-<invoice number>

You can easily set the default invoice/order values to combine the year WITH an auto incremented number by using special variables.
I'd give you an example but i don't use this feature.
If i remember correctly, It's all described in the version 2.6 manual under the "Defaults" chapter.
There was a list discussion of this topic a couple months ago. Check the list archives.

Cheers,
Roy P

On Thursday 04 January 2007 1:12 pm, Lenny Leblanc wrote:
> In the System->Defaults screen you can set the starting number for
> pretty much every type of transaction.  This number is incremented prior
> to being used so if you want the first invoice to be 2007-5000 you
> should enter 2007-4999.
> 
> --
> Lenny Leblanc
>  
> 628 Leila Avenue
> Winnipeg, Manitoba  R2V 3N7
> P: 204.338.0233
>  
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> Florian Reitmeir
> Sent: Thursday, January 04, 2007 12:53 PM
> To: sql...@li...
> Subject: [SL] Numbers
> 
> Hi,
> 
> i've to deploy sql-ledger to my company.. and i've read the manual, and
> changed some of the german translations. (if there is some intrest in
> this,
> to whom can i send them?)
> 
> the number, like 'order number', 'Invoice Number', 'Quotation Number' ..
> are
> these generated automatic? or semi automatic? And how can this numbers
> controlled, so is it possible to change/jump number by year? or are
> these
> just counters?
> 
> 
> e.g. we want .. 
> 
> year 2006
> starting by 1000
> 
> year 2007
> starting by 5000
> 
> .
> .
> 
> or
> 
> year 2006 
> 2006-<invoice number>
> 
> year 2007
> 2007-<invoice number>
> .
> .
> 
> I hadn't the time to experiment much (or look into the code),
> so this may be a silly question (and request).
> 

Re: [SL] Numbers

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

In the System->Defaults screen you can set the starting number for
pretty much every type of transaction.  This number is incremented prior
to being used so if you want the first invoice to be 2007-5000 you
should enter 2007-4999.

--
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
Florian Reitmeir
Sent: Thursday, January 04, 2007 12:53 PM
To: sql...@li...
Subject: [SL] Numbers

Hi,

i've to deploy sql-ledger to my company.. and i've read the manual, and
changed some of the german translations. (if there is some intrest in
this,
to whom can i send them?)

the number, like 'order number', 'Invoice Number', 'Quotation Number' ..
are
these generated automatic? or semi automatic? And how can this numbers
controlled, so is it possible to change/jump number by year? or are
these
just counters?


e.g. we want ..=20

year 2006
starting by 1000

year 2007
starting by 5000

.
.

or

year 2006=20
2006-<invoice number>

year 2007
2007-<invoice number>
.
.

I hadn't the time to experiment much (or look into the code),
so this may be a silly question (and request).

--=20
Florian Reitmeir

------------------------------------------------------------------------
-
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] CSV files and importing

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

http://dbf.berlios.de has/had a nice little program that translates DBF
files into PostgreSQL tables directly. One could then do a SELECT INTO
perhaps?

el


on 1/4/07 7:07 PM Jerome J. Auza said the following:
> Hi Jeff,
> 
> Some time ago, I had to deal with .DBF files and I used the Perl modules 
> in this link:  http://search.cpan.org/search?query=DBF&mode=all
> 
> There are more than one option so just try which one fits your need.  
> You might have to write a short script to do this.
> 
> jerome
> 
> Jeff Roberts wrote:
> 
>> Hello People
>>
>> My name is Jeff and I've been playing with SQL-Ledger for a few years 
>> but have decided this year I'd get it fully running in my business 
>> (electronic repair). I've got it installed on a server running BSD 5.3 
>> with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and 
>> I've already entered all of my GL accounts in.
>>
>> My next step is to import my customers, vendors and inventory 
>> items(services).
>>
>> I downloaded the import script but it says that I must have my data in 
>> tab delineated fixed length format and I'm having trouble finding a 
>> program that will save in fixed length format. My current data is in 
>> .DBF format and I've tried Paradox and Star Office 6.0 but neither gives 
>> an option to save in a fixed length. My workstation computers are Linux 
>> so a solution from EMS is out of the question, any suggestions?