sql-ledger-users — SQL-Ledger users

[SL] Need compiled DBD for windows

[Nefnifi, K. <Kas...@at...>]

Need compiled DBD for windows, the link naar Edmund Mergl site is not =
okay should deleted from the site of sql-ledger.

Any one give atip

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem NEFNIFI
AtosOrigin Belux N.V.
Da Vincilaan, 5
1930 Zaventem (Belgium)
Tel : +32(0)2 690 28 30
Fax : +32(0)2 690 28 61
GSM : +32 495 25 12 33
Email : kas...@at... =20
www.atosorigin.com

Re: [SL] Setting a start balance for bank account in 2.8.7?

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you use the program to reconcile the bank account - you will also
have to factor in those checks that were written in the previous year
and are still outstanding in the subsequent period. Simply adjust your
journal entry to reflect those checks separately.

www.joemaffia.com



Tariq Khokhar wrote:
> Hi All,
>
> I can't believe I've not had to do this before:
>
> Is there a way to set the starting balance for a bank account ?
>
> For example, if I want to set the start balance (for a 1060 checking
> account) to =A310,000 to reflect the beginning of a new accounting year
> using a new accounting system.
>
> Thanks,
>
> tk
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFGyQj01Zo2InkR90QRAqbxAJ9uZAQIRdWKlpoXApg/DVvzwQfhVwCfeFdF
fQ8VN8pT8eNchqdpiK8/Z2I=3D
=3D2pVf
-----END PGP SIGNATURE-----

[SL] Sales Orders -> Invoices

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

Since 2.8.7 I noticed that the Due Date is not updated when I generate
an invoice from a Sales Order. After pushing Update it is however
corrected.

It is quite annyoing when the Due Date is in the past...

Is this a bug or a feature?


I also note, and since many versions, that the CC address, is not
taken over to the Invoice, so I have to type it manually (FFox remembers
typed entries of forms, but since I have many it's counter productive).
Pushing Update does not help, but if I change the Customer (in the
Invoice) it works (but not if I change in the Sales Order).

Bug or a feature?

greetings, el

Re: [SL] Setting a start balance for bank account in 2.8.7?

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

Enter an opening balance via Journal Entry, quite S.O.P. for any accounting
package.
Do not forget to treat A/P, A/R and any inventory by entering invoice(s) as
stated in the documentation!

2007/8/16, Tariq Khokhar <ta...@kh...>:
>
> Hi All,
>
> I can't believe I've not had to do this before:
>
> Is there a way to set the starting balance for a bank account ?
>
> For example, if I want to set the start balance (for a 1060 checking
> account) to =A310,000 to reflect the beginning of a new accounting year
> using a new accounting system.
>
> Thanks,
>
> tk
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] Setting a start balance for bank account in 2.8.7?

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

This has been discussed here before.

el

