sql-ledger-users — SQL-Ledger users

Re: [SL] Moving SQL Ledger from one System to another

[<lh...@pa...>]

Basicly it's just so she can learn how to input everything now.
Not just her daily sales. All her expenses, reciepts and such.
So I want to bring an up to date copy of her data home and
import it there so she can do work on it so she does not mess
anything up.

Steven L'Heureux


> On 火, 2008-01-29 at 09:29 -0500, lh...@pa... wrote:
>> How and what is the prefered method for moving
>> my SQL Ledger Data from my wife's work to her
>> home office?
>>
>> Systems are using Fedora.
>
> One-time thing? If so, do System -> Backup -> Save to file, copy the
> file to the other system, and do restore as explained in the manual.
> That will back up the data base. You should probably tar up and copy
> over the users/ directory.
> --
> Stuart Luppescu -=- slu .at. ccsr.uchicago.edu
> University of Chicago -=- CCSR
> 才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r3
> There is no time like the present for postponing
>  what you ought to be doing.
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> !DSPAM:11,479f3d5e136532958492736!
>
>

Re: [SL] Moving SQL Ledger from one System to another

[Stuart L. <sl...@cc...>]

On =E7=81=AB, 2008-01-29 at 09:29 -0500, lh...@pa... wrote:
> How and what is the prefered method for moving
> my SQL Ledger Data from my wife's work to her
> home office?
>=20
> Systems are using Fedora.

One-time thing? If so, do System -> Backup -> Save to file, copy the
file to the other system, and do restore as explained in the manual.
That will back up the data base. You should probably tar up and copy
over the users/ directory.
--=20
Stuart Luppescu -=3D- slu .at. ccsr.uchicago.edu       =20
University of Chicago -=3D- CCSR=20
=E6=89=8D=E6=96=87=E3=81=A8=E6=99=BA=E5=A5=88=E7=BE=8E=E3=81=AE=E7=88=B6 -=
=3D-    Kernel 2.6.23-gentoo-r3               =20
There is no time like the present for postponing
 what you ought to be doing.=20
=20
=20
=20

[SL] Moving SQL Ledger from one System to another

[<lh...@pa...>]

How and what is the prefered method for moving
my SQL Ledger Data from my wife's work to her
home office?

Systems are using Fedora.

Steven L'Heureux

Re: [SL] How to add Account Description as column in GL and other reports

[Yves L. ing. <yve...@gm...>]

Armaghan Saqib wrote:
> To be fair, SL has reasonably good reporting functionality. You can
> customize reports by selecting which columns you want in the report.
> Sorting and auto-subtotals by sorted columns etc are there too. You
> get such reports on almost all tables.
>   =

Yes you can, but editing and knowledge of perl and sql is required,
which is not for the end user. For example, I need a monthly sales
journal, with all taxes, ordered by date. Not hard to do, but definetely
requiring programmation. Or I need a GL transactions report, grouped by
accounts and sorted by date. Same.

A reporting tool could take care of that and let the user picks his
preferences for Custom Reports, without requiring programming knowledge.

Yves

Re: [SL] How to add Account Description as column in GL and other reports

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

On 1/17/08, Yves Lavoie ing. <yve...@gm...> wrote:
> Armaghan Saqib wrote:
> > As far as I know this is not available in current sql-ledger version.
> > We can request Dieter to  add this in the coming versions of SL. For
> > the time being I have patched my installation for this. You need to
> > edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.
> >
> Reporting has always been painful for designers because everybody wants
> to add this or that or build a special report, just once, ...
>
> IMHO, if we are to ask Dieter to change the current reporting structure,
> it would be more efficient to ask for a way to let the user easily
> customize or build special reports instead of asking for specific
> modifications.

To be fair, SL has reasonably good reporting functionality. You can
customize reports by selecting which columns you want in the report.
Sorting and auto-subtotals by sorted columns etc are there too. You
get such reports on almost all tables.

The rest of the reports which people want will be multi-table reports
requiring understanding of database schema as well as relationships
between tables. A thing hardly any typical end-user can do.

I have made availble on my website a simple perl script which allows
you to build and add reports to sql-ledger if you know some sql. Many
users have downloaded and used it. The problem they still face is how
to write the SQL to pull required information from different tables
and this require reasonable schema understanding.

So I don't think some sort of report writer is going to solve the
reporting issue of end-users unless they learn some SQL and sql-ledger
schema.

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

Free trial available.
--

Re: [SL] version 2.8.11 - error: Premature end of script headers

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

Prem Pradeep wrote:
> After upgrading to SL 2.8.11:
> I can access the admin pages and the login page, but after login this error
> message appears. (Apache 2.2.8)
>  Internal Server Error  The server encountered an internal error or
> misconfiguration and was unable to complete your request.
> The Apache error.log shows this error line:
> Premature end of script headers: login.pl, referer:
> http://wz1:79/sql-ledger/login.pl
> What could be wrong
Seems some sort of permission error on "users" folders. See what tail 
/var/log/httpd/error.log (or something similar) shows right after you 
try to login. Should see which script is failing and why?

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

[SL] version 2.8.11 - error: Premature end of script headers

[Prem P. <pre...@gm...>]

After upgrading to SL 2.8.11:
I can access the admin pages and the login page, but after login this error
message appears. (Apache 2.2.8)
 Internal Server Error  The server encountered an internal error or
misconfiguration and was unable to complete your request.
The Apache error.log shows this error line:
Premature end of script headers: login.pl, referer:
http://wz1:79/sql-ledger/login.pl
What could be wrong?

Thanks
Prem

Re: [SL] Has anyone done any customization to force which account is for customer invoice payments ?

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

Hey Michael !

Yeah.  I previously used this account ID "trick" to help detect when people 
forgot to select the correct chart account for AP and AR transactions (as 
opposed to AR invoice payments). People would forget to select the account 
and it would default to the lowest account id. The problem is, that account 
is actually used and it makes the error hard to find.

I can't remember who 1st suggested it on this list, but  I created an account 
called "PUT ME SOMEWHERE"  with an account ID of 0001, which i then 
configured to show up in all required drop down lists. This way, if any 
amount shows up in that "put me somewhere" account I know that something was 
entered wrong and can easily find it.

Cheers,
Roy

On Friday 18 January 2008, Michael Hasse wrote:
> The drop-down defaults to the first entry and is sorted by account  
> ID.  If you change the account ID of the account which should be  
> default to be lower than the others then it will always be selected  
> automatically.  (Of course if you need different defaults for  
> different areas then this little trick won't help.)
> 
> 
> Thanks,
> 
> Michael
> 
> 
> On Jan 17, 2008, at 7:59 AM, R Pennington wrote:
> 
> > Morning all !
> >
> > It can be a pain when someone enters a payment and selects the  
> > wrong account for the payment
> > Due to the occasional data entry error,  I have always thought it  
> > would be nice to be to have a drop down box for the payment source  
> > and have that autoselect/force which account the payment uses.
> >
> > Examples:
> > Visa --> Visa Holding Account
> > Mastercard  ->  Mastercard Holding Account
> > Cash  ---> Cash Drawer
> > Cheque --> Undeposited Funds
> >
> >
> > I assume it would be fairly easy to hard code  but having it  
> > configurable in the defaults would be nice.
> >
> > Anyone done anything like this ?

Re: [SL] How to add Account Description as column in GL and other reports

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

On 1/17/08, Michael Hasse <mh...@it...> wrote:
> Not to be a twit, but the back end database is open and the layout is
> pretty easy to figure out.  Custom reporting is generally better done
> with something like Crystal Reports or MS-Access or other GUI front
> end...

If anybody wants easy, GUI access to his/her data, this tool will come in handy:

http://phppgadmin.sourceforge.net/

-- 
Best Regards,
Wallace

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

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

> > Can apache has write permission to "users" and "templates" folder and
> > "members" files withing the user folder?
> >
>
> Yes.  However, I noticed something which might be of interest: both of
> those directories are set read, write, execute for owner, and execute only
> for group and all.
>
> Is that the intended permission set?  (0711)
>
If the files/folders are owned by apache, than these are correct.
Otherwise you can try setting them to 0777 and add a new user and let
us know what happened.

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

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

Yes.  However, I noticed something which might be of interest: both of 
those directories are set read, write, execute for owner, and execute only 
for group and all.

Is that the intended permission set?  (0711)

Luke

 On Fri, 18 Jan 2008, Armaghan Saqib wrote:

> Can apache has write permission to "users" and "templates" folder and
> "members" files withing the user folder?
> 
> 

Re: [SL] Has anyone done any customization to force which account is for customer invoice payments ?

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

The drop-down defaults to the first entry and is sorted by account  
ID.  If you change the account ID of the account which should be  
default to be lower than the others then it will always be selected  
automatically.  (Of course if you need different defaults for  
different areas then this little trick won't help.)


Thanks,

Michael


On Jan 17, 2008, at 7:59 AM, R Pennington wrote:

> Morning all !
>
> It can be a pain when someone enters a payment and selects the  
> wrong account for the payment
> Due to the occasional data entry error,  I have always thought it  
> would be nice to be to have a drop down box for the payment source  
> and have that autoselect/force which account the payment uses.
>
> Examples:
> Visa --> Visa Holding Account
> Mastercard  ->  Mastercard Holding Account
> Cash  ---> Cash Drawer
> Cheque --> Undeposited Funds
>
>
> I assume it would be fairly easy to hard code  but having it  
> configurable in the defaults would be nice.
>
> Anyone done anything like this ?
>
>
> -- 
> Roy Pennington
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How to add Account Description as column in GL and other reports

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

Not to be a twit, but the back end database is open and the layout is  
pretty easy to figure out.  Custom reporting is generally better done  
with something like Crystal Reports or MS-Access or other GUI front  
end...


Thanks,

Michael



On Jan 17, 2008, at 6:48 AM, Yves Lavoie ing. wrote:

> Armaghan Saqib wrote:
>> As far as I know this is not available in current sql-ledger version.
>> We can request Dieter to  add this in the coming versions of SL. For
>> the time being I have patched my installation for this. You need to
>> edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.
>>
> Reporting has always been painful for designers because everybody  
> wants
> to add this or that or build a special report, just once, ...
>
> IMHO, if we are to ask Dieter to change the current reporting  
> structure,
> it would be more efficient to ask for a way to let the user easily
> customize or build special reports instead of asking for specific
> modifications.
>
> Regards,
>
> Yves
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

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

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

Can apache has write permission to "users" and "templates" folder and
"members" files withing the user folder?

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

Free trial available.
--

On 1/18/08, Luke <sl...@li...> wrote:
> 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.
>
> All other things appear to be working.
>
> Luke

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.

All other things appear to be working.

Luke

[SL] Has anyone done any customization to force which account is for customer invoice payments ?

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

Morning all !

It can be a pain when someone enters a payment and selects the wrong account for the payment
Due to the occasional data entry error,  I have always thought it would be nice to be to have a drop down box for the payment source and have that autoselect/force which account the payment uses.

Examples:
Visa --> Visa Holding Account
Mastercard  ->  Mastercard Holding Account
Cash  ---> Cash Drawer
Cheque --> Undeposited Funds


I assume it would be fairly easy to hard code  but having it configurable in the defaults would be nice.

Anyone done anything like this ?


-- 
Roy Pennington

[SL] Any progress in the dealing with rounding and calculation point related mismatch of vendor invoices ?

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

Morning all !

Question related to AP Invoices:

If you have a vendor who has software where tax is calculated on the line item 
vs the total (or the other way around), due to rounding.... you can have a 
difference betweenwhat the vendor's invoice shows for tax, and what 
SQL-Ledger calculates.

The solution previously recommended was to create 2 service items (one taxable 
and one not) and add them to SQL-ledger's vendor invoice with offsetting 
negative and positive quantities there by increasing/decreasing only the 
specific tax portion of the invoice.

Any solution in the current version ? Can we override the tax on "AP invoices"  
yet (like you can do with "AP Transactions") ?
Any better way to handle this now ?

-- 
Roy P

Re: [SL] Rounding Error or Human Error?

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

On Tuesday 01 January 2008, Luke wrote:
> Hello
> 
> I have an invoice which appears to be calculating the discount 
> incorrectly.
> 
> The line item cost is $2.95 (sellprice--the list price is $2.99, and I 
> lowered this on the invoice to compensate for another seeming error).
> 
> Setting the discount to 10, with a quantity of 12, yealds a cost of 
> $31.80, while my calculater seems to think that it should equal $31.86.
> 
> SL 2.8.10; PGSQL 8.2.
> 
> Am I missing something obvious here?
> 
> Luke

Hello Luke

Yup you are missing something...

This is because the total amount depends on where, in the process, the discount is applied (combined with the resulting rounding)

For example... if you calculate (and round if needed) the  line total.... and then calculate the discount on that line total...as you are doing...
(item price * quantity) * discount
2.95*12 = 35.40 (round to 35.40)
35.40 * 0.90 = $31.86

whereas SQL-ledger is applying the discount to the single item....rounding that to the nearest cent if needed..... and then generating a line total.
(This method makes sense since you would usually  discount the actual item price not the total)

$2.95 * 0.90 =$2.655  (round to $2.65)
2.65 * 12 = $31.80


Rounding can be a pain but unfortunately it's part of the hassle when you have math that doesn't come out to exact cents.


Cheers,
Roy Pennington

Re: [SL] How to add Account Description as column in GL and other reports

[Yves L. ing. <yve...@gm...>]

Armaghan Saqib wrote:
> As far as I know this is not available in current sql-ledger version.
> We can request Dieter to  add this in the coming versions of SL. For
> the time being I have patched my installation for this. You need to
> edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.
>   =

Reporting has always been painful for designers because everybody wants
to add this or that or build a special report, just once, ...

IMHO, if we are to ask Dieter to change the current reporting structure,
it would be more efficient to ask for a way to let the user easily
customize or build special reports instead of asking for specific
modifications.

Regards,

Yves

Re: [SL] How to add Account Description as column in GL and other reports

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

As far as I know this is not available in current sql-ledger version.
We can request Dieter to  add this in the coming versions of SL. For
the time being I have patched my installation for this. You need to
edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.

In GL.pm, you add something like following in $query (sub
transactions). Put this in all three queries comprising UNION.
                 c.description AS accdescription,

In bin/mozilla/gl, follow 'accno' and add similar code for accdescription.

Let me know if you can't do it and I shall send you my patched gl.pl
and GL.pm files (for 2.8.11)

Regards


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

Free trial available.
--

On 1/17/08, Prem Pradeep <pre...@gm...> wrote:
> I need to provide a lot of reporting and the readers of the reports want a
> column added to all sql-ledger reports that show the account description.
> How could I accomplish this in sql-ledger?
>
> thanks
> Prem
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] How to add Account Description as column in GL and other reports

[Prem P. <pre...@gm...>]

I need to provide a lot of reporting and the readers of the reports want a
column added to all sql-ledger reports that show the account description.
How could I accomplish this in sql-ledger?

thanks
Prem

Re: [SL] Rounding Error or Human Error?

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

On Tuesday 01 January 2008, Luke wrote:
> Hello
> 
> I have an invoice which appears to be calculating the discount 
> incorrectly.
> 
> The line item cost is $2.95 (sellprice--the list price is $2.99, and I 
> lowered this on the invoice to compensate for another seeming error).
> 
> Setting the discount to 10, with a quantity of 12, yealds a cost of 
> $31.80, while my calculater seems to think that it should equal $31.86.
> 
> SL 2.8.10; PGSQL 8.2.
> 
> Am I missing something obvious here?
> 
> Luke

Hello Luke

Yup you are missing something...

This is because the total amount depends on where, in the process, the discount is applied (combined with the resulting rounding)

For example... if you calculate (and round if needed) the  line total.... and then calculate the discount on that line total...as you are doing...
(item price * quantity) * discount
2.95*12 = 35.40 (round to 35.40)
35.40 * 0.90 = $31.86

whereas SQL-ledger is applying the discount to the single item....rounding that to the nearest cent if needed..... and then generating a line total.
(This method makes sense since you would usually  discount the actual item price not the total)

$2.95 * 0.90 =$2.655  (round to $2.65)
2.65 * 12 = $31.80


Rounding can be a pain but unfortunately it's part of the hassle when you have math that doesn't come out to exact cents.


Cheers,
Roy Pennington

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

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

Here is a code snippet using SL API to renumber customers (or
invoices, vendors, gl trans or anything with minor change).

**** WARNING: Use at your own risk. All existing disclaimers apply. ****

To use it:

(1) Create bin/mozilla/custom_ct.pl with following code.

### Perl code starts here
1;

sub renumber {

   $form->header;
   my $dbh = $form->dbconnect(\%myconfig);
   my $query = qq|SELECT id, name FROM customer ORDER BY name|;
   my $sth = $dbh->prepare($query);
   $sth->execute or $form->dberror($query);
   my $updatequery = qq|UPDATE customer SET customernumber = ? WHERE id = ?|;
   my $updatesth = $dbh->prepare($updatequery);
   while ($ref = $sth->fetchrow_hashref(NAME_lc)){
        $form->{customernumber} = $form->update_defaults($myconfig,
"customernumber", $dbh);
        $updatesth->execute($form->{customernumber}, $ref->{id});
        print qq|$form->{customernumber} assigned to $ref->{name}<br>|;

   }
   $dbh->disconnect;

}
### Perl code ends here

(2) Put this in custom_menu.ini

[Renumber Customers]]
module=ct.pl
action=renumber

(3) Setup the number to start with minus 1 in system defaults

(4) Click "Renumber customers" in menu.

All customers will be renumbered and new customer number will start
automatically from last one generatd.

To clarify anything contact me.

Regards

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


--
On 1/15/08, Andrew @ ATM Logic <atm...@km...> wrote:
> Yes, they are entering them manually...   Going from MYOB to SL, I think I
> just did not have clear enough instructions on how to export from MYOB and
> import to SL.
>
> If I had this in Black and White I may be able to do it, however... even
> with the manual... this seems to be something that is not that straight
> forward.
>
> In any case, they have staff that are doing this in spare time...
>
>
> ---Andrew
> ATM Logic
>
>
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On
> > Behalf Of Michael Hasse
> > Sent: Tuesday, January 15, 2008 1:23 AM
> > To: sql...@li...
> > Subject: Re: [SL] How to renumber all customers, then "start"
> > the numbering?
> >
> > They're entering them manually...?!?
> >
> >
> > Thanks,
> >
> > Michael
> >
> >
> > On Jan 14, 2008, at 9:52 PM, Andrew @ ATM Logic wrote:
> >
> > > 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

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

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

Yes, they are entering them manually...   Going from MYOB to SL, I think I
just did not have clear enough instructions on how to export from MYOB and
import to SL.

If I had this in Black and White I may be able to do it, however... even
with the manual... this seems to be something that is not that straight
forward.

In any case, they have staff that are doing this in spare time...


---Andrew
ATM Logic
 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Michael Hasse
> Sent: Tuesday, January 15, 2008 1:23 AM
> To: sql...@li...
> Subject: Re: [SL] How to renumber all customers, then "start" 
> the numbering?
> 
> They're entering them manually...?!?
> 
> 
> Thanks,
> 
> Michael
> 
> 
> On Jan 14, 2008, at 9:52 PM, Andrew @ ATM Logic wrote:
> 
> > 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
> > 
> ----------------------------------------------------------------------
> > ---
> > 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.n
> et/marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

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

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

They're entering them manually...?!?


Thanks,

Michael


On Jan 14, 2008, at 9:52 PM, Andrew @ ATM Logic wrote:

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