[Ledger-smb-users] Great work... and a question
Hi all, I stumbled on LedgerSMB last week and I've been playing around with it since then (when, admittedly, I should have been doing other things. Bad Richard. No cookie). I currently use WebERP, which has a great interface, but I find it somewhat lacking in the features that I need. Having found LedgerSMB, I have found an actively developed project that seems to have, or be working on, the things I want in an accounts system (although I'm less fond of the web interface - but I'll get used to it). After only a week of gleefully pressing buttons, I'm largely sold despite my unfamiliarity with postgres and my dislike of perl. This evening, I started putting some proper data into the system (I'm using 1.2.2), using live data from the WebERP system. I figure if I can get 12 months of data, warts and all, into LedgerSMB - and get the same end of year accounts out of both systems - I will be happy moving across. This is when I hit upon my first snag: credit notes. I have credit notes that we issue and supplier credit notes to enter into the system, and I can't see a nice way of doing it, short of a manual GL transaction (which is doable for receiving supplier credit notes, but less useful for issuing our own). So my question: is there a credit note facility that I have overlooked, or is there a plan to add this functionality in the near future? Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - 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 ___ Ledger-smb-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Great work... and a question
Thanks Chris. Quoting Chris Travers <[EMAIL PROTECTED]>: > Don't worry about the interface. We are working on getting it to the > point where the interface can be redesigned properly. Heh, no problem. It's not THAT bad, just a bit clunky in places. It's certainly usable. Anyway, I will choose function over form any day. > We are working on credit notes. Expect them in 1.3.0 > > In the mean time, you may be able to handle it as a prepayment, > depending on your needs (against a different account, naturally). When do you expect 1.3.0 to be unleashed on the world? I think that the only thing I really need to see is the receiving and issuing of credit notes. Our FY ends 31st August, so it would be nice to start the new FY with a new system if I can. I'm not a perl programmer (if I had my way, everything would be written in FORTRAN) but I'll be happy to help in any way I can, with testing and the like. What the open source world needs is a good financials package. My particular skills are project management, compilers and Oracle, if you can make use of any of them. I also make tea. Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - 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 ___ Ledger-smb-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Great work... and a question
Quoting Chris Travers <[EMAIL PROTECTED]>: > On 4/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I think I am still traumatized by the memory of FORTRAN 77. I started with '77, but FORTRAN 90 is my mother duck, as 'twere. You need to embrace the fear. After you go numb, it doesn't hurt so much. FORTRAN 2003 introduces OO features. That is both bad and wrong, although not as wrong as OOCOBOL, which makes my mind break just to think about. > Actually If you can write PL/SQL, learning PL/PGSQL is not a far > step. Our new architecture is going to be very stored procedure > based. You may find that a good chunk of the app may be within your > domain. Again, that is largely what we are working on for 1.3.0. Oh that's interesting. I like that approach. I do know PL/SQL, although these days I mostly only write it under duress or the promise of alcohol. I will take some more time to get to know Postgres. I have some free time coming up in May/June, and I may well take that opportunity to get up close and personal with it. I have various ideas and suggestions for things that I would like to see in LedgerSMB, but I'll read through the mailing list archives first, to see what has been discussed. Only, not right now. I notice that it is 3am, and my alarm is set for 8... Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - 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 ___ Ledger-smb-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Default dates on transaction entry screens
I like option B. The session date could default to the current system
date on login, but also remember the last date entered for a
transaction, and use that as the default for the next transaction.
I will often enter a batch of transactions at one sitting, comprising
3 or 4 different transaction dates. This feature would be very useful
for me. If I had a penny for every time I've entered a transaction on
the wrong date and had to reverse and re-do, I'd have... £2.37.
Cheers,
Richard
Quoting Roy Nicholl <[EMAIL PROTECTED]>:
> Obviously my choice of words to describe the capability was neither
> sufficiently clear nor complete.
>
> Setting a transaction date on a per session basis is no more of a
> kludge than setting a global default ... and neither should have any
> impact on the security of the system [non-repudiation requirements
> should necessitate an internal audit control {i.e. audit trail of
> user actions ... in particular those which affect change on data
> stored in the system} which is internal to the system and beyond the
> reach of the user].
>
> In fact you could probably combine the features of a global, or per
> user, setting that give the user a choice of, say, a) using the
> current, system date, for entry of new transactions; b) the default
> date for new transactions is the date of the last transaction
> inputted into the system; or c) the user is prompted for the
> transaction entry date (i.e. session date) at login.
>
> ... just more fuel for discussion,
>
> Roy
>
> On 15-Apr-2007, at 00:59, David Tangye wrote:
>
>> On Fri, 2007-04-13 at 07:39 -0300, Roy Nicholl wrote:
>>> One of the commercial accounting packages I used years ago (simply/
>>> accpac?) would prompt you to set the "session date" when you ran it/
>>> logged on. The offered default was the current system date (simply
>>> hit return and it was yours). This allowed you to change the date
>>> for initial data entry during that session. I cannot recall if each
>>> new transaction defaulted to the selected session date of the date of
>>> the previously submitted transaction.
>> That's a similar idea, except its a bit of the kludge to virtually
>> transport you to a past date in entirety, when all you want to do is
>> enter some transactions for a past range of dates, eg 'catching up
>> a bit
>> on the books'. You should be able to still run reports, etc and not
>> have
>> all dates in the app as though you were doing it another day. Actually
>> our security-conscious guys might look dimly at this sort of facility,
>> although an audit trail of the date change might placate them.
>>
>> Further discussion might be best at sourceforge: [ 1700856 ]
>> User-preference for default date value in data
>> entry screens
>> http://sourceforge.net/tracker/index.php?
>> func=detail&aid=1700856&group_id=175965&atid=875353
>>
>>
>>
>> --
>> ---
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
> !DSPAM:3,4622956e45321804284693!
>
>
This message was sent using IMP, the Internet Messaging Program.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Great work... and a question
Quoting Chris Travers <[EMAIL PROTECTED]>: > Well, I am sure that if we ask enough people, we will get offers to > contribute in any language from LISP to Ruby. > OO COBOL!!! (Said Richard, who is currently on holiday and still checking his email.) This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Poll of users
Good idea. > How important to you is the use of PostgreSQL in the software? 3 > How important to you is the software being browser based? 5 > How important to you is the use of Perl in the software? 1 > How many users do you have - 1,2,3,4 or 5+? 3 > How important to you is ease of installation of the software? 3 > How important to you is security of the software? 5 > How important to you is an active user/support list/forum? 3 > How important to you is commercial support of the software? 3 This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Tax rounding error in 1.2.4
Hi all,
I've just loaded the first invoice, and hit upon the first problem.
Not sure if this one has been reported already, so here goes.
I loaded the UK default chart of accounts.
Create sales invoice . Two lines on the invoice (both services): item
1 has a qty of 121 @ £35 ea, item 2 a qty of 13 @ £25 ea. Both are
taxable at 17.5%.
If I look at the invoice on-screen, I see a subtotal of £4,560
(comprising 35*121 + 25*13), with a VAT element of £798, making a
total of £5,368. This is what I expect. My calculator tells me so,
and so does the back of an envelope.
If I then run a GL report, I see that the credit to account 2200 is
actually £798.01. Yet if I select the invoice I see that the tax is
£798.
Off I toddle to the database to find that for this invoice:
ar.amount is 5358.01
acc_trans.amount for the tax element is 798.01
I am reminded of the old Pentium joke ("We are Pentium of Borg:
Arithmetic is irrelevant. Division is futile. You will be
approximated."). Not sure whether I'm more disturbed about the
rounding error or about the fact that calling up the invoice from the
web interface is giving me a number which doesn't appear in the GL
report or, as far as I can make out, in the database.
Cheers,
Richard
This message was sent using IMP, the Internet Messaging Program.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Tax rounding error in 1.2.4
Thanks Chris,
I've been futzing around with perl (I feel unclean). I was wondering
if you had considered the Math::Currency module for currency
calculations? I've been having a go myself, but I'm not sure how to
access the transaction currency from Taxes::Simple.
I use perl very rarely and only under threat of torture...
Cheers,
Richard
Quoting Chris Travers <[EMAIL PROTECTED]>:
> Hi, I have reproduced this. Looking into how and why. May be an
> intermediary rounding issue.
>
> Best Wishes,
> Chris Travers
>
> On 4/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> Hi all,
>>
>> I've just loaded the first invoice, and hit upon the first problem.
>> Not sure if this one has been reported already, so here goes.
>>
>> I loaded the UK default chart of accounts.
>>
>> Create sales invoice . Two lines on the invoice (both services): item
>> 1 has a qty of 121 @ £35 ea, item 2 a qty of 13 @ £25 ea. Both are
>> taxable at 17.5%.
>>
>> If I look at the invoice on-screen, I see a subtotal of £4,560
>> (comprising 35*121 + 25*13), with a VAT element of £798, making a
>> total of £5,368. This is what I expect. My calculator tells me so,
>> and so does the back of an envelope.
>>
>> If I then run a GL report, I see that the credit to account 2200 is
>> actually £798.01. Yet if I select the invoice I see that the tax is
>> £798.
>>
>> Off I toddle to the database to find that for this invoice:
>> ar.amount is 5358.01
>> acc_trans.amount for the tax element is 798.01
>>
>> I am reminded of the old Pentium joke ("We are Pentium of Borg:
>> Arithmetic is irrelevant. Division is futile. You will be
>> approximated."). Not sure whether I'm more disturbed about the
>> rounding error or about the fact that calling up the invoice from the
>> web interface is giving me a number which doesn't appear in the GL
>> report or, as far as I can make out, in the database.
>>
>> Cheers,
>> Richard
>>
>>
>> This message was sent using IMP, the Internet Messaging Program.
>>
>>
>> -
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> ___
>> Ledger-smb-users mailing list
>> Ledger-smb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
> !DSPAM:3,4632655442021804284693!
>
>
This message was sent using IMP, the Internet Messaging Program.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] (apparently) cosmetic tax rounding bug
Hi All, I've tested the fix for tax rounding, and everything is now fine (thanks Chris), however when poking around at the various reports available, I've noticed a cosmetic bug. Start with a single transaction that previously gave a tax rounding error (but doesn't with the fix). Then run the 'AR->Reports->Tax Collected' report, selecting 'Detail' (the bug is clearer if you also check 'Subtotal'). Run the report. You will see that the tax is apparently miscalculated again. It isn't - the transaction is recorded correctly in the database - but the calculation used by this report evidently has the same rounding problem. Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] (apparently) cosmetic tax rounding bug
Will do. I prefer GL reports anyway. I'm just in 'I wonder what this button does' mode at the moment... Cheers, Richard Quoting Chris Travers <[EMAIL PROTECTED]>: > Actually the tax collected report has a different known issue which we > inherited from SQL-Ledger. It calculates the taxes not on the basis > of what was entered into the database but on a different basis. This > will be corrected in a future version. This has not been a high > priority because the bug regresses all the way back to SQL-Ledger > 2.4.x. > > The biggest issue is that the tax collected report appears not to take > quantity into account. > > If you need those detailed reports, use GL, trial balance or CoA > reports instead. > > Best Wishes, > Chris Travers > > On 4/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> Hi All, >> >> I've tested the fix for tax rounding, and everything is now fine >> (thanks Chris), however when poking around at the various reports >> available, I've noticed a cosmetic bug. >> >> Start with a single transaction that previously gave a tax rounding >> error (but doesn't with the fix). Then run the 'AR->Reports->Tax >> Collected' report, selecting 'Detail' (the bug is clearer if you also >> check 'Subtotal'). Run the report. >> >> You will see that the tax is apparently miscalculated again. It isn't >> - the transaction is recorded correctly in the database - but the >> calculation used by this report evidently has the same rounding problem. >> >> Cheers, >> Richard >> >> >> This message was sent using IMP, the Internet Messaging Program. >> >> >> - >> This SF.net email is sponsored by DB2 Express >> Download DB2 Express C - the FREE version of DB2 express and take >> control of your XML. No limits. Just data. Click to get it now. >> http://sourceforge.net/powerbar/db2/ >> ___ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > - > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > !DSPAM:3,463392a8164991804284693! > > This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Closing an invoice even when it doesn't want to be.
HI all, I have a scenario which I'm not sure how to handle in LedgerSMB. I have an customer invoice which is settled, but is a penny out. The customer's accounting system has a rounding error (these things get everywhere), and basically they are paying me £0.01 less than this particular invoice calls for. I'm not going to cry over a penny. Even the bloodsuckers^Wrevenue don't care about pennies. To tidy things up, I put through a manual GL transaction, crediting the debtor control account and debiting the VAT account to the tune of £0.01. The problem is that according to the 'AR Aging' and 'Outstanding' reports, this invoice is still open, with an unpaid balance of £0.01. I'm guessing that I can stop LedgerSMB from complaining by going into the database and manually updating the 'paid' field for this invoice, however that seems a bit messy and, worse, unaudited. I'd be grateful for any advice... Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Closing an invoice even when it doesn't want to be.
Thanks Chris; everything seems in order now. Onwards and sideways! Cheers, Richard Quoting Chris Travers <[EMAIL PROTECTED]>: > Create a contra-income account for tracking the penny and pay against > that account. > > We may want to automate this process as time goes by. > > Best Wishes, > Chris Travers > > On 4/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> HI all, >> >> I have a scenario which I'm not sure how to handle in LedgerSMB. >> >> I have an customer invoice which is settled, but is a penny out. The >> customer's accounting system has a rounding error (these things get >> everywhere), and basically they are paying me £0.01 less than this >> particular invoice calls for. I'm not going to cry over a penny. >> Even the bloodsuckers^Wrevenue don't care about pennies. To tidy >> things up, I put through a manual GL transaction, crediting the debtor >> control account and debiting the VAT account to the tune of £0.01. >> >> The problem is that according to the 'AR Aging' and 'Outstanding' >> reports, this invoice is still open, with an unpaid balance of £0.01. >> >> I'm guessing that I can stop LedgerSMB from complaining by going into >> the database and manually updating the 'paid' field for this invoice, >> however that seems a bit messy and, worse, unaudited. >> >> I'd be grateful for any advice... >> >> Cheers, >> Richard >> >> >> This message was sent using IMP, the Internet Messaging Program. >> >> >> - >> This SF.net email is sponsored by DB2 Express >> Download DB2 Express C - the FREE version of DB2 express and take >> control of your XML. No limits. Just data. Click to get it now. >> http://sourceforge.net/powerbar/db2/ >> ___ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > - > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > !DSPAM:3,46339d4e169301804284693! > > This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] (apparently) cosmetic tax rounding bug
Quoting Ed W <[EMAIL PROTECTED]>: > I don't know that I would call it a "trick", but what I found helpful > was to introduce a "VAT Control" account which is my end of quarter > accrual (UK requires payment of sales taxes on a quarterly basis). So I > track VAT paid and earned as seperate ledgers, then clear these down to > zero at the end of each quarter (based on trial balance report, plus a > manual glance at the transactions report). Then I can simply enter my > VAT return based on this entry. > > As an aside this also makes it simple to record the payment of sales tax > (which may have a timing difference), by recording the payment from the > control account > > Happy to flesh this out on the wiki. I think it would be helpful for us Speaking as another UK inmate, may I say "Yes, please". :) Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Closing an invoice even when it doesn't want to be.
Quoting Ed W <[EMAIL PROTECTED]>: > Can you perhaps explain how the "type" of account alters how the ledger > gets handled? I think I might have used an asset or liability account > for my penny tracker, but I guess this is incorrect and means that my > income statement is not going to show it as I might expect? I created a contra asset account, and 'paid' (debited) the penny into it, then I credited this account with a penny and debited the VAT account. This seems to have worked, but now I'm wondering if I didn't do Something Bad... Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] (apparently) cosmetic tax rounding bug
Quoting M Lubratt <[EMAIL PROTECTED]>: > It seems to me that if one uses the "Summary" of the report, the Amount > column includes non-taxable items. Whereas when you use "Detail", the > amount column includes only the items that are taxable. Thus, it appears to > be miscaculated on the Summary report; but, it isn't. > > Is this the issue? No, it's the Mysterious Case of the Appearing Penny. Observe, in summary: AmountTax Total 4,560.00 798.00 5,358.00 And now in detail: AmountTax Total 325.00 56.88381.88 4,235.00 741.13 4,976.13 == 4,560.00 798.01 5,358.01 The tax on each line-item is being rounded separately, so where you should have had .875 + .125, you get .88 + .13. I have decided to ignore this report now, anyway. Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB 1.2.5 released
Quoting Chris Travers <[EMAIL PROTECTED]>: > LedgerSMB 1.2.5 has been released. Thanks Chris et al. I don't have much planned for this weekend, so I'll create a fresh install of 1.2.5 and put my FY05/06 transactions through it again. I think that the only thing I'm missing now is the facility to process supplier and customer credit notes in a pretty way. Once that's in place, I think I'll be switching. Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB 1.2.5 released
Quoting Chris Travers <[EMAIL PROTECTED]>: > Plans are to have better credit/debit note and invoice support in 1.3. > If I promised not to hold anyone to it and, indeed, made a point of forgetting it immediately, would you hazard a tentative guess as to when 1.3 is likely to hit the streets? Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB 1.2.5 released
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>: >> If I promised not to hold anyone to it and, indeed, made a point of >> forgetting it immediately, would you hazard a tentative guess as to >> when 1.3 is likely to hit the streets? > > 3mos >> Noted, and immediately forgotten. :) Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Payroll integration?
Hi List, Up to now I've been handling my payroll using a spreadsheet and just using my accounts package to keep track of the total tax, insurance, salaries, payments, etc. This has worked fine because the payroll consisted of two people. It looks like payroll will be expanding to 4 or 5 before Christmas. I'm switching from webERP to LedgerSMB (1.2.7) as of 1st September. My question to the panel is: can anyone recommend a simple payroll system that can handle UK payroll and can be integrated into LedgerSMB without too much pain? Cheers, Richard This message was sent using IMP, the Internet Messaging Program. - 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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Problems configuring a new dataset with 1.2.10
Hi List, Have just tried installing version 1,2,10 (new install, not upgrade), and have run into a problem. Following the INSTALLATION instructions, I get to the point where I connect to the application admin page and create a new dataset. I enter the ledgersmb user and password, and the db superuser and password in the appropriate boxes, then go on to select the chart of accounts. I enter the dataset name, and check UK_General, then click 'continue'. Then it all goes wrong. After a few seconds, I'm asked if I wish to open the file 'ledgersmb/admin.pl', to which I answer no, and am then returned to the chart of accounts page. Clicking on 'continue' again throws up a 'session expired' error. In the apache error log, I see the following: [Tue Dec 11 19:22:36 2007] [error] [client 10.42.108.1] malformed header from script. Bad header=Try "psql --help" for more inf: admin.pl, referer: https://www.ev6.net/ledgersmb/admin.pl I have duplicated the process exactly, using a 1.2.7 installation, and have no such problems, so something appears to have broken between then and 1.2.10. Any thoughts? Richard This message was sent using IMP, the Internet Messaging Program. - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Problems configuring a new dataset with 1.2.10
Chris, I've just downloaded r1971 of User.pm and tried again, and I get the same result: [Tue Dec 11 20:39:47 2007] [error] [client 10.42.108.1] malformed header from script. Bad header=BEGIN: admin.pl, referer: https://www.ev6.net/ledgersmb/admin.pl Richard Quoting Chris Travers <[EMAIL PROTECTED]>: > Corrected and committed in SVN. Please download the new User.pm. > > Best Wishes, > Chris Travers > > On Dec 11, 2007 3:26 PM, <[EMAIL PROTECTED]> wrote: > >> Hi List, >> >> Have just tried installing version 1,2,10 (new install, not upgrade), >> and have run into a problem. >> >> Following the INSTALLATION instructions, I get to the point where I >> connect to the application admin page and create a new dataset. I >> enter the ledgersmb user and password, and the db superuser and >> password in the appropriate boxes, then go on to select the chart of >> accounts. I enter the dataset name, and check UK_General, then click >> 'continue'. >> >> Then it all goes wrong. After a few seconds, I'm asked if I wish to >> open the file 'ledgersmb/admin.pl', to which I answer no, and am then >> returned to the chart of accounts page. Clicking on 'continue' again >> throws up a 'session expired' error. >> >> In the apache error log, I see the following: >> [Tue Dec 11 19:22:36 2007] [error] [client 10.42.108.1] malformed >> header from script. Bad header=Try "psql --help" for more inf: >> admin.pl, referer: https://www.ev6.net/ledgersmb/admin.pl >> >> I have duplicated the process exactly, using a 1.2.7 installation, and >> have no such problems, so something appears to have broken between >> then and 1.2.10. >> >> Any thoughts? >> Richard >> >> >> This message was sent using IMP, the Internet Messaging Program. >> >> >> - >> SF.Net email is sponsored by: >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> ___ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > > !DSPAM:3,475f2707194461804284693! > This message was sent using IMP, the Internet Messaging Program. - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] RoadMap Question
Quoting Pongracz Istvan <[EMAIL PROTECTED]>: > Personally I use eGroupWare as a possible "Exchange killer" and I had an > idea to make an interface between them. > > For example: > Payment/delivery time into calendar. > Contacts. > Project integration. > Whatever. > I've been looking at eGroupWare, and this is an approach I would favour. I wonder how much work would be involved in creating such an interface... I would like to be able to drive LedgerSMB from eGroupWare, at least from a sales perspective. What I mean is: 1) Create new accounts, projects, etc in eGW, and have them automatically created in LSMB 2) Generate quotes, incoming orders and invoices in eGW, which are in effect passed transparently to LSMB to do the actual work, and return the results to eGW (so that all the financial side of things is handled in LSMB) 3) Account status information provided to eGW from LSMB so that the salesman can tell if a customer is behind on payments, has exceeded his credit limit, etc. 4) Product data used by eGW is retrieved from LSMB. LedgerSMB would be used directly for all the other financial tasks, credit notes, purchasing, product pricing, GL, financial reports, payments made and received, etc. The question is, is this feasible, or am I suffering the delusions of the terminally-overdosed on caffeine? Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] RoadMap Question
Quoting beamends <[EMAIL PROTECTED]>: > Whist appreciating that we all have our different requirements, I'd much > rather that accounts/stock control was 100% before adding features that > fall outside the current system. Obviously I'm totally biased as that > what I'm using it for (i.e retailing)! > Oh, definitely! I should have prefixed my ramblings with the disclaimer that they were, in fact, ramblings. They are things I'd like to see - and may even spend some time working on myself - but not things that I am desperate for. The particular danger with open source projects, I find, is creeping-featuritis. Not so the LSMB development team, which is focused on developing things in a controlled way and has a realistic roadmap. This is all to the good. More power to them! :) Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Help me to see the obvious
Hi All, I have a bad case of Friday Night, and I just can't see what I'm doing wrong. I'm hoping that someone will lead me gently by the hand and not laugh *too* loudly, at least, not within my earshot. I have various taxes accumulating in liability accounts 2210 and 2215. The time has come for me to send some of this money to the gub'mint and thus reduce my liabilities. I have created a creditor record for the government department in question. However, if I go to create an AP transaction, I don't have the opportunity to select any liability accounts. What I want to do is to write a cheque and record in LedgerSMB that I have decreased the liabilities recorded in these two accounts. How do I do it? I'm certain I'm missing something blindingly obvious, and when it is pointed out to me I will kick myself. Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Help me to see the obvious
Thanks David, This is what I thought I needed to do, but then I thought "no, this is far too easy..." Everything is as it should be now. Richard Quoting David Tangye <[EMAIL PROTECTED]>: > On Feb 2, 2008 8:42 AM, <[EMAIL PROTECTED]> wrote: > >> I have various taxes accumulating in liability accounts 2210 and 2215. >> The time has come for me to send some of this money to the gub'mint >> and thus reduce my liabilities. I have created a creditor record for >> the government department in question. However, if I go to create an >> AP transaction, I don't have the opportunity to select any liability >> accounts. >> >> What I want to do is to write a cheque and record in LedgerSMB that I >> have decreased the liabilities recorded in these two accounts. How do >> I do it? > > > I run sql-ledger, but unless i missed something, I do not think this is > different under LSMB: > In your Chart of Accounts, try selecting the check box "Expense/Asset" under > "Include in drop-down menus" for the account. > > I do it a different way. I just do a GL transaction CR bank, DB liability > accounts (GST collected, GST paid (which you might have set up as an asset > of liablility account - I do not think it really matters - I know of > arguments for each way.)). > > > !DSPAM:3,47a3bfc193831804284693! > This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Generating purchase orders for parts/services not on file
Hi All, Is there any way for me to generate purchase orders for parts not on file? I'm thinking of office stationery and the like. I don't want to have to enter parts details for things like staples, biros, coffee, and the like, but when I use "Order Entry->Purchase Order" to enter something without a part number, it complains that the item is not on file and insists that I add it. What am I missing? Richard This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Generating purchase orders for parts/services not on file
Thanks Pete, I was thinking about doing it as an AP transaction, but the Old Method I used was to generate a PO for the supplier, then when the goods arrived with the invoice I would enter the supplier invoice and match it against the PO - I have found this handy for tracking items where the invoiced price is different to the PO price. Case in point (I'm copying this transaction into LedgerSMB from my old accounts package): I ordered a laptop from a supplier at £1021.78. Not having dealt with this supplier before, when I sent in the order I also sent in a cheque for the total amount. However, in between me placing the order and it being fulfilled, the price of the laptop had come down. I was now paying £972.78 for it instead. So when I entered the supplier invoice into the system I became aware that I was entitled to a refund. Having received a cheque from the supplier I was able to match it to that particular PO/Payment/AR association. This gives me a very clear audit trail that shows at a glance why there was an overpayment in the first place, and why I received a cheque back from the supplier. I'm not sure that LedgerSMB will give me this. At least, not as neatly. Also, from a pedantic contractual perspective, when I raise a PO I am making an offer to the supplier. The invoice (or AP transaction) comes when the offer has been accepted. At the point I am making a purchase order, there is no contract and therefore no invoice from the supplier. Richard Quoting Pete Houston <[EMAIL PROTECTED]>: > Hello Richard, > > You can use an AP transaction instead of doing the whole PO/Vendor > Invoice approach. The AP transaction can be used for expense accounts > (such as the general "Office Supplies") rather than COGS accounts which > are used for invoices. > > So, when purchasing goods or services for resale, use a PO/Vendor > Invoice, but for general expenses use an AP transaction (you will still > need to set up the supplier as a vendor, however - the only way to avoid > this is to use a GL transaction, I believe). > > HTH, > > Pete > > On Tue, Mar 04, 2008 at 10:19:12PM +, [EMAIL PROTECTED] wrote: >> Hi All, >> >> Is there any way for me to generate purchase orders for parts not on >> file? I'm thinking of office stationery and the like. I don't want >> to have to enter parts details for things like staples, biros, coffee, >> and the like, but when I use "Order Entry->Purchase Order" to enter >> something without a part number, it complains that the item is not on >> file and insists that I add it. >> >> What am I missing? >> >> Richard >> >> >> This message was sent using IMP, the Internet Messaging Program. > > -- > Openstrike - improving business through open source > http://www.openstrike.co.uk/ or call 07092 020107 > This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] A place for line-item notes on the invoice?
Quoting Jeff Kowalczyk <[EMAIL PROTECTED]>: > On Wed, 14 May 2008 16:18:30 +0100, Stroller wrote: >> If anyone wants a copy of my invoice.tex - the one used for >> generating the linked invoice - then I'll be glad to supply it, but >> there has been little interest in my "innovations" in the past. ... > I'd sure like a copy of that nicely-done invoice.text if you want to email > it to me. Or, you could just post it here as an attachment for anyone > who's interested to see. I'd like a copy too, please. :) R This message was sent using IMP, the Internet Messaging Program. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Stroller <[EMAIL PROTECTED]>: > > On 27 May 2008, at 12:22, beamends wrote: > So I change the date & invoice number, click "Post As New" and now I > have two transactions - the old one is unaffected, the new one > contains the changes. I'm just catching up with the last three weeks of postings (amongst other things). Punishment for taking a holiday, I suppose. This is a minor niggle that I have (minor in the sense that I only generate a maximum of 20 invoices a month, so it's not a big deal to remember). In the UK (at least; it may be the case in other jurisdictions) there is a requirement that invoices be consecutively numbered. Our tax trolls get very upset by gaps or - much worse - duplicate invoice numbers. Much pain and suffering is often the result: if the revenue suspects you of being naughty, you have to prove your innocence. Is it possible, perhaps for 1.3, to generate a unique invoice number on commit in such a way that each invoice is consecutively numbered (and in such a way that there is no mechanism within the ui to alter the number)? I know that LedgerSMB generates a consecutive number if you leave the field blank, but it should not be possible to override this, and when using the "post as new" function, it certainly should not allow a duplicate invoice number to be entered because the user has forgotten to blank the field. Richard - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Chris Travers <[EMAIL PROTECTED]>: > In the db, you can run (in 1.2 or 1.3): > > ALTER TABLE ar ADD UNIQUE(invnumber); > Thanks, I've just done that but it turns out that I do have a duplicate invoice number. I do have a gap directly below it, though, so I can just change invnumber. Before I do that, is there anywhere else I will need to change it, apart from ar? Richard - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Chris Travers <[EMAIL PROTECTED]>: > On Tue, May 27, 2008 at 12:05 PM, <[EMAIL PROTECTED]> wrote: >> >> Quoting Chris Travers <[EMAIL PROTECTED]>: >>> In the db, you can run (in 1.2 or 1.3): >>> >>> ALTER TABLE ar ADD UNIQUE(invnumber); >>> >> >> Thanks, I've just done that but it turns out that I do have a >> duplicate invoice number. I do have a gap directly below it, though, >> so I can just change invnumber. >> >> Before I do that, is there anywhere else I will need to change it, >> apart from ar? > > Nope You *could* add one on (vendor_id, invnumber) to ap, but > that may be asking for trouble. In general, I would prefer to keep > that to AR. Ok, that's all happy now. Might be worth mentioning it in the documentation? This is certainly a feature that UK users will need, even without the gap-free incremental numbering. Richard - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Luke <[EMAIL PROTECTED]>: > That would be good for various reasons. > However, making it user immutable, might not be reasonable. What if, for > example, you royally screw up an invoice, perhaps by putting the wrong > invoice number in on your own. You will want to go back and fix that. This wouldn't be a problem if you were unable to enter an invoice number at all: you create an invoice, the database gives you a number, and you live with it. > > What needs to happen, I think, is that an invoice needs to be utterly > unpostable, if the invoice number value is set to something which already > exists. In my scenario above, this wouldn't be an issue. > > The default is already to increment them (except that they don't reset at > the start of the month, if you use something like ?>-001 as your default). I think they should always seek the lowest > possible number, which would cause a reset. I don't think that this method of invoice numbering is acceptable in the UK, but I'm not a tax accountant. Perhaps one way around it is to have a column in ar which is unique and database-incremented, in addition to what is now called the invoice number. Those of use who need a perpetually incrementing invoice number can simply change our templates to use this instead. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Stroller <[EMAIL PROTECTED]>: > > On 27 May 2008, at 18:06, [EMAIL PROTECTED] wrote: >> ... In the UK ... there is a requirement that invoices be >> consecutively >> numbered. > > Is this new? > > I did a "starting your own business" course at the local Chamber of > Commerce before I became self-employed 3 or 4 years ago, and my > understanding at that time was that invoice numbers had to be > *unique*, rather than consecutive. I was told this by my accountant. The tax trolls get very unhappy if they perceive gaps in your numbering (what are you hiding in the gaps, you traitor?). I'll ask him again when I see him. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Chris Travers <[EMAIL PROTECTED]>: > Now for midsize businesses entering lots of invoices, this may not be > reasonable. Basically it means you are extremely limited in terms of > scalability, and after you have a few people in your AR department, > they end up waiting on eachothers' transactions. Needless to say, I > don't see this as a good thing. ISTR that JD Edwards provided guaranteed consecutive numbering, (but it's a long time since worked with JD Edwards). That software was designed for high-volume transaction processing. How did they do it? > > However, some businesses will need this regardless of the performance > cost so an optional module would not be a bad idea. I think this would be the best approach. > Now for unique invoice numbers-- on the surface this looks like a slam > dunk and I may go ahead and add a UNIQUE index to ar.invnumber. > However, once you get past that point things can become dependant on > local requirements. For example, consider tracking reversed > transactions. I see no inherent reason why the invoice number would > need to be different if I am voiding (fully reversing) an erroneous > transaction. However, suppose this is a problem, and that each > invoice needs to be both guaranteed unique and sequential. In this > case, if I have an invoice number of 12345, I can't issue a voiding > invoice of 12345V, but for those of us who have no such requirements, > this is very helpful in tracking what happened with a given invoice. Over here, I believe that the standard way of dealing with erroneous invoices is that you do reverse them, getting a new sequential number and all, and keep the error and reversal as evidence for when you are put to the question. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Luke <[EMAIL PROTECTED]>: > Or is it just because of the gaps? If because of the gaps, then the only > invoice numbering possible, is sequential with zero gaps. > This no gaps thing is most strange from a U.S. prospective. It's the gaps. I'll double-check this with my accountant when I see him (sometime in June), but I think that you need to a) explain why you have gaps, and b) demonstrate that the gaps are really gaps, and that you haven't been generating invoices that didn't go through your accounts. I'll come back to the list when I've got a definitive answer. > >> have a column in ar which is unique and database-incremented, in >> addition to what is now called the invoice number. Those of use who >> need a perpetually incrementing invoice number can simply change our >> templates to use this instead. > > That is not necessary. The invoice number format is quite configurable. > Just set it to "01", and it will increment for ever, with no > problems until you have invoiced enough to pay an army of accountants to > make it their problem instead of yours. This is also fine, but it should also be configurable to make the invoice number immutable in the invoice entry form so that someone can't accidentally insert an out of sequence invoice number. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Luke <[EMAIL PROTECTED]>: > Require printing, emailing, etc., to be done *after* the fact of invoice > generation and postal, not prior to posting. This seems perfectly reasonable to me. I can't think of any circumstances in which I would want to print or email an invoice that has not been posted. That way, madness lies. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Luke <[EMAIL PROTECTED]>: >> From the web site: > > http://www.hmrc.gov.uk/vat/records-valid-invoice.htm > > We get this: > > " > How VAT sales invoices must be numbered > >You must number your sales invoices in sequential order. If you spoil >or cancel a serially numbered invoice, you must keep it to show to a >VAT officer at your next VAT inspection. > " > Thanks. Thus spake the taxman, and forthwith appeared a greyish throng of auditors who wailed and thus addressed their mournful song: "Audit your accounting 'cos the taxman you can't fleece, and numbers on the invoices begin and never cease." (With apologies to Nahum Tate) R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Stroller <[EMAIL PROTECTED]>: > Yes, but there's an obvious difference between: > > 00042 > 00043 > 00044 > 00046 (missing number precedes) > > and: > > 20080501 > 20080502 > 20080503 > 20080512 (issued on the last day of May) > 20080601 > ... > 20090101 > > If one accepts that date-based invoice numbers are acceptable (and I > contend the taxman might do so), no-one expects to see invoice number > 20081301, and the "gap" between 20080512 and 20080601 is quite > logical & reasonable. It's the anomalies that raise the taxman's > hackles, not the choice of implementation. > Erm, you mean the "gap" between 20080531 and 20080601, surely? 'Cos I posit that 20080525 is a perfectly reasonable number in this scheme. ;) This scheme, in any case, would only allow one invoice per day. I'll buy a professional opinion from my accountant when next I see him. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Stroller <[EMAIL PROTECTED]>: > No. There are only 12 invoices issued in May in this example. > Presumable the issuer is a consultant, or someone who otherwise only > works for a handful of companies at day rates. > > Tch! This should be obvious! Bah. My brain hurts. I clearly hadn't consumed enough coffee. I'll slink off into a corner now. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] At the end of my teather with LSMB
Quoting Stroller <[EMAIL PROTECTED]>: > Not all UK businesses are VAT registered, however. VAT is the > equivalent, I think, of US sales tax, and one is only obliged to be > VAT registered if one has a turn over in excess of (approximately) > $100,000 per year. > > The accounting and reporting requirements for non-VAT-registered > businesses are - in general - much less strict. £75,000 is the mandatory registration threshold here, I think. You're right, of course, which makes it more sensible for this sort of enforcement to go into a compliance module rather than the core. R - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Error when entering a sales order
Hi List, I haven't used LedgerSMB for entering sales orders before now, but I'm wanting to make a start. However, when entering the first one, I get this error: DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint "transactions_pkey" Error! INSERT INTO oe (id, ordnumber, quonumber, transdate, vendor_id, customer_id, reqdate, shippingpoint, shipvia, notes, intnotes, curr, closed, department_id, employee_id, language_code, ponumber, terms, quotation) VALUES (10547, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ERROR: duplicate key violates unique constraint "transactions_pkey" I've poked around the database, and I see that the highest value for transactions.id is 10545. Furthermore: select * from transactions where id = 10547; id | table_name + (0 rows) Any ideas as to what may be the problem? Richard - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Error when entering a sales order [SOLVED]
Thanks Jeff, Armed with a backup of the database, I re-ran transactions_foreign_key_fix.sql. However, I needed to fix the fix first (this might be why I have the problem - I must have missed these errors when I ran it the first time). In the fix, there are a lot of DDL commands of the form DROP RULE ON TO ; I'm using PostgreSQL 8.2.6, and it does not like the " TO" bit of the statement. I removed all occurrences of "[insert|update] TO", and re-ran the script. Problem solved. Richard Quoting Jeff Kowalczyk <[EMAIL PROTECTED]>: > richard wrote: >> DBD::Pg::st execute failed: ERROR: duplicate key violates unique >> constraint "transactions_pkey" >> Error! >> INSERT INTO oe >> (id, ordnumber, quonumber, transdate, vendor_id, >> customer_id, reqdate, shippingpoint, shipvia, >> notes, intnotes, curr, closed, department_id, >> employee_id, language_code, ponumber, terms, >> quotation) >> VALUES >> (10547, ?, ?, ?, ?, >> ?, ?, ?, ?, >> ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?) >> ERROR: duplicate key violates unique constraint "transactions_pkey" > > On branches/1.2 the transactions table is keeping track of which table a > certain id references. > > id | table_name > ---+ > 10001 | chart > ... > 11440 | customer > 10157 | employee > 10585 | oe > ... > > I believe it is considered legacy. I had this problem in January 2008. > > After consultation on #ledgersmb, I deleted all rows from the table, and > did (if memory serves) INSER INTO transactions (a union of all the row ids > of and their tablenames) for the specific areas I was working with: > > SELECT DISTINCT table_name > FROM transactions > ORDER BY table_name; > > chart > customer > employee > oe > parts > project > vendor > > And everything was fine thereafter. > > I regret that I don't have the exact INSERT INTO sql handy to quote here > for you, but I just wanted to reply ASAP that this is not a serious > problem. The transactions table is fairly easy to manipulate and/or > rebuild. > > Jeff > > P.S. There's an off-by-1 issue, but I can't find a bug filed. The plan was > to backport the track_global_sequence from trunk to branches/1.2. > > P.P.S See branches/1.2/sql/fixes/transaction*.sql > > > - > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > !DSPAM:3,4878e82d183171769015505! > > - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB 1.2.16 Released
Quoting Chris Travers <[EMAIL PROTECTED]>: > The LedgerSMB Core Team is proud to announce the release of version > 1.2.16. What??? I've only just upgraded to 1.2.15! *grin* Seriously, I'm sure that I speak for more than just me when I say thanks to you and the other LedgerSMB developers for the time you invest in the project. I'm looking forward to helping to test 1.3 when it hits beta. R - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] VAT Rate Change
Hi Chris, I'm in the same boat. I've just tried this and got a primary key error. I note that the pk for the tax table is: "tax_pkey" PRIMARY KEY, btree (chart_id) Should this be changed to include the valid_to field? (I'm running 1.2.17, by the way.) Richard Quoting Chris Travers <[EMAIL PROTECTED]>: > Ok > > To set the record straight, for new versions of LSMB, you can set one > tax account with multiple rates for different date ranges. However, > there were some old versions (prior to 1.2.12, I think) that had some > bugs in this area. Best to be on the safe side and upgrade first. > > Set a date in the "Valid To" column, then add a new rate with a > blank valid to. > > Best Wishes, > > -- > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] VAT Rate Change
D'oh. Thought I had applied that... Ok, having applied the fix, I can now add a new tax rate. I've just generated an invoice, and it picked up the new rate. I think that's a success. :) R Quoting Chris Travers <[EMAIL PROTECTED]>: > On Wed, Dec 10, 2008 at 11:16 AM, <[EMAIL PROTECTED]> wrote: >> Hi Chris, >> >> I'm in the same boat. I've just tried this and got a primary key >> error. I note that the pk for the tax table is: >> >> "tax_pkey" PRIMARY KEY, btree (chart_id) >> >> Should this be changed to include the valid_to field? > > Forgot to mention there is a required fix. > > sql/fixes/tax_pkey_duplicate.sql > > Best Wishes, > Chris Travers > > -- > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] VAT Rate Change
Quoting beamends : > I've just tried this, assuming "apply" means run the SQl using > phpgadmin. > > I've changed the old VAT(17.5) 2200 on the chart, set the valid date to > 30th Nov and created a new tax 2201 VAT(15). > > When I go to save the Tax page I get : > > DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" > > Error! > > INSERT INTO tax (chart_id, rate, taxnumber, validto, > pass, taxmodule_id) > VALUES (?, ?, ?, ?, ?, ?) > ERROR: invalid input syntax for integer: "" I got this too. I think that you just need to make sure that there is a number in the "Number" and "Ordering" fields, for each row. I put 0 in the former (I'm not sure what it's used for, but originally it had nothing in it, and setting it to 0 hasn't made any obvious difference), and 1 in the latter. Hth, Another Richard -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] payments from email
On Fri, 2009-08-28 at 21:05 -0500, James Stevens wrote: > A question somewhat adjacent to this topic: > One of the reasons we moved to this accounting bundle was to gain the > ability to accept credit card payment from our clients/customers. > > Our scenario would be a client calls after receiving an invoice and asks > to pay it with CC. > We obtain the clients CC info over the phone and process it (via Ledger > SMB) for said invoice. > > It goes without saying we have not gotten that far yet. Is anyone doing > this ? > (The goal is to get AWAY from PayPal and use our own merchant services) > We process many on-line orders and phone orders every day using LSMB. For on-line orders we use a free site that securely handles gathering card details (so we never have to keep them locally). This service can link directly to a number of card processors. It's dead simple to integrate this in to your web site (e-mail me at sa...@beamends-lrspares.co.uk with a meaningful subject for the address). Phone orders are typed into the card machine while the customer is on the phone. Personally I don't think keeping card details within LSMB is a good idea unless one is extremely confident about security, and, for phone orders, you're going to have to type the numbers into the card machine anyway. Cheers Richard > -Original Message- > From: tur...@think-electric.com [mailto:tur...@think-electric.com] > Sent: Friday, August 28, 2009 4:05 AM > To: ledger-smb-users@lists.sourceforge.net > Subject: Re: [Ledger-smb-users] payments from email > > As a follow up to my original question under this same subject dated > June > 12 to the devel list. Turns out a user can add one. > How I added a paypal "buy it now button" > > This will add a button that pays an invoice total using your merchant > paypal account. We use project numbers to identify different contracting > jobs for the same customer so substitute you own variable there or > remove > the projectnumber_1 line. > > This does not allow a customer to create an order just pay a bill for > work > you already performed etc... > > Edit the invoice.html file in templates. > Append this code to the end of your invoice.html > > > https://www.paypal.com/cgi-bin/webscr"; > method="post"> > > > > > > > > > > src="https://www.paypal.com/en_US/i/btn/btn_buynowCC_LG.gif"; border="0" > name="submit" alt="PayPal - The safer, easier way to pay online!"> > src="https://www.paypal.com/en_US/i/scr/pixel.gif"; > width="1" height="1"> > > Tips: > Do not use the paypal button creator. > Insert your data for YourBuisnessNameWithNOspaces and > youraddr...@youremail.com > > Email the invoice and use the html template. > > Enjoy accepting plastic and getting paid faster but loosing a %. > > -Turtle > > > > > -- > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > trial. Simplify your report design, integration and deployment - and > focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > -- > This message has been scanned for viruses and > dangerous content by SISLINK.NET. Come join us! > > -- I have become...comfortably numb -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Panic really setting in now!
just like Linux, all the > programs are history, even if their code is still there. However, you > reinstall, and good luck getting your old configurations back. > > Not that this helps you right now, but you're blaming the OS for > apparently not being able to do things, that you never told it to be ready > to do, even though it is most capable of it. > > > Sorry if that sounds a bit ungrateful towards the unpaid stalwarts of > > Open Source, but if I were Joe Bloggs Shop Ltd I'd have given up after > > the first debacle - no doubt with the Sage Rep saying "told you so". > > If Joe had followed the vastly available documentation, or better yet, > decided that he didn't know the whole picture and would employ or ask a > pro or expert, he wouldn't have had a problem. If he did, he could call > that same expert and say "you screwed up: fix it". I'm not saying that's > what should have happened in your case, as you obviously know more than > the average Joe Bloggs Shop, but even so the first time you had a failed > upgrade, you should have hit the forums, the lists, etc., and figured out > what happened, so you could both fix it, and not do it again next time. > > Since you've talked about Windows, I will note that if an OS upgrade fails > in Windows, the chances of having a still working system to even patch > into workability, are about a million to one. > > This is all harsh, I know it. I usually have more patients than this.:) > Sorry. > > Luke Hi Luke, after the first time Ubuntu upgrade failed, (using the Upgrade Manager menu thingie) I've never used .debs or such, except where further upgrades have failed and there was no way forward. Ok, these problems may be due to legacy issues surrounding that first failure, but surely that shouldn't really happen? I did indeed completely remove Perl, and then re-install it from Synaptic, and things did indeed get moved round (where the Perl 5.10.0 directory is and such), but it didn't fix the problem. I know I'm being rather grumpy about this - but having persuaded the new owners that Linux is the best thing since sliced bread, bearing in mind their Windows PC has never given any trouble, and then this all happening (again) is, to say the least, embarrassing. Anyway, if anyone else has the same problem after upgrading to Ubuntu 8.10 or 9.04, there is a solution if you happen to have a spare machine that 9.10 has just been installed on (I tried just installing LSMB 1.2.8 (?), but it fell over when trying use the Admin screen with an type error from, I assume, Postgres 8.3) This is not a detailed guide, on the gist of what I did 1. Remove completely Postgres 8.3 2. Download and install Postgres 8.2.x from the Ubuntu site (you can't get 8.2 with apt, at least not without messing about with the sources file) 2. Installed LSMB following : http://www.howtoforge.com/ledgersmb_debian_etch which is the simplest set of instructions I've yet found - in fact it couldn't be simpler - cut and paste, only remembering to change passwords. 3. Change the port to 5432 in ledgersmb.conf 4. Create a dbase with the same name that the backup came from. 5. Create a user with the same name that did the backup (I don't know if it has to be the same, it just seemed sensible) 6. Restore the backup with pg_restore -d BeamendsLRS4x4 /home/growing0/Desktop/BeamendsLRS4x4-1.2.0-20091014.sqlc There were 259 errors, but nothing serious as far as I can see. And it works! As I have had to do this at home on an old laptop with no fan (conks out if worked hard) I've got to do it all again tomorrow on the old PC, transfer all the companies files across etc - but at least we can actually run the business again... Cheers Richard > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- I have become...comfortably numb -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Lost Taxes After Restore
On Mon, 2009-10-19 at 13:30 +0100, beamends wrote: > After recent events, I've done a pg_restore -d backup.sqlc > > but the taxes have stayed at the default values. I've changed the 17.5% > to 15% (thanks Gordon), but my 0% rate had gone (books and export) and I > can't remember what account code I used for it. > > First off, have I used the correct flags for pg_restore (I created the > dataset for the company to restore into before restoring), and > > Secondly - as the parts have all "lost" their tax catergory (15%) - are > the numbers going to add up in reports? > > Cheers > Richard > Thanks for mail Chris. All sorted out now - I went one step too far and created a user before restoring using the -d flag. After a bit of faffing I found I should have not created a user, instead just created a dbase and then resored using the -C flag (I think!). All is nearly well - one little hiccup was that although the 0% VAT rate appeared ok, and is present on all Part pages, the books we sell (0% VAT) have all had their VAT set back to 15% - easily put right but could have easily been missed. The installation is otherwise ok, but it is a bit flakey - if it continues I'll post the error messages as and when. Cheers Richard > > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- I have become...comfortably numb -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB Readiness
On Tue, 2009-10-20 at 15:35 -0500, blck shp wrote: > What is the longest successful deployment of LedgerSMB? What trial and > tribulations did you go through? No idea there, but we've been using it for around 18 months or so. The only major issue I had was getting to grips with (Ubuntu) Linux - I hadn't touched *nix since University, 20 years ago. Getting the data transferred from our old system required some SQL and/or programming or spreadsheet work or such - but at least the required info is readily available. > > Is it worth the risk migrating to LedgerSMB from Peachtree? (Bearing in mind that v1.3 has quite a lot of new features above current installations...) No idea, not having used Peachtree. If it has all (or most of) the features you need, I'd say give it a try. It costs nowt to have a play. > > Why isn't LedgerSMB right for my company? Possibly Linux support, maybe a some key feature missing? > > What are the major bugs keeping me from deploying LedgerSMB? > Compared to 18 months ago, there are very few bugs I've come across in v1.2.18. In fact only one I have found so far is only minor and related to a dbase restore anyway - though I should say we don't use the project related fetures, time cards etc. One of the LSMB highlights is rapid development and quick bug fixes. > What other software would you put up against LedgerSMB for reliability? Anything that's been 100% reliable. We've never had a crash or lost any data. I have some issues with Ubuntu upagrades, but LSMB has been rock solid. Cheers Richard > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- I have become...comfortably numb -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Pricing parts in an assembly
Hi All, I'm creating some assemblies (kits really), where the I need to price some of the sub-components at a lower rate than normal retail. I can't see a way to do this - any ideas? Cheers Richard -- I have become...comfortably numb -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] some descriptions for translations
On Thu, 2009-11-05 at 22:00 +0200, s...@apollo.lv wrote: > Hi! > > I added some missing translations for Latvian. > But I still some unclear terms. In my installation I could > not find them, because I only use LedgerSMB partly. > > These are: > DOB Date Of Birth ? > Excempt age < > OH On Hand - i.e how many in stock > PO Number Purchase Order Number ? > Pos Point Of Sale (usually a till of some description) > RFQ Request For Quotation > Req Abbreviation of Required, as in needed (or maybe Request - depends on the context) > SSN No idea! > > Could any body help with some short basic description? > > Thanks in advance, > Janeks > Cheers Richard > -- > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- I have become...comfortably numb -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Subject: Hardware support architecture for remote Clients
On Mon, 2009-11-09 at 12:07 +0300, Alex V. Tikhomirov wrote: > > How the card / bar code readers send their requests/posts > > to the server? > > Barcode readers. > > There are two types of readers: > > 1.USB/COM connectors > 2.Keyboard connectors. > > I think that 1st type will be hard to use with LSMB. > > Computer feel кeyboard connected barcode scanner like just > an ordinary keyboard, so no need in additional software to use it with > LSMB. All you need to use scanner is to point the cursor to right > entry field before start to scan. > > Scanner will read and decode barcode information, will send it to entry > field and will "press Enter", so right default button have to be defined. > > There is one more question: Were to store barcode in LSMB ? You could use the Microfiche field or Drawing or some other field you don't normally use. We use the Microfiche field to store codes for putting things in the right place on the web site, and Drawing for dimensions. Cheers Richard > -- I have become...comfortably numb -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] How ready is Ledger-SMB?
On 17/04/12 19:38, Kevin Bailey wrote: Hi, Sorry if this is a dumb question - but thought I'd make sure. We've currently been using SQL-Ledger for nine years - but we're looking to switch away when our new tax year starts on 1st October 2012. I'm definitely not looking to move the existing data from the existing accounts system - we're looking for a clean start for various reasons. My question is - is Ledger SMB ready for production use? Obviously it's FOSS software so there's no guarantees of any sort expected - and we'd carry out our own backups (printed and DB dumps) and take responsibility for our own systems - but I wondered if LSMB is being used in anger by companies. We're UK based and I'm used to setting up SL to work within UK's VAT setup etc. We'd like to be good citizens of LSMB - we're coders ourselves and would be happy to work with bug reports, suggestions, patches etc. Also, we'd be happy to submit any docs we build up back to the project. Looking longer term - it may well be that we'd be in a position to supply hosted account packages to our clients - and LSMB could be a good basis for that service. Thanks for your help, -- Kevin Bailey Director/Programmer - Freeway Projects Limited Web: www.freewayprojects.com Email: kbai...@freewayprojects.com Phone: +44 (0)1752 267090 -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users LSMB is fine for UK use, it seems quite a few companies use it - I used it a Ltd Co. for 3 or 4 years. Perhaps the best endorsement is that it quite impressed the Inspector when I had a VAT inspection! As you may guess, it 'does' VAT very well, and is easy to set up - the only thing it doesn't do is produce the numbers for the VAT return, but getting them from the various reports is easy. -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] entering a large number of parts
On 09/10/12 16:54, Bill Appelbe wrote: Hi I am wondering if there is a way to enter a large number (several thousand) of stock items (parts) I can get the stock list in a csv format, what fields in the database would I need to populate if I was to do it directly? Or is there another smarter way? Bill -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users You can load CVS files using pdadmin, pgpadmin or other such tools directly into Postgres. I don't know if the user guide has been updated, but there was enough info in there to work out the fields and their order. I wrote a C program to put the CSV columns in the right order with blanks or default values where required, but I suppose a spreadsheet could be used. Test it on a dummy dbase though! -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Installing 1.3
On 17/10/12 16:59, Kevin Bailey wrote: On 17/10/12 13:58, lrspare...@aol.com wrote: Hi,I'm having a bit of a nightmare here! My old 1.2based system has suffered a hard drive problem- but no panic,I've got a back up Only I'm having some trouble installing 1.3 on Ubuntu 12.04LTS. Having found that LSMB is not in the repositry,I finally manged to install it via the Ubuntu Software centre - so far so good. However, when I try to log inI get prompted for User, Passsword and Company. The only username entered was 'ledgersmb' and password asked for during installation doesn't work (I've re-installed 3 times to make sure!). How do I log in? The user to log in with needs to be an admin user for Postgresql. Either add a password to the user postgres - or create a new user with $ sudo su - [Password] # su - postgres $ createuser -s -P lsadmin [Enter password twice] Check that you have hostall all 127.0.0.1/32 md5 in your pg_hba.conf file which means that the user can connect to PG using a password. HTH Ok, thanks Kevin and Robert. I'll try your suggestions tomorrow, we've called it night tonight. Cheers Richard (just out of interest, regressing to Ubuntu 9.04 didn't work - no driver for eth0 on the new machine, and using v1.2.xx LSMB wouldn't work in on Ubuntu 12.04LTS as Postgres 8.1 isn't available!! Been along day ;-)) -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Near Done With Recovery (famous last words..... )
Hi All, I've got the backup to load (messing about with pg_restore, I forget to note which worked unfortunately). I've gone through duplicate customers, suppliers and invoices ok, and it's now asking for contrib_dir Default AP Default AR I've googled for contrib_dir and there seems to be some confusion as to this being part of LSMB or Postgres - what should go in here, a full path to a directory? If so, which one? Default AP & AR I didn't change these on the original. Are these account names or numbers? What are the default values (I can't look at a running system to look yet).? Just as a matter of interest, does LSMB recalculate everything, e.g. invoices, when extracted from a backup, or are such things stored as they were, so to speak? I'm just curious what happens when a duplicate is removed, will the overall numbers change e.g. total sales value? Thanks again for the help - hopefully this will be the last request! Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Login problems - again.
Hi, so I've got the dbase restored, and via pgpadmin it looks like the data is there, browsing through the tables. Unfortunately, after the 'user details' entry at the end of the restore process, I can now no longer log into LSMB. I can log in to Set Up no problem. So it looks like, for whatever reason, I don't have a user for LSMB, i.e. for login.pl. How can I create one without being able to access LSMB - I've spent all afternoon googling and trying stuff, but to no avail - not helped by most advice bring trying some Postgres command but not telling me whether I should be an ordinary user, at the postgres prompt or pqsl prompt; and then getting syntax errors anyway ;-) Can someone *please* tell me how to, or point me to some where that really explains how to, create a user that I can log in with when I cannot log in via login.pl - I'm seriously frustrated after 4 days trying to restore from a back-up, and my customer has made it very clear I'm not getting paid for most of my time. Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Still Cannot Log In
On 20/10/12 15:11, Erik Huelsmann wrote: Hi Richard, Can you log into IRC? I'm available on irc://freenode.net/#ledgersmb <http://freenode.net/#ledgersmb> right now. We could discuss there what might be going on and resolve this much quicker than through e-mail. To help others with the same problem, we might send an e-mail summarizing our resolution when we have one. Thanks! Bye, Erik. On Sat, Oct 20, 2012 at 3:47 PM, <mailto:lrspare...@aol.com>> wrote: Hi, getting really, really pisssed offnow. Completely uninstalled everything. Reinstalled everything(from deb package 1.3.17) Restored the dbase with pg_restore. login with Setup.pl run - a few duplicate invoices,not otherwise ok Input a user when asked. Everything looks ok with phppgadmin. Go to login with login.pl <http://login.pl> and just get a repeating login box- thevery carefully noted user entered in setup does not work. Please God - is there a solution to this. All I can find is reply to en email from Chris, but I don't understand the answer. Please,please- there must be someone who knows how to fix this? Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net <mailto:Ledger-smb-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users Hi Erik, unfortunately the customer has now closed for the weekend, so I can't do much until Monday. Thanks for the offer though. Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Now trying ledegrsmb1.3.18
On 22/10/12 16:54, Robert James Clay wrote: > On Mon, 2012-10-22 at 11:13 -0400, lrspares45 wrote: >> Hi, >> I've found 1.3.18 deb and installed that > Which one? My v1.3.18-1 package? (Check the debian changelog...) > > Btw; I ususually install the dwww package on any system I'm running > some kind of cgi capable web server on, so the local documentation can > be viewed and browsed... > > > Jame > > > > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users Hi Jame, I'm at home now. I think it was 1.3.18-1, though looking for where I got it from I've found another, 1.3.18-2 at http://pkgs.org/download/ledgersmb. I've looked through all the documentation I can find for ledgersmb & Ubuntu - not much joy there I'm afraid. Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Still Cannot Log In
On 22/10/12 18:15, Robert James Clay wrote: > On Mon, 2012-10-22 at 11:49 -0400, lrspares45 wrote: >> Hi, >> I've got lesgersmb 1.3.18 installed now on Ubuntu 12.04LTS. Still not >> able to login though. It appears that Setup is failing too, the >> postgres log has rucks of 'passsword authentication failed...' >> errors, and every time I run it it wants to upgrade the dbase from >> 1.3. > Which indicates to me that the name you're giving is for a v1.2 LSMB > database which hasn't yet been successfully converted to a v1.3 LSMB > database. > > For testing purposes; have you tried creating a new LSMB database? Ah, I'd assumed the dbase upgrade took care of that. I'll try a dummy dbase too, should have thought of that! > > >>I can see the LedgerSMB users with phphgadmin, and the dbase users >> with psql, as far as I can tell the all have the necessary >> permissions. > Which users? For instance, if this is from the "official" > Debian/Ubuntu package (which I am the maintainer for), then a > 'ledgersmb' database admin user (the one to be used in setup.pl) should > be present but may not be configured correctly. (For instance, to > correct: ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT;) Ok, I'll try that. I did try ALTER ROLE but got sytax errors. > > > > Jame > Cheers Richard > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Still Cannot Log In
On 22/10/12 18:55, Robert James Clay wrote: > On Mon, 2012-10-22 at 13:27 -0400, Richard wrote: >> On 22/10/12 18:15, Robert James Clay wrote: >>> On Mon, 2012-10-22 at 11:49 -0400, lrspares45 wrote: >>> >>> For testing purposes; have you tried creating a new LSMB database? >> Ah, I'd assumed the dbase upgrade took care of that. > But that appears to be failing; why, we don't know yet. > > >> I'll try a dummy dbase too, should have thought of that! > Yes, that'll help tell us where the issue might be... (normal ops, > or the upgrade...) > > >>> , then a 'ledgersmb' database admin user (the one to be used in >>> setup.pl) should >>> be present but may not be configured correctly. (For instance, to >>> correct: ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT;) >> Ok, I'll try that. I did try ALTER ROLE but got sytax errors. > What kind of syntax errors? And is 'ledgersmb' actually present? > (If not,it can be created by: CREATE ROLE ledgersmb WITH SUPERUSER > LOGIN NOINHERIT ENCRYPTED PASSWORD 'password';) > I'll have to try that tomorrow and get back. When in psql I can do \du and see 'ledgersmb' with all, I think, privileges. Cheers Richard > Jame > > > > > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Login problem
HI, I tried ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT; that was accepted ok, but made no oddsto logging in Creating a new dbase worked just fine - login is ok :-) I'm guessing that's significant! Some of my emails were bounced yesterday, there was one that I gave a chunk of the postgres log that showed that the dbase upgrade run bySetup was failing (due to permissions). Is the root of the problem actually the dbase conversion failing I wonder? Cheers Richard -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] PostgresSQL verssions
On 24/10/12 14:05, Robert James Clay wrote: With LSMB 1.2.18 (on Ubuntu 12.04LTS) I get unsatisfied dependencies for Postgres 8.1 (or at least three bits of it) - I'm back on the day job for the rest of today so can't give the exact messages, but I'll try again tomorrow. Cheers Richard > On Wed, 2012-10-24 at 08:01 -0400, lrspares45 wrote: >> Oh great! Ubuntu 12.04LTS doesn't support Postgres 8.1... Going to >> have to install an earlier Ubuntu now... >> > Why do you need to go back to such an old version of PostgreSQL? > Postgresql v9.1 (and v8.4) has been supported[1] for v1.2 versions of > LedgerSMB since v1.2.16. > > > > Jame > [1] > http://ledgersmb.org/faq/install-ledgersmb/what-versions-postgresql-does-ledgersmb-support > > > > -- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Login Error
Hi Chris I have tried replacing my ActivePerl 5.6 with 5.8 but could not find a binary for DBD::Pg for 5.8. All I could find on PGFoundry was the source for DBD::Pg. As I do not have a suitable compiler on my Win XP computer this is of no use to me. Regards Richard Chris Travers wrote: We recommend ActivePerl 5.8 with the DBD::Pg builds at PGFoundry if you are going to go the ActivePerl route. Otherwise we expect to have an integrated WIn32 installer with VanillaPerl for 1.2 (with all dependencies). At the same time, I will be looking into the menu.pl to see what the problem likely is. Best Wishes, Chris Travers On 11/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi I have just finished installing ledger-smb 1.1.1c on my WinXP computer. I am using PostGres 8.0 and Activestate Perl 5.6.1. The installation went smoothly and I was able to create a user account. When I try to login as that user I get an error "Database handle destroyed without explicit disconnect at menu.pl line 139". What is causing this? How can I get around it? Regards Richard. - 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 ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-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 ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-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___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Serial numbers and notes on invoice
Hello, Is there any way to get the serial numbers and notes on the line items to print on the invoice? I couldn't see how to do this on SQL-Ledger and it doesn't seem to make much sense to me to have these fields if they don't show on the invoice. I've had a little problem on my accounting server (was using webERP) so I want to take this opportunity to try out a different system. LedgerSMB and it's community seems like what I'm looking for. Thanks. Richard - 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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Serial numbers and notes on invoice
Thanks for your input. Actually, if I can at least get the note part to print on the invoices, that should suffice. Thanks again. Richard On 10/12/07, Chris Travers <[EMAIL PROTECTED]> wrote: > On 10/12/07, Richard Hernandez <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Is there any way to get the serial numbers and notes on the line items > > to print on the invoice? > > Wow, that is some code to wade through to get the answer. Yes, in > 1.2.x, it looks like a tag inside the lineitem > area should work, but I haven't tested it. > > I am still looking into what will be required in 1.3.x. > > Best WIshes, > Chris Travers > > - > 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/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Reversing service invoice howto
Hello, What's the proper way to reverse/credit an invoice? I tried editing the posted invoice and changing the quantity to negative and it seems to work but it still shows on the outstanding transaction report. Is there a way to apply the credit to the original invoice? Thanks. Richard - 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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Opening new window without the menu
On 10/17/07, Chris Travers <[EMAIL PROTECTED]> wrote: > I have come across one instance where this happens and I haven't yet > resolved it. > > In 1.2.x, we force pages to load serially. If you right-click and > open in a new window/tab, you should get the page provided that no > other pages are loading in that session at the time. > > However, for some reason, I am getting htat problem on some reports. > The problem will not occur in 1.3, and I will be tracking it down in > 1.2 when I get a chance unless someone else gets there first. This is > a fairly low priority because it doesn't happen in /trunk/ and because > there are simple workarounds for things like printing. What if you left click in the frame you want to print, then go to File -> Print then under Print Frames, select The selected frame. This seems to work for me in Firefox on Fedora 7 and Windows XP. Richard - 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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Reversing service invoice howto
Thank you very much for your quick response. This seemed to work. After I clicked update, it automatically filled in the amounts (one negative and one positive) then in amounts at the top, I entered 0. This works fine for now but any of my larger clients would require a separate credit memo number. I'm guessing this would work if I created a new invoice for the same client with the same item only with the quantity as a negative. Thanks again. Richard On 10/17/07, Chris Travers <[EMAIL PROTECTED]> wrote: > On 10/17/07, Richard Hernandez <[EMAIL PROTECTED]> wrote: > > Hello, > > > > What's the proper way to reverse/credit an invoice? I tried editing > > the posted invoice and changing the quantity to negative and it seems > > to work but it still shows on the outstanding transaction report. Is > > there a way to apply the credit to the original invoice? > > At the moment, what you do is issue or receive a payment of $0, and > check both invoices. > > We need to rethink this in 1.4. > > Best Wishes, > Chris Travers > > - > 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/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] reversing a customer invoice
What Chris Travers told me was to enter a customer receipt of $0 and select both invoices. The total of both invoices should be $0. This will remove them from the outstanding invoice report. It worked for me. Richard On 10/22/07, Tobias McNulty <[EMAIL PROTECTED]> wrote: > I made a duplicate entry of a customer invoice and am trying to figure out > the right way to get rid of it. I entered reversing transactions for all > the corresponding accounts in the general ledger. It seems to work but > there are obviously still 2 invoices there, which is kind of confusing > when it comes time to actually invoice my customers. Is there a better > way? > > Thanks, > Toby > > > - > 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/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-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/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] 1.2.10 Released
Would upgrading involve just backing up ledgersmb.conf and doing an rpm -Uvh? I didn't see anything on your website. Thanks. Richard On Dec 7, 2007 3:06 PM, Christopher Murtagh <[EMAIL PROTECTED]> wrote: > > The LedgerSMB team is pleased to announce the release of LedgerSMB 1.2.10. > This release notice, as well as a link to the SourceForge download is on our > website here: > > http://ledgersmb.org/node/57 > > Changelog for 1.2.10 > * Fixed bug 1765161, post button duplicates invoices.(Chris T) > * Adding a minor fixes to COGS edge cases for reversed invoices. (Chris T) > * Fixed bug 1811022. Closedto date problems (Seneca) > * Fixing error on parts cost display, bug 1811470 (Chris T) > * fixed oversight with required_debs.txt name (Joshua D) > * Removing stray quote from button label, bug 181 (Seneca) > * Increasing min DBI version (Seneca) > * Apply db_parse_numeric to the correct hashref, fixes 1815081(Seneca) > * Fixed 1815075, Subject of email improperly encoded) (Seneca) > * Set template file output to UTF8 (Seneca) > * Body encoding fixes (Seneca) > * Fixing message-id setting (Seneca) > * Drawer opening now uses correct printer designation (Chris T) > * Change issued is now entered with correct memo field. (Chris T) > * Closing tell report works as advertised (Chris T) > * Fixed 1814437, Multiple paths set causing errors (Seneca) > * Add the ampersand to the HTML escape list for parse_template (Seneca) > * fixed 1815329, $ not escaped properly for LaTeX (Seneca) > * updated Hungarian translation from Pongrácz István (patch 1814156, Seneca) > * Properly handle invoice-type quantities from customer search (Seneca) > * Correcting improper redirect when reposting POS invoices.(Chris T) > * Fixing issues relating to database queries and POS-module redirects (Seneca) > * Fixing bug which hides discount input in POS screen. (Chris T) > * Fixing bug: Obsolete items show on short parts report(Chris T) > * Fixed bugs handling floats as numbers from the database (Seneca) > * Fixing POS screen opening drawer when print/post triggers update (Chris T) > * Add missing $parts_id to query in add_items_required (Seneca) > * Fix purchase order generation screen display (Seneca) > * Shift the extraction of invnumber down a few lines (fixes 1820572, Seneca) > * Fixing bug 1831246, doubleparsing in RC.pm (Seneca) > * Fixing bug 1831410, double parsing in recurring transactions (Seneca) > * Fixed bug 1820698, DBI error: value too long (Seneca) > * Adding db fix script for 1819483 (Chris T) > * Removing duplicate drawer open (Chris T) > * Adding db fix script for primary key in recurring table (Seneca) > * Fix for bug 1831402, session expired re: recurring emails (Seneca) > * More number formatting fixes (Seneca) > * Encoding fixes for the backup routines (Seneca) > > > - > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] 1.2.10 Released
Thanks for the input. I used an RPM to install so would I be able to use the new RPM to upgrade or should I just replace the files? Thanks. Richard On Dec 10, 2007 8:54 AM, Chris Travers <[EMAIL PROTECTED]> wrote: > > > > On Dec 9, 2007 12:16 PM, Pongracz Istvan <[EMAIL PROTECTED]> wrote: > > 2007. 12. 9, vasárnap keltezéssel 11.51-kor Richard Hernandez ezt írta: > > > > > Would upgrading involve just backing up ledgersmb.conf and doing an > > > rpm -Uvh? I didn't see anything on your website. > > > > > > > Hi, > > > > AFAIK you should simply overwrite all files, except the configuration > > files. > > In the 1.2.x, the database doesn't change. > > That is correct. If the rpm overwrites the configuration files then that is > a bug and needs to be reported. > > > > > > > Anyway, before you do it, make backup for everything ;) > > backups are golden. > > Best Wishes, > Chris Travers > > > - > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Vendor item numbers on purchase order
Hello, Is there any way of either displaying the vendor item number instead of my item number or displaying both vendor and my item number on purchase orders? My item numbers are meaningless to vendors/suppliers. Also, many items are very similar so having the suppliers item number would be very desirable. Thanks. Richard - SF.Net email is sponsored by: 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 ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] RoadMap Question
Well I think the point in integrating the two was so you can share information instead of having to enter it multiple time. For example having to type a customers information once in LegerSMB and then again in whatever you use as a CRM not only introduces more chances of typos but also isn't very efficient because you need to remember to change any customer information (contacts, phone numbers, email addresses, etc.) in each application individually. Also, imaging being able to look up a contacts details in your CRM and have their entire purchase history and possibly special prices just a few clicks away. Just my thoughts. Richard On Jan 27, 2008 12:28 PM, Stroller <[EMAIL PROTECTED]> wrote: > > On 27 Jan 2008, at 18:32, Joshua D. Drake wrote: > > Chris Travers wrote: > > > >> H.. I guess I would scale back that promise a little :-) > >> > >> Most of the time when people speak of CRM they mean: > >> > >> 1) Contact management plus categorization > >> 2) Comment tracking > >> 3) Task tracking (i.e. sales opportunities, etc) > >> 4) Appointment Tracking > >> > >> 1.3 will do the first two quite well. It will not do everything that > >> people want from a "complete" CRM without some additional > >> extensions to > >> the database. I am sure these will come in the form of add-ons later > >> (any volunteers?) but they are not there now and there are no current > >> pkans to add scheduling and task tracking to the financial core of > >> the > >> application. > > > > Well I can easily add the data structure for three and four. > > The question is whether this is desirable. > Does LedgerSMB wish to compete with fully-functional CRMs? > > Personally, all I would like is that LedgerSMB be able to get contact > details from an LDAP database, or export its users using an LDAP > interface. > > For task & appointment tracking I use iCal on my notebook / desktop > machines, and am likely to look at Apple's iCal server - which is > free & open-source - in the near future. Unless you're planning an > "Exchange killer" then I find appointment tracking to be an > undesirable feature in Ledger SMB. > > Stroller. > > > - > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] RoadMap Question
On Jan 27, 2008 3:01 PM, William Hamilton <[EMAIL PROTECTED]> wrote: > Joshua D. Drake wrote: > > Chris Travers wrote: > > > >> H.. I guess I would scale back that promise a little :-) > >> > >> Most of the time when people speak of CRM they mean: > >> > >> 1) Contact management plus categorization > >> 2) Comment tracking > >> 3) Task tracking (i.e. sales opportunities, etc) > >> 4) Appointment Tracking > >> > >> 1.3 will do the first two quite well. It will not do everything that > >> people want from a "complete" CRM without some additional extensions to > >> the database. I am sure these will come in the form of add-ons later > >> (any volunteers?) but they are not there now and there are no current > >> pkans to add scheduling and task tracking to the financial core of the > >> application. > > > > Well I can easily add the data structure for three and four. > I like the idea of having the infrastructure there but preference would > be on making the CRM facilities more open to integration with specilised > CRMs which already exist than developing full suite from scratch and > possibly diverting resources to this area from the critical accounting > functionality. > > Saying that, yes I would use a CRM within the financial if it were there > but also aware of some other great OSS and CSS CRMs available. > > here endeth my 2c > > cheers > > > W > This sounds like it may work out better. You have to indivudual applications that can both be updated independently of each other. There was an attempt at such a thing with webERP and Vtiger. Actually the company that accomplished this is selling it as a complete package. Vtiger has the quote, price list, orders, etc. sections already there. Maybe this may be an easier path. Richard - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
[Ledger-smb-users] Customer's purchase order number on invoice
Hello, I just printed an invoice for a customer and noticed their purchase order number does not show anywhere on the invoice. How can I have this show on the invoice? Customers won't pay an invoice without their purchase order number on the invoice. Thank you. Richard Hernandez -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] Customer's purchase order number on invoice
On Thu, Nov 11, 2010 at 2:33 PM, Stroller wrote: > > On 11/11/2010, at 10:25pm, Stroller wrote: > > > > > On 11/11/2010, at 9:57pm, Richard Hernandez wrote: > >> I just printed an invoice for a customer and noticed their purchase > order number does not show anywhere on the invoice. How can I have this > show on the invoice? Customers won't pay an invoice without their purchase > order number on the invoice. > > > > Looks like: > > > > > > > > > > Opps.. correction, ignore the : > > > > > > I just grepped the templates directory for "po" and found this. The example > I posted was clearly part of an HTML table. You may find the "if" and "end" > statements are not needed, but only the middle "" - in > that case you may find that "NaN" or something is printed if there is no PO > number. > > Stroller. > > > > -- > Centralized Desktop Delivery: Dell and VMware Reference Architecture > Simplifying enterprise desktop deployment and management using > Dell EqualLogic storage and VMware View: A highly scalable, end-to-end > client virtualization framework. Read more! > http://p.sf.net/sfu/dell-eql-dev2dev > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > Thanks. I just came back to post that I figured it out and I saw your email. You are correct, You don't need the "if" part. I replaced "Shipping Point" with the purchase order number since I don't use it. Thanks for your input. Richard -- Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] LedgerSMB.org site temporarily down due to registrar issues
I have had VERY good customer service with gkg.net. I have a reseller account with them and they have answered everything on a timely basis and have never had any problems with them. I highly recommend them. Richard On Fri, Dec 3, 2010 at 12:27 PM, Chris Travers wrote: > Hi all; > > The LedgerSMB.org site is temporarily down due to DNS registrar > issues. The registrar just migrated some things around and somehow > managed to cause the root NS records to be lost. If this is not > corrected quickly, I'll be moving these to a new registry and DNS > hosting service. I am not happy with this incident and will likely > propose moving off them but the first issue is getting the site back > up if that can be quickly addressed. > > Just letting folks know we are aware of this issue and have not just > disappeared. > > Best Wishes, > Chris Travers > > > -- > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > Tap into the largest installed PC base & get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > ___ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > -- Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Re: [Ledger-smb-users] My Assessment of the Heartbleed OpenSSL bug and LedgerSMB
On 11/04/14 09:41, ario wrote: > On Thu, 10 Apr 2014 19:04:27 +0200 > Pongrácz István wrote: > >> > What if they implemented this "feature" to be able to get information >> > without trace? : > Then they would have succeeded spectacularly with us thinking "there is > a bug" in OpenSSL. > > My preferred beckup encryption scheme still would be the One Time Pad > (OTP) as it seems really unbreakable, if it were not for the recurrency > in the problem of: "Where do I backup the OTP itself, and how do I > encrypt it?" > Heartbleed isn't a problem with the encryption though; the encryption didn't get broken. Any protocol could probably potentially suffer from a buffer overflow due to a bug in the software. Given this one leaked info from the server process, who's to say it wouldn't leak your one-time pad? Richard -- Put Bad Developers to Shame Dominate Development with Jenkins Continuous Integration Continuously Automate Build, Test & Deployment Start a new project now. Try Jenkins in the cloud. http://p.sf.net/sfu/13600_Cloudbees ___ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