on 8/16/07 10:52 PM Rich Shepard said the following:
> On Fri, 17 Aug 2007, David J wrote:
> 
>> Wot.
>> No other assets or liabilities needed ?
>> Nothing owing or owed ?
>> No comparative balances from previous year ?
>> Definitely talk to your accountant.
> 
>    IIRC, the original question was how to insert a starting balance into a
> bank account using a new financial accounting application. Nothing was asked
> about a Chart of Accounts (which the business' accountant should define) or
> initial balances in any other accounts.
> 
> Rich
> 

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

Re: [SL] Setting a start balance for bank account in 2.8.7?

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

On Fri, 17 Aug 2007, David J wrote:

> Wot.
> No other assets or liabilities needed ?
> Nothing owing or owed ?
> No comparative balances from previous year ?
> Definitely talk to your accountant.

   IIRC, the original question was how to insert a starting balance into a
bank account using a new financial accounting application. Nothing was asked
about a Chart of Accounts (which the business' accountant should define) or
initial balances in any other accounts.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Setting a start balance for bank account in 2.8.7?

[David J <ja...@in...>]

Wot.
No other assets or liabilities needed ?
Nothing owing or owed ?
No comparative balances from previous year ?
Definitely talk to your accountant.

> On Thu, 16 Aug 2007, Rich Shepard wrote:
> 
> >   Sure. Credit the checking/savings account and debit an
> > equity account. Or, ask your accountant how she prefers
> to have the credit side handled.
> 
>    I'm sorry; must not be fully cafinated yet. The bank
> account should be _debited_ to increase the balance, and
> the equity account should be _credited_.
> 
> Mea culpa!
> 
> Rich
>

Re: [SL] Setting a start balance for bank account in 2.8.7?

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

On Thu, 16 Aug 2007, Rich Shepard wrote:

>   Sure. Credit the checking/savings account and debit an equity account.
> Or, ask your accountant how she prefers to have the credit side handled.

   I'm sorry; must not be fully cafinated yet. The bank account should be
_debited_ to increase the balance, and the equity account should be
_credited_.

Mea culpa!

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Setting a start balance for bank account in 2.8.7?

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

On Thu, 16 Aug 2007, Tariq Khokhar wrote:

> Is there a way to set the starting balance for a bank account ?

   Sure. Credit the checking/savings account and debit an equity account. Or,
ask your accountant how she prefers to have the credit side handled.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Setting a start balance for bank account in 2.8.7?

[Tariq K. <ta...@kh...>]

Hi All,

I can't believe I've not had to do this before:

Is there a way to set the starting balance for a bank account ?

For example, if I want to set the start balance (for a 1060 checking
account) to =A310,000 to reflect the beginning of a new accounting year
using a new accounting system.

Thanks,

tk

Re: [SL] Software installer

[Sergio J R. <ru...@sb...>]

Waukesha, WI USA
Bob Gustafson wrote:
> It might be a good idea to get someone locally.
>
> Where in the world are you?
>
> Bob G
>
> On Wed, 2007-08-15 at 09:56 -0500, Sergio J Ruiz wrote:
>   
>> Well, sorry about my confusing English. And yes, I think it's a 
>> consultant what we need.
>>
>> We have Quickbooks right now, but we outgrown it, and need something 
>> with client-server infrastructure and with more licenses. We will need, 
>> of course, help moving the information from Quickbooks to SQL-Ledger, 
>> and training.
>>
>>
>>
>>
>>
>> Adam Vande More wrote:
>>     
>>> On 8/15/07, Sergio J Ruiz <ru...@sb...> wrote:
>>>   
>>>       
>>>> Hi folks,
>>>>   Do you guys know about any company that provides services using
>>>> sql-ledger.
>>>>     
>>>>         
>>> I'm not clear on the questions.  Are asking for a consultant to help
>>> you get setup, or are asking can SL handle a service based business?
>>>
>>> Some consultant are listed on sql-ledger.org and yes services are handled.
>>>
>>>   
>>>       
>>>> At my organization, we are trying to leave Quickbooks
>>>> behind, but I don't want to go Microsoft. Maybe you know about any
>>>> accounting software hosted on Linux?
>>>>     
>>>>         
>>> SL will run under many OS's, however the migration is non-trivial.
>>>
>>>   
>>>       
>>>>   By the way, we are a non-for-profit organization, so we would need
>>>> things like grant management and so.
>>>>     
>>>>         
>>> This would be something that would be worth hiring a knowledgeable
>>> consultant for.  SL is powerful and flexible, but it doesn't do
>>> everything.
>>>
>>>   
>>>       
>>>> Thank you in advance,
>>>>
>>>> Sergio
>>>>
>>>> -------------------------------------------------------------------------
>>>> This SF.net email is sponsored by: Splunk Inc.
>>>> Still grepping through log files to find problems?  Stop.
>>>> Now Search log events and configuration files using AJAX and a browser.
>>>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>
>>>>     
>>>>         
>>>
>>>   
>>>       
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Software installer

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

It might be a good idea to get someone locally.

Where in the world are you?

Bob G

On Wed, 2007-08-15 at 09:56 -0500, Sergio J Ruiz wrote:
> Well, sorry about my confusing English. And yes, I think it's a 
> consultant what we need.
> 
> We have Quickbooks right now, but we outgrown it, and need something 
> with client-server infrastructure and with more licenses. We will need, 
> of course, help moving the information from Quickbooks to SQL-Ledger, 
> and training.
> 
> 
> 
> 
> 
> Adam Vande More wrote:
> > On 8/15/07, Sergio J Ruiz <ru...@sb...> wrote:
> >   
> >> Hi folks,
> >>   Do you guys know about any company that provides services using
> >> sql-ledger.
> >>     
> >
> > I'm not clear on the questions.  Are asking for a consultant to help
> > you get setup, or are asking can SL handle a service based business?
> >
> > Some consultant are listed on sql-ledger.org and yes services are handled.
> >
> >   
> >> At my organization, we are trying to leave Quickbooks
> >> behind, but I don't want to go Microsoft. Maybe you know about any
> >> accounting software hosted on Linux?
> >>     
> >
> > SL will run under many OS's, however the migration is non-trivial.
> >
> >   
> >>   By the way, we are a non-for-profit organization, so we would need
> >> things like grant management and so.
> >>     
> >
> > This would be something that would be worth hiring a knowledgeable
> > consultant for.  SL is powerful and flexible, but it doesn't do
> > everything.
> >
> >   
> >> Thank you in advance,
> >>
> >> Sergio
> >>
> >> -------------------------------------------------------------------------
> >> This SF.net email is sponsored by: Splunk Inc.
> >> Still grepping through log files to find problems?  Stop.
> >> Now Search log events and configuration files using AJAX and a browser.
> >> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>     
> >
> >
> >
> >   
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Software installer

[Sergio J R. <ru...@sb...>]

Well, sorry about my confusing English. And yes, I think it's a 
consultant what we need.

We have Quickbooks right now, but we outgrown it, and need something 
with client-server infrastructure and with more licenses. We will need, 
of course, help moving the information from Quickbooks to SQL-Ledger, 
and training.





Adam Vande More wrote:
> On 8/15/07, Sergio J Ruiz <ru...@sb...> wrote:
>   
>> Hi folks,
>>   Do you guys know about any company that provides services using
>> sql-ledger.
>>     
>
> I'm not clear on the questions.  Are asking for a consultant to help
> you get setup, or are asking can SL handle a service based business?
>
> Some consultant are listed on sql-ledger.org and yes services are handled.
>
>   
>> At my organization, we are trying to leave Quickbooks
>> behind, but I don't want to go Microsoft. Maybe you know about any
>> accounting software hosted on Linux?
>>     
>
> SL will run under many OS's, however the migration is non-trivial.
>
>   
>>   By the way, we are a non-for-profit organization, so we would need
>> things like grant management and so.
>>     
>
> This would be something that would be worth hiring a knowledgeable
> consultant for.  SL is powerful and flexible, but it doesn't do
> everything.
>
>   
>> Thank you in advance,
>>
>> Sergio
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>     
>
>
>
>   

Re: [SL] Software installer

[Adam V. M. <amv...@gm...>]

On 8/15/07, Sergio J Ruiz <ru...@sb...> wrote:
> Hi folks,
>   Do you guys know about any company that provides services using
> sql-ledger.

I'm not clear on the questions.  Are asking for a consultant to help
you get setup, or are asking can SL handle a service based business?

Some consultant are listed on sql-ledger.org and yes services are handled.

> At my organization, we are trying to leave Quickbooks
> behind, but I don't want to go Microsoft. Maybe you know about any
> accounting software hosted on Linux?

SL will run under many OS's, however the migration is non-trivial.

>   By the way, we are a non-for-profit organization, so we would need
> things like grant management and so.

This would be something that would be worth hiring a knowledgeable
consultant for.  SL is powerful and flexible, but it doesn't do
everything.

> Thank you in advance,
>
> Sergio
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

[SL] Software installer

[Sergio J R. <ru...@sb...>]

Hi folks,
  Do you guys know about any company that provides services using 
sql-ledger. At my organization, we are trying to leave Quickbooks 
behind, but I don't want to go Microsoft. Maybe you know about any 
accounting software hosted on Linux?

  By the way, we are a non-for-profit organization, so we would need 
things like grant management and so.

Thank you in advance,

Sergio

Re: [SL] What happened to Delivery Date and Serial No?

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

Hi Colin,

There is a check mark next to description field. If you check it and
click update, a second line will be displayed where you can enter
delivery date and other information.

This works only after you have entered an item in the 'Number' field.

Let me know if you need additional explanation.

Regards
Armaghan Saqib
http://www.ledger123.com/


On 8/11/07, Colin Manning <co...@it...> wrote:
> Anyone? Please....
>
> Colin Manning wrote:
> > Hi All,
> >
> > I have been happily using SL 2.6.19 for some time now, and decided that
> > I would update to 2.8.6.
> >
> > All went well, until I wanted to send my first invoice, when I noticed
> > that I could not include a delivery date. How can I turn this back on?
> > (and serial numbers)
> >
>
> --
> Regards,
>
> *Colin Manning* B Sc.
>
> /Computer service, sales and support./
> I.T. Navigate Pty Ltd
> Phone: (08) 9574 0200
> Mobile: 0412 384 242
> ABN:61 108 296 288
>
> <http://www.itnavigate.com.au>
> www.itnavigate.com.au <http://www.itnavigate.com.au>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] What happened to Delivery Date and Serial No?

[Colin M. <co...@it...>]

Anyone? Please....

Colin Manning wrote:
> Hi All,
>
> I have been happily using SL 2.6.19 for some time now, and decided that 
> I would update to 2.8.6.
>
> All went well, until I wanted to send my first invoice, when I noticed 
> that I could not include a delivery date. How can I turn this back on? 
> (and serial numbers)
>   

-- 
Regards,

*Colin Manning* B Sc.

/Computer service, sales and support./
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN:61 108 296 288

<http://www.itnavigate.com.au>
www.itnavigate.com.au <http://www.itnavigate.com.au>

Re: [SL] Problems with upgrade to 2.8.7

[Pontius <po...@po...>]

On Wednesday 08 August 2007 02:06, Rob van den Berg wrote:
> got sort of the same issue here
> First I got this :
>
> Upgrading to Version 2.8.7 ...
> Error!
> insert into curr (curr,precision) select distinct curr, 2 from ar union
> select distinct curr, 2 from ap union se
> (I think the message was longer but the rest of the message got lost)

I regards to the first part of your message, we had a similar problem. It 
seems that this SQL command tries to build a new table called curr and fills 
it with all distinct currencies it will find in the respective curr column in 
ar, ap, gl and oe.  If one of them is NULL, there will be a not-null 
contraint error.  Find your NULL in these tables and change it to a valid 
currency symbol.

Hope this helps.

Marc St-Jacques

-- 
Pontius Livres-Books-Buecher
10837 Saint Hubert
Montreal  QC   H2C 2J3
Canada
Tel.  514-389-8115
Fax   514-383-2755
Courriel: po...@po...
Internet: www.pontius.ca

Re: [SL] Problems with upgrade to 2.8.7

[Rob v. d. B. <rgh...@gm...>]

got sort of the same issue here
First I got this :

Upgrading to Version 2.8.7 ...
Error!
insert into curr (curr,precision) select distinct curr, 2 from ar union
select distinct curr, 2 from ap union se
(I think the message was longer but the rest of the message got lost)

Then the system was locked (unable to log in)
After unlocking it through admin.pl I get

Upgrading to Version 2.8.7 ...
Error!
alter table semaphore add expires varchar(10)
ERROR:  column "expires" of relation "semaphore" already exists


Rob

2007/8/6, Glen Morris <gl...@au...>:
>
> After upgrading to 2.8.7 from 2.8.6 I'm getting this error on just one
> of my databases:
>
> Upgrading to Version 2.8.7 ...
> Error!
>
> alter table semaphore add expires varchar(10)
> ERROR: column "expires" of relation "semaphore" already exists
>
> The others upgraded without a hitch.
>
> Glen
>
> --
> Glen Morris: Arachnoid Australia
> 613 90175780 Melbourne | 612 90164032 Sydney
> 613 98961811 VoIP | Mbl 0419299140
> Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] What happened to Delivery Date and Serial No?

[Colin M. <co...@it...>]

Hi All,

I have been happily using SL 2.6.19 for some time now, and decided that =

I would update to 2.8.6.

All went well, until I wanted to send my first invoice, when I noticed =

that I could not include a delivery date. How can I turn this back on? =

(and serial numbers)
-- =

Regards,

*Colin Manning* B Sc.

/Computer service, sales and support./
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN:61 108 296 288

<http://www.itnavigate.com.au>
www.itnavigate.com.au <http://www.itnavigate.com.au>

Re: [SL] Extending financial year

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

On Tue, 7 Aug 2007, Greg Bolshaw wrote:

> Dear list
>
> Here in the UK, when a new company is formed, the end of year date is
> automatically set to the last day of the month in which the company was
> created. We have the option to make a one-off change to this date so
> that it falls inline with another tax deadline or the calendar year.
> This change is made by either reducing or extending the length of the
> first financial year accordingly.
>
> I have extended the period of my company's first financial year to 17
> months. My question is, how do I account for this in SQL Ledger? Is
> there anything that I need to consider?

Your financial year may span over any period, it does not have to be a 
year.

[SL] Extending financial year

[Greg B. <gr...@bo...>]

Dear list

Here in the UK, when a new company is formed, the end of year date is 
automatically set to the last day of the month in which the company was 
created. We have the option to make a one-off change to this date so 
that it falls inline with another tax deadline or the calendar year. 
This change is made by either reducing or extending the length of the 
first financial year accordingly.

I have extended the period of my company's first financial year to 17 
months. My question is, how do I account for this in SQL Ledger? Is 
there anything that I need to consider?

Many thanks
Greg Bolshaw

Re: [SL] Rental Apartments == Parts ??

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

Having them defined as a service vs parts shouldn't affect the  
reporting options any but should help with managing "inventory" in  
the case where somebody ends being credited a half-day or similar  
bizarreness.


Thanks,

Michael


On Aug 5, 2007, at 10:29 PM, Bob Gustafson wrote:

> Thanks for all your comments.
>
> I am drawn to the idea of a one day time unit. This way, it would be
> easier to have a daily report - P&L in the morning sort of thing,
> without fiddling with partially expired rental periods of longer than
> one day. A week rental just means an order for 7 parts - with part
> numbers coding the particular date of each (future) day rental.
>
> The P&L in the middle of that week would figure 3 or 4 sold parts  
> and 4
> or 3 on order, for delivery once a day.
>
> Bob G
>
> On Sun, 2007-08-05 at 07:20 -0700, Rich Shepard wrote:
>> On Sun, 5 Aug 2007, Michael Hasse wrote:
>>
>>> Seems to me this might work better using the Projects functionality
>>> of SL.
>>
>>    I agree. I had seen the subject line before, but not read the  
>> thread until
>> now. Each vacation unit would be a separate project, with its own  
>> number.
>> If there's the potential for additional property to be managed,  
>> then the
>> project number could have two digits (for example), a decimal  
>> point, and
>> three digits. This would accommodate 99 separate properties, each  
>> with a
>> maximum of 999 units.
>>
>>>    One could define the apartments as either services or as  
>>> personnel,
>>> (not sure which would be more appropriate, probably personnel),  
>>> and each
>>> rental period would be a "project".
>>
>>    The services would be standard rental times; for example, 1  
>> week, 2 weeks,
>> 1 month, 3 months, etc. This makes them consistent and the  
>> reporting easier
>> to track.
>>
>> Just my 25-cents' worth (inflation, you know).
>>
>> Rich
>>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a  
> browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Rental Apartments == Parts ??

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

Thanks for all your comments.

I am drawn to the idea of a one day time unit. This way, it would be
easier to have a daily report - P&L in the morning sort of thing,
without fiddling with partially expired rental periods of longer than
one day. A week rental just means an order for 7 parts - with part
numbers coding the particular date of each (future) day rental.

The P&L in the middle of that week would figure 3 or 4 sold parts and 4
or 3 on order, for delivery once a day.

Bob G

On Sun, 2007-08-05 at 07:20 -0700, Rich Shepard wrote:
> On Sun, 5 Aug 2007, Michael Hasse wrote:
> 
> > Seems to me this might work better using the Projects functionality
> > of SL.
> 
>    I agree. I had seen the subject line before, but not read the thread until
> now. Each vacation unit would be a separate project, with its own number.
> If there's the potential for additional property to be managed, then the
> project number could have two digits (for example), a decimal point, and
> three digits. This would accommodate 99 separate properties, each with a
> maximum of 999 units.
> 
> >    One could define the apartments as either services or as personnel,
> > (not sure which would be more appropriate, probably personnel), and each
> > rental period would be a "project".
> 
>    The services would be standard rental times; for example, 1 week, 2 weeks,
> 1 month, 3 months, etc. This makes them consistent and the reporting easier
> to track.
> 
> Just my 25-cents' worth (inflation, you know).
> 
> Rich
> 

[SL] Problems with upgrade to 2.8.7

[Glen M. <gl...@au...>]

After upgrading to 2.8.7 from 2.8.6 I'm getting this error on just one
of my databases:

Upgrading to Version 2.8.7 ...
Error!

alter table semaphore add expires varchar(10)
ERROR: column "expires" of relation "semaphore" already exists

The others upgraded without a hitch.

Glen

-- 
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia