Menu
▾
▴
sql-ledger-users
|
From: Munroe S. <so...@di...> - 2008-05-30 17:40:19
|
I am wondering how people perform trend analysis? I am looking to graph my AR and AP and different journals etc... It looks like sql-ledger has some very standard reports built-in but is there another tool that people use other than a spreadsheet? -- Munroe Sollog Systems Engineer Digirati Consulting, Inc so...@di... |
|
From: C. D. H. <du...@du...> - 2008-06-04 02:29:21
|
What kind of trends are you looking for? For sales analysis I wrote a little Perl script that is cron'd to run on the 5th day of each month (gives me a couple of days to fix any month end issues). The script summarizes each sales person's sales and receivables for the month. It also provides a delta of the month over the previous month and the month over the same month one year ago. Finally, it builds a nice little (electric company bill style) 13 month bar graph. The script then emails the personalized report to the salesperson and their manager. For inventory analysis I have a Perl script that is cron'd hourly. My reorder points (minimum), and EOQ are recalculated each time the script runs. When ever any of the stocked items falls below their minimum an email is fired off to the person who does the parts ordering. The script also does Pareto Analysis (ABC) and labels each item as such along with its percentage of both sales and revenue. Dunc Munroe Sollog wrote: > I am wondering how people perform trend analysis? > > I am looking to graph my AR and AP and different journals etc... It > looks like sql-ledger has some very standard reports built-in but is > there another tool that people use other than a spreadsheet? > > |
|
From: Ed W <li...@wi...> - 2008-06-06 11:27:42
|
C. Duncan Hudson wrote: > What kind of trends are you looking for? For sales analysis I wrote a > little Perl script that is cron'd to run on the 5th day of each month > (gives me a couple of days to fix any month end issues). The script > summarizes each sales person's sales and receivables for the month. It > also provides a delta of the month over the previous month and the month > over the same month one year ago. Finally, it builds a nice little > (electric company bill style) 13 month bar graph. The script then > emails the personalized report to the salesperson and their manager. > > For inventory analysis I have a Perl script that is cron'd hourly. My > reorder points (minimum), and EOQ are recalculated each time the script > runs. When ever any of the stocked items falls below their minimum an > email is fired off to the person who does the parts ordering. The > script also does Pareto Analysis (ABC) and labels each item as such > along with its percentage of both sales and revenue. > Can we see the scripts? Ed W |
|
From: Dieter S. <dsi...@sq...> - 2008-06-06 15:37:16
|
On Fri, 6 Jun 2008, Ed W wrote: > C. Duncan Hudson wrote: >> What kind of trends are you looking for? For sales analysis I wrote a >> little Perl script that is cron'd to run on the 5th day of each month >> (gives me a couple of days to fix any month end issues). The script >> summarizes each sales person's sales and receivables for the month. It >> also provides a delta of the month over the previous month and the month >> over the same month one year ago. Finally, it builds a nice little >> (electric company bill style) 13 month bar graph. The script then >> emails the personalized report to the salesperson and their manager. >> >> For inventory analysis I have a Perl script that is cron'd hourly. My >> reorder points (minimum), and EOQ are recalculated each time the script >> runs. When ever any of the stocked items falls below their minimum an >> email is fired off to the person who does the parts ordering. The >> script also does Pareto Analysis (ABC) and labels each item as such >> along with its percentage of both sales and revenue. >> > > Can we see the scripts? > > Ed W You are still here, why? http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel |
|
From: Dr E. W L. <el...@li...> - 2008-06-06 16:20:35
|
Oinking from the boinking :-)-O el On Jun 6, 2008, at 16:13, Dieter Simader wrote: > On Fri, 6 Jun 2008, Ed W wrote: > >> C. Duncan Hudson wrote: >>> What kind of trends are you looking for? For sales analysis I >>> wrote a >>> little Perl script that is cron'd to run on the 5th day of each >>> month >>> (gives me a couple of days to fix any month end issues). The script >>> summarizes each sales person's sales and receivables for the >>> month. It >>> also provides a delta of the month over the previous month and the >>> month >>> over the same month one year ago. Finally, it builds a nice little >>> (electric company bill style) 13 month bar graph. The script then >>> emails the personalized report to the salesperson and their manager. >>> >>> For inventory analysis I have a Perl script that is cron'd >>> hourly. My >>> reorder points (minimum), and EOQ are recalculated each time the >>> script >>> runs. When ever any of the stocked items falls below their >>> minimum an >>> email is fired off to the person who does the parts ordering. The >>> script also does Pareto Analysis (ABC) and labels each item as such >>> along with its percentage of both sales and revenue. >>> >> >> Can we see the scripts? >> >> Ed W > > You are still here, why? > > http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel > > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Ed W <li...@wi...> - 2008-06-06 17:40:31
|
Dieter Simader wrote: > On Fri, 6 Jun 2008, Ed W wrote: > > > You are still here, why? > > http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel > I am on SL 2.6.27 (which I have "outgrown"). I am trying to decide where to go next You have given me one more reason to reject continuing with SL - I need to find a system with good backup and support and your comments often "suggest" that I would not find it with SL - I get a strong sense that you would be happy to take my money upfront, but not be particularly forthcoming afterwards - please don't be insulted if you mean otherwise, I am only voicing my concerns For those watching at home I have previously (ok, minorly) supported SL to the tune of buying a single year of updates of "the manual". I lapsed for various reasons but until 10 minutes ago restarting support was a serious possibility. I have a total budget of around $20-40K for all the changes I need made to get whatever solution I pick to the point it works well for my needs. I get an increasingly strong sense that I'm not wanted by the SL community though... Good luck to you in any case - you have created a very compelling bit of software and deserve to profit from it - I am personally distressed by the serious problems I keep finding with it's adding up (fixable though I'm sure, which is why I'm still here), however, it has a very good GUI and a good feature set for many small businesses. It's just a shame that you seem to chase away some of your customers... Regards Ed W |
|
From: Jeff R. <je...@jr...> - 2008-06-06 18:59:04
|
Ed > but until 10 minutes ago restarting support > was a serious possibility. Give me a break! Do you have any idea how childish that sounds? Are you going to take your ball $$ and go home? You have 20K - 40K to spend on software but you're complaining on other lists about the SQL-Ledger then feigning hurt feelings when called on it? Grow up! Jeff Roberts Ed W wrote: > Dieter Simader wrote: > >> On Fri, 6 Jun 2008, Ed W wrote: >> >> >> You are still here, why? >> >> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel >> >> > > > I am on SL 2.6.27 (which I have "outgrown"). I am trying to decide > where to go next > > You have given me one more reason to reject continuing with SL - I need > to find a system with good backup and support and your comments often > "suggest" that I would not find it with SL - I get a strong sense that > you would be happy to take my money upfront, but not be particularly > forthcoming afterwards - please don't be insulted if you mean otherwise, > I am only voicing my concerns > > For those watching at home I have previously (ok, minorly) supported SL > to the tune of buying a single year of updates of "the manual". I > lapsed for various reasons but until 10 minutes ago restarting support > was a serious possibility. I have a total budget of around $20-40K for > all the changes I need made to get whatever solution I pick to the point > it works well for my needs. > > I get an increasingly strong sense that I'm not wanted by the SL > community though... > > Good luck to you in any case - you have created a very compelling bit of > software and deserve to profit from it - I am personally distressed by > the serious problems I keep finding with it's adding up (fixable though > I'm sure, which is why I'm still here), however, it has a very good GUI > and a good feature set for many small businesses. It's just a shame > that you seem to chase away some of your customers... > > > Regards > > Ed W > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: Ed W <li...@wi...> - 2008-06-06 22:29:55
|
Jeff Roberts wrote: > Ed > >> but until 10 minutes ago restarting support >> was a serious possibility. >> > Give me a break! Do you have any idea how childish that sounds? > No? I don't see why it would appear childish? Bottom line is that I have a business to run - this is not about which is my favourite or any other nonsense - just cold hard, "what enables me to get on with my job" Dieter asks "What are you still doing here". This does not sound to me like I'm being welcomed back no? > Are you going to take your ball $$ and go home? > Well that doesn't sound like you want me either? Yes - it's my money - I have to work very hard for it and yes I will spend it where I get best value. > You have 20K - 40K to spend on software but you're complaining on other > lists about the SQL-Ledger then feigning hurt feelings when called on it? > I have no idea where you are going with this? As I already said - SL is a fairly great bit of software and has got me so far - now I have outgrown (SL 2.6) and I need to move to something else. Right now I have narrowed it down to TinyERP, SL, LSMB and Hansaworld (big $$ package which I have since pretty much rejected). I need something sufficiently customised that I am prepared to spend some money on it to get what I need However, whatever the reality, perhaps its just a language barrier or whatever, but no matter why - I get a feeling of hostility from the SL community and just like now I don't get a strong sense that I will do well to risk the success of my business to some software where the community following it is as hostile as you are "Complaining" is the word you used - actually if you followed the conversation on the SL list (and read my private emails to Chris) then you would see that I have spent most time complaining about LSMB - it basically has most of the same problems (for me) as SL 2.6. So I'm not particularly "complaining" about SL, but lets be frank - it does not suit my needs - why is this a problem to you though? I still think Dieter has built a great bit of software - it just doesn't suit all my needs right now (2.6 remember) > Grow up! > Charming. Have I called you some names? I think it's not me who is being childish? Ed W |
|
From: Jeff R. <je...@jr...> - 2008-06-06 23:40:33
|
Hi Ed My apologies, maybe you genuinely didn't realize that your comment sounded juvenile to me, I guess I should have considered that before calling you childish. I sometimes forget that on the internet there are different cultures and nationalities and that not all of my childhood experiences were shared by all others. I apologize to the list for de-railing this thread. Where I grew up kids would use that pattern to try to make themselves look bigger or better, they would tell someone that they were about to give them something or do something nice but now that the other person had slighted them they were no longer willing to extend the friendship or gratuity. The truth was always that they had no intention of extending the gratuity in the first place but were only saying so to maliciously tease the other person. It went sort of like this: Billy calls Sally a boogerhead or some other such taunt. Sally says "I was going to give you some of my candy at lunch but now I'm not going to" The effort by Sally was to try to make Billy sorry for slighting Sally. Billy may think Sally was telling the truth the first time it happens and apologize or suck up but quickly learns from experience that Sally isn't being genuine. It was a childish game. Jeff Ed W wrote: > Jeff Roberts wrote: > >> Ed >> >> >>> but until 10 minutes ago restarting support >>> was a serious possibility. >>> >>> >> Give me a break! Do you have any idea how childish that sounds? >> >> > > No? I don't see why it would appear childish? > > Bottom line is that I have a business to run - this is not about which > is my favourite or any other nonsense - just cold hard, "what enables me > to get on with my job" > > Dieter asks "What are you still doing here". This does not sound to me > like I'm being welcomed back no? > > >> Are you going to take your ball $$ and go home? >> >> > > Well that doesn't sound like you want me either? > > Yes - it's my money - I have to work very hard for it and yes I will > spend it where I get best value. > > >> You have 20K - 40K to spend on software but you're complaining on other >> lists about the SQL-Ledger then feigning hurt feelings when called on it? >> >> > > I have no idea where you are going with this? > > As I already said - SL is a fairly great bit of software and has got me > so far - now I have outgrown (SL 2.6) and I need to move to something > else. Right now I have narrowed it down to TinyERP, SL, LSMB and > Hansaworld (big $$ package which I have since pretty much rejected). I > need something sufficiently customised that I am prepared to spend some > money on it to get what I need > > However, whatever the reality, perhaps its just a language barrier or > whatever, but no matter why - I get a feeling of hostility from the SL > community and just like now I don't get a strong sense that I will do > well to risk the success of my business to some software where the > community following it is as hostile as you are > > "Complaining" is the word you used - actually if you followed the > conversation on the SL list (and read my private emails to Chris) then > you would see that I have spent most time complaining about LSMB - it > basically has most of the same problems (for me) as SL 2.6. > > So I'm not particularly "complaining" about SL, but lets be frank - it > does not suit my needs - why is this a problem to you though? I still > think Dieter has built a great bit of software - it just doesn't suit > all my needs right now (2.6 remember) > > >> Grow up! >> >> > > Charming. > > Have I called you some names? I think it's not me who is being childish? > > Ed W > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: Mike <dra...@ih...> - 2008-06-07 01:43:11
|
Hi Ed, (Please note I am not trying to stir, or upset anyone, these are genuine questions from me) Out of curiosity you mention that you are running 2.6 and you have out grown it (congratulations, business must be going well for you). Have you tried the 2.8 series, does that cure some of the issues that you have? I noticed in the thread on LSMB that you were trying to gather momentum to get progress moving in a direction that you need, and that should be commended, as I think supporting any project should be. Personally I sit in the SQL-Ledger camp, as it does work for me in the minor capacity that I use it for. Yes I have tried LSMB, and whilst their goals are good, the product in my opinion isn't there yet. On Sat, 2008-06-07 at 02:11 +0100, Ed W wrote: > At the end of the day I just want to get some work done - by all means > try and demonstrate that SL still has a friendly and helpful community > >> So I'm not particularly "complaining" about SL, but lets be frank - it > >> does not suit my needs - why is this a problem to you though? I still > >> think Dieter has built a great bit of software - it just doesn't suit > >> all my needs right now (2.6 remember) |
|
From: Ed W <li...@wi...> - 2008-06-07 07:20:28
|
Hi > Out of curiosity you mention that you are running 2.6 and you have out > grown it (congratulations, business must be going well for you). Have > you tried the 2.8 series, does that cure some of the issues that you > have? > No I have stuck with 2.6 because it's about the last version which offers the opportunity to jump either to 2.8 or LSMB. At the moment it's not clear (to me) which is going to be my best option The main reason I am on the fence is that I simply don't get a warm feeling that I can get help longterm from the SL community, nor purchase development at a sensible price. Hey I could be very wrong - I'm just telling you what impression *I'm* getting from the tone from this community. 2.8 has some interesting features though. Regards Ed W |
|
From: Dr E. W L. <el...@li...> - 2008-06-07 07:54:49
|
Give it a rest now! el On Jun 7, 2008, at 02:11, Ed W wrote: > You are really labouring this aren't you? > > Why not just properly read before applying scathing comments - the > original comment came from Dieter who was commenting that he had seen > one of my comments to the LSMB guys. > > I commented (not unreasonably) that the SL community appears > frequently > hostile and you then proved my point with your rather pointless > attacks > (Dieter wasn't too warm either) > > At the end of the day I just want to get some work done - by all means > try and demonstrate that SL still has a friendly and helpful community > to work with, but so far I'm not impressed. > > Regards > > Ed W > > > Jeff Roberts wrote: >> Hi Ed >> >> My apologies, maybe you genuinely didn't realize that your comment >> sounded juvenile to me, I guess I should have considered that before >> calling you childish. I sometimes forget that on the internet there >> are >> different cultures and nationalities and that not all of my childhood >> experiences were shared by all others. >> >> I apologize to the list for de-railing this thread. >> >> Where I grew up kids would use that pattern to try to make themselves >> look bigger or better, they would tell someone that they were about >> to >> give them something or do something nice but now that the other >> person >> had slighted them they were no longer willing to extend the >> friendship >> or gratuity. The truth was always that they had no intention of >> extending the gratuity in the first place but were only saying so to >> maliciously tease the other person. >> >> It went sort of like this: >> >> Billy calls Sally a boogerhead or some other such taunt. >> >> Sally says "I was going to give you some of my candy at lunch but now >> I'm not going to" >> >> The effort by Sally was to try to make Billy sorry for slighting >> Sally. >> >> Billy may think Sally was telling the truth the first time it happens >> and apologize or suck up but quickly learns from experience that >> Sally >> isn't being genuine. >> >> It was a childish game. >> >> Jeff >> >> >> Ed W wrote: >> >>> Jeff Roberts wrote: >>> >>> >>>> Ed >>>> >>>> >>>> >>>>> but until 10 minutes ago restarting support >>>>> was a serious possibility. >>>>> >>>>> >>>>> >>>> Give me a break! Do you have any idea how childish that sounds? >>>> >>>> >>>> >>> No? I don't see why it would appear childish? >>> >>> Bottom line is that I have a business to run - this is not about >>> which >>> is my favourite or any other nonsense - just cold hard, "what >>> enables me >>> to get on with my job" >>> >>> Dieter asks "What are you still doing here". This does not sound >>> to me >>> like I'm being welcomed back no? >>> >>> >>> >>>> Are you going to take your ball $$ and go home? >>>> >>>> >>>> >>> Well that doesn't sound like you want me either? >>> >>> Yes - it's my money - I have to work very hard for it and yes I will >>> spend it where I get best value. >>> >>> >>> >>>> You have 20K - 40K to spend on software but you're complaining on >>>> other >>>> lists about the SQL-Ledger then feigning hurt feelings when >>>> called on it? >>>> >>>> >>>> >>> I have no idea where you are going with this? >>> >>> As I already said - SL is a fairly great bit of software and has >>> got me >>> so far - now I have outgrown (SL 2.6) and I need to move to >>> something >>> else. Right now I have narrowed it down to TinyERP, SL, LSMB and >>> Hansaworld (big $$ package which I have since pretty much >>> rejected). I >>> need something sufficiently customised that I am prepared to spend >>> some >>> money on it to get what I need >>> >>> However, whatever the reality, perhaps its just a language barrier >>> or >>> whatever, but no matter why - I get a feeling of hostility from >>> the SL >>> community and just like now I don't get a strong sense that I will >>> do >>> well to risk the success of my business to some software where the >>> community following it is as hostile as you are >>> >>> "Complaining" is the word you used - actually if you followed the >>> conversation on the SL list (and read my private emails to Chris) >>> then >>> you would see that I have spent most time complaining about LSMB - >>> it >>> basically has most of the same problems (for me) as SL 2.6. >>> >>> So I'm not particularly "complaining" about SL, but lets be frank >>> - it >>> does not suit my needs - why is this a problem to you though? I >>> still >>> think Dieter has built a great bit of software - it just doesn't >>> suit >>> all my needs right now (2.6 remember) >>> >>> >>> >>>> Grow up! >>>> >>>> >>>> >>> Charming. >>> >>> Have I called you some names? I think it's not me who is being >>> childish? >>> >>> Ed W >>> ------------------------------------------------------------------------- >>> 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 >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>> >>> >>> >>> >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Ed W <li...@wi...> - 2008-06-08 06:07:58
|
Dr Eberhard W Lisse wrote: > Give it a rest now! > > el > You're not to polite either are you.... Ed W |
|
From: Ed W <li...@wi...> - 2008-06-07 01:11:45
|
You are really labouring this aren't you? Why not just properly read before applying scathing comments - the original comment came from Dieter who was commenting that he had seen one of my comments to the LSMB guys. I commented (not unreasonably) that the SL community appears frequently hostile and you then proved my point with your rather pointless attacks (Dieter wasn't too warm either) At the end of the day I just want to get some work done - by all means try and demonstrate that SL still has a friendly and helpful community to work with, but so far I'm not impressed. Regards Ed W Jeff Roberts wrote: > Hi Ed > > My apologies, maybe you genuinely didn't realize that your comment > sounded juvenile to me, I guess I should have considered that before > calling you childish. I sometimes forget that on the internet there are > different cultures and nationalities and that not all of my childhood > experiences were shared by all others. > > I apologize to the list for de-railing this thread. > > Where I grew up kids would use that pattern to try to make themselves > look bigger or better, they would tell someone that they were about to > give them something or do something nice but now that the other person > had slighted them they were no longer willing to extend the friendship > or gratuity. The truth was always that they had no intention of > extending the gratuity in the first place but were only saying so to > maliciously tease the other person. > > It went sort of like this: > > Billy calls Sally a boogerhead or some other such taunt. > > Sally says "I was going to give you some of my candy at lunch but now > I'm not going to" > > The effort by Sally was to try to make Billy sorry for slighting Sally. > > Billy may think Sally was telling the truth the first time it happens > and apologize or suck up but quickly learns from experience that Sally > isn't being genuine. > > It was a childish game. > > Jeff > > > Ed W wrote: > >> Jeff Roberts wrote: >> >> >>> Ed >>> >>> >>> >>>> but until 10 minutes ago restarting support >>>> was a serious possibility. >>>> >>>> >>>> >>> Give me a break! Do you have any idea how childish that sounds? >>> >>> >>> >> No? I don't see why it would appear childish? >> >> Bottom line is that I have a business to run - this is not about which >> is my favourite or any other nonsense - just cold hard, "what enables me >> to get on with my job" >> >> Dieter asks "What are you still doing here". This does not sound to me >> like I'm being welcomed back no? >> >> >> >>> Are you going to take your ball $$ and go home? >>> >>> >>> >> Well that doesn't sound like you want me either? >> >> Yes - it's my money - I have to work very hard for it and yes I will >> spend it where I get best value. >> >> >> >>> You have 20K - 40K to spend on software but you're complaining on other >>> lists about the SQL-Ledger then feigning hurt feelings when called on it? >>> >>> >>> >> I have no idea where you are going with this? >> >> As I already said - SL is a fairly great bit of software and has got me >> so far - now I have outgrown (SL 2.6) and I need to move to something >> else. Right now I have narrowed it down to TinyERP, SL, LSMB and >> Hansaworld (big $$ package which I have since pretty much rejected). I >> need something sufficiently customised that I am prepared to spend some >> money on it to get what I need >> >> However, whatever the reality, perhaps its just a language barrier or >> whatever, but no matter why - I get a feeling of hostility from the SL >> community and just like now I don't get a strong sense that I will do >> well to risk the success of my business to some software where the >> community following it is as hostile as you are >> >> "Complaining" is the word you used - actually if you followed the >> conversation on the SL list (and read my private emails to Chris) then >> you would see that I have spent most time complaining about LSMB - it >> basically has most of the same problems (for me) as SL 2.6. >> >> So I'm not particularly "complaining" about SL, but lets be frank - it >> does not suit my needs - why is this a problem to you though? I still >> think Dieter has built a great bit of software - it just doesn't suit >> all my needs right now (2.6 remember) >> >> >> >>> Grow up! >>> >>> >>> >> Charming. >> >> Have I called you some names? I think it's not me who is being childish? >> >> Ed W >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> >> >> > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Luke <sl...@li...> - 2008-06-06 20:10:28
|
Ledgersmb's got its issues, but it's on the road to becoming rather good. More than one developer for a start, and the developers actually welcome conversation with the users, instead of asking sarcastic questions seemingly designed to alienate them. Apparently enough is going on there, that Dieter finds it useful to monitor their development list, else he would not have had that post to throw in Ed's face. Not that there's anything wrong with him monitoring it--this is open source, after all. On Fri, 6 Jun 2008, Michael Hasse wrote: > Wow! > I mean, just... wow! > So I guess a lot of people are moving to LedgerSMB then? > > > Thanks, > > Michael > > > On Jun 6, 2008, at 8:13 AM, Dieter Simader wrote: > > > On Fri, 6 Jun 2008, Ed W wrote: > > > >> C. Duncan Hudson wrote: > >>> What kind of trends are you looking for? For sales analysis I > >>> wrote a > >>> little Perl script that is cron'd to run on the 5th day of each > >>> month > >>> (gives me a couple of days to fix any month end issues). The script > >>> summarizes each sales person's sales and receivables for the > >>> month. It > >>> also provides a delta of the month over the previous month and > >>> the month > >>> over the same month one year ago. Finally, it builds a nice little > >>> (electric company bill style) 13 month bar graph. The script then > >>> emails the personalized report to the salesperson and their manager. > >>> > >>> For inventory analysis I have a Perl script that is cron'd > >>> hourly. My > >>> reorder points (minimum), and EOQ are recalculated each time the > >>> script > >>> runs. When ever any of the stocked items falls below their > >>> minimum an > >>> email is fired off to the person who does the parts ordering. The > >>> script also does Pareto Analysis (ABC) and labels each item as such > >>> along with its percentage of both sales and revenue. > >>> > >> > >> Can we see the scripts? > >> > >> Ed W > > > > You are still here, why? > > > > http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA. > > 7000309%40wildgooses.com&forum_name=ledger-smb-devel > > > > > > ---------------------------------------------------------------------- > > --- > > 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 > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > -- "The best way to destroy the capitalist system is to debauch the currency." - Vladimir Lenin |
|
From: Dr E. L. <el...@li...> - 2008-06-06 21:13:48
|
Nonsense. el on 6/6/08 9:10 PM Luke said the following: > Ledgersmb's got its issues, but it's on the road to becoming rather good. > More than one developer for a start, and the developers actually welcome > conversation with the users, instead of asking sarcastic questions > seemingly designed to alienate them. > > Apparently enough is going on there, that Dieter finds it useful to > monitor their development list, else he would not have had that post to > throw in Ed's face. Not that there's anything wrong with him monitoring > it--this is open source, after all. > > On Fri, 6 Jun 2008, Michael Hasse wrote: > >> Wow! >> I mean, just... wow! >> So I guess a lot of people are moving to LedgerSMB then? >> >> >> Thanks, >> >> Michael >> >> >> On Jun 6, 2008, at 8:13 AM, Dieter Simader wrote: >> >>> On Fri, 6 Jun 2008, Ed W wrote: >>> >>>> C. Duncan Hudson wrote: >>>>> What kind of trends are you looking for? For sales analysis I >>>>> wrote a >>>>> little Perl script that is cron'd to run on the 5th day of each >>>>> month >>>>> (gives me a couple of days to fix any month end issues). The script >>>>> summarizes each sales person's sales and receivables for the >>>>> month. It >>>>> also provides a delta of the month over the previous month and >>>>> the month >>>>> over the same month one year ago. Finally, it builds a nice little >>>>> (electric company bill style) 13 month bar graph. The script then >>>>> emails the personalized report to the salesperson and their manager. >>>>> >>>>> For inventory analysis I have a Perl script that is cron'd >>>>> hourly. My >>>>> reorder points (minimum), and EOQ are recalculated each time the >>>>> script >>>>> runs. When ever any of the stocked items falls below their >>>>> minimum an >>>>> email is fired off to the person who does the parts ordering. The >>>>> script also does Pareto Analysis (ABC) and labels each item as such >>>>> along with its percentage of both sales and revenue. >>>>> >>>> Can we see the scripts? >>>> >>>> Ed W >>> You are still here, why? >>> >>> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA. >>> 7000309%40wildgooses.com&forum_name=ledger-smb-devel >>> >>> >>> ---------------------------------------------------------------------- >>> --- >>> 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 >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > -- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist (Saar) el...@li... el108-ARIN / * | Telephone: +264 81 124 6733 (cell) PO Box 8421 \ / Please do NOT email to this address Bachbrecht, Namibia ;____/ if it is DNS related in ANY way |
|
From: Armaghan S. <sa...@le...> - 2008-06-07 08:00:17
|
On Fri, Jun 6, 2008 at 4:27 PM, Ed W <li...@wi...> wrote: > C. Duncan Hudson wrote: >> What kind of trends are you looking for? For sales analysis I wrote a >> little Perl script that is cron'd to run on the 5th day of each month > Can we see the scripts? I did some work using GD::Graph a while back for a client. It was something really easy and simple. Quick search could not find it. Let me find this script and I shall post it here for you all. Best Regards -- * Purpose-built SQL-Ledger Hosting. Free trial. * SQL-Ledger VMware Appliance. Free download. http://www.ledger123.com/ -- |
|
From: C. D. H. <du...@du...> - 2008-06-18 19:29:05
|
Sorry, I've been out of the loop for awhile. Send me a message off list and I'll send you a copy of the script. Dunc Ed W wrote: > C. Duncan Hudson wrote: > >> What kind of trends are you looking for? For sales analysis I wrote a >> little Perl script that is cron'd to run on the 5th day of each month >> (gives me a couple of days to fix any month end issues). The script >> summarizes each sales person's sales and receivables for the month. It >> also provides a delta of the month over the previous month and the month >> over the same month one year ago. Finally, it builds a nice little >> (electric company bill style) 13 month bar graph. The script then >> emails the personalized report to the salesperson and their manager. >> >> For inventory analysis I have a Perl script that is cron'd hourly. My >> reorder points (minimum), and EOQ are recalculated each time the script >> runs. When ever any of the stocked items falls below their minimum an >> email is fired off to the person who does the parts ordering. The >> script also does Pareto Analysis (ABC) and labels each item as such >> along with its percentage of both sales and revenue. >> >> > > Can we see the scripts? > > Ed W > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
|
From: Dr E. W L. <el...@li...> - 2008-06-06 16:17:34
|
Me three, please :-)-O el On Jun 4, 2008, at 03:29, C. Duncan Hudson wrote: > What kind of trends are you looking for? For sales analysis I wrote a > little Perl script that is cron'd to run on the 5th day of each month > (gives me a couple of days to fix any month end issues). The script > summarizes each sales person's sales and receivables for the month. > It > also provides a delta of the month over the previous month and the > month > over the same month one year ago. Finally, it builds a nice little > (electric company bill style) 13 month bar graph. The script then > emails the personalized report to the salesperson and their manager. > > For inventory analysis I have a Perl script that is cron'd hourly. > My > reorder points (minimum), and EOQ are recalculated each time the > script > runs. When ever any of the stocked items falls below their minimum an > email is fired off to the person who does the parts ordering. The > script also does Pareto Analysis (ABC) and labels each item as such > along with its percentage of both sales and revenue. > > Dunc > > Munroe Sollog wrote: >> I am wondering how people perform trend analysis? >> >> I am looking to graph my AR and AP and different journals etc... It >> looks like sql-ledger has some very standard reports built-in but is >> there another tool that people use other than a spreadsheet? >> >> > > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Dieter S. <dsi...@sq...> - 2008-06-06 18:12:30
|
I asked a simple question and you hurle insults. Is it so hard to provide a reasonable answer rather than you getting all uptight about feeling rejected. On Fri, 6 Jun 2008, Ed W wrote: > Dieter Simader wrote: >> On Fri, 6 Jun 2008, Ed W wrote: >> >> >> You are still here, why? >> >> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel >> > > > I am on SL 2.6.27 (which I have "outgrown"). I am trying to decide > where to go next > > You have given me one more reason to reject continuing with SL - I need > to find a system with good backup and support and your comments often > "suggest" that I would not find it with SL - I get a strong sense that > you would be happy to take my money upfront, but not be particularly > forthcoming afterwards - please don't be insulted if you mean otherwise, > I am only voicing my concerns > > For those watching at home I have previously (ok, minorly) supported SL > to the tune of buying a single year of updates of "the manual". I > lapsed for various reasons but until 10 minutes ago restarting support > was a serious possibility. I have a total budget of around $20-40K for > all the changes I need made to get whatever solution I pick to the point > it works well for my needs. > > I get an increasingly strong sense that I'm not wanted by the SL > community though... > > Good luck to you in any case - you have created a very compelling bit of > software and deserve to profit from it - I am personally distressed by > the serious problems I keep finding with it's adding up (fixable though > I'm sure, which is why I'm still here), however, it has a very good GUI > and a good feature set for many small businesses. It's just a shame > that you seem to chase away some of your customers... > > > Regards > > Ed W > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Ed W <li...@wi...> - 2008-06-06 22:39:13
|
Dieter Simader wrote: > I asked a simple question and you hurle insults. > Hmm, you asked: "Why are you still here?" - doesn't seem like a warm greeting? and I wrote back (in part) "Good luck to you in any case - you have created a very compelling bit of software and deserve to profit from it" - this was suppose to be a compliment no? There are no insults being hurled here and none of the rest of my email was meant to cause offence - specifically the bit where I say: "please don't be insulted if you mean otherwise" should be a clue? Your software has served me well for a couple of years now and I tried to thank you for that... I don't see that it's an insult that I am now looking for something which fits my needs more closely as my business has started to expand? I even have a small budget to pay to get what I need... > Is it so hard to provide a reasonable answer rather than you getting all > uptight about feeling rejected. > I tried hard to give you a reasonable answer. Whether you intend to or not, the reality is that *your* emails appear to me to be hostile. If you don't intend them to be that way then I think you need to try harder to make that clear. Your email certainly doesn't warm me to the idea that I should risk my development capital with SL, but lets be clear: there is no bullshit here, I *need* something which suits *my* business processes better than SL 2.6 and I need it soon. It could be SL 2.8, but I don't get a warm feeling that I am going to get what I need from the SL community, but you are welcome to at least try and extend an olive branch if my business is interesting? "Non hostile" regards from a current user Ed W >> Dieter Simader wrote: >> >>> On Fri, 6 Jun 2008, Ed W wrote: >>> >>> >>> You are still here, why? >>> >>> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel >>> >>> >> I am on SL 2.6.27 (which I have "outgrown"). I am trying to decide >> where to go next >> >> |
|
From: C. D. H. <du...@du...> - 2008-06-18 19:28:20
|
"Hello pot? This is kettle..." One might look through this list and say the same to you! Dieter Simader wrote: > I asked a simple question and you hurle insults. > > Is it so hard to provide a reasonable answer rather than you getting all > uptight about feeling rejected. > > > On Fri, 6 Jun 2008, Ed W wrote: > > >> Dieter Simader wrote: >> >>> On Fri, 6 Jun 2008, Ed W wrote: >>> >>> >>> You are still here, why? >>> >>> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel >>> >>> >> I am on SL 2.6.27 (which I have "outgrown"). I am trying to decide >> where to go next >> >> You have given me one more reason to reject continuing with SL - I need >> to find a system with good backup and support and your comments often >> "suggest" that I would not find it with SL - I get a strong sense that >> you would be happy to take my money upfront, but not be particularly >> forthcoming afterwards - please don't be insulted if you mean otherwise, >> I am only voicing my concerns >> >> For those watching at home I have previously (ok, minorly) supported SL >> to the tune of buying a single year of updates of "the manual". I >> lapsed for various reasons but until 10 minutes ago restarting support >> was a serious possibility. I have a total budget of around $20-40K for >> all the changes I need made to get whatever solution I pick to the point >> it works well for my needs. >> >> I get an increasingly strong sense that I'm not wanted by the SL >> community though... >> >> Good luck to you in any case - you have created a very compelling bit of >> software and deserve to profit from it - I am personally distressed by >> the serious problems I keep finding with it's adding up (fixable though >> I'm sure, which is why I'm still here), however, it has a very good GUI >> and a good feature set for many small businesses. It's just a shame >> that you seem to chase away some of your customers... >> >> >> Regards >> >> Ed W >> >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
|
From: J.M. \Jersey\ M. <je...@ib...> - 2008-06-07 08:24:26
|
"little" scripts are "biiig" for some people :). Would you share it? Best regards "Jersey" -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of C. Duncan Hudson Sent: 04 June 2008 04:29 AM To: sql...@li... Subject: Re: [SL] Trend analysis What kind of trends are you looking for? For sales analysis I wrote a little Perl script that is cron'd to run on the 5th day of each month (gives me a couple of days to fix any month end issues). The script summarizes each sales person's sales and receivables for the month. It also provides a delta of the month over the previous month and the month over the same month one year ago. Finally, it builds a nice little (electric company bill style) 13 month bar graph. The script then emails the personalized report to the salesperson and their manager. For inventory analysis I have a Perl script that is cron'd hourly. My reorder points (minimum), and EOQ are recalculated each time the script runs. When ever any of the stocked items falls below their minimum an email is fired off to the person who does the parts ordering. The script also does Pareto Analysis (ABC) and labels each item as such along with its percentage of both sales and revenue. Dunc Munroe Sollog wrote: > I am wondering how people perform trend analysis? > > I am looking to graph my AR and AP and different journals etc... It > looks like sql-ledger has some very standard reports built-in but is > there another tool that people use other than a spreadsheet? > > ------------------------------------------------------------------------- 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 _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.6/1481 - Release Date: 6/3/2008 7:31 PM |
|
From: Michael H. <mh...@it...> - 2008-06-06 16:39:33
|
Wow!
I mean, just... wow!
So I guess a lot of people are moving to LedgerSMB then?
Thanks,
Michael
On Jun 6, 2008, at 8:13 AM, Dieter Simader wrote:
> On Fri, 6 Jun 2008, Ed W wrote:
>
>> C. Duncan Hudson wrote:
>>> What kind of trends are you looking for? For sales analysis I
>>> wrote a
>>> little Perl script that is cron'd to run on the 5th day of each
>>> month
>>> (gives me a couple of days to fix any month end issues). The script
>>> summarizes each sales person's sales and receivables for the
>>> month. It
>>> also provides a delta of the month over the previous month and
>>> the month
>>> over the same month one year ago. Finally, it builds a nice little
>>> (electric company bill style) 13 month bar graph. The script then
>>> emails the personalized report to the salesperson and their manager.
>>>
>>> For inventory analysis I have a Perl script that is cron'd
>>> hourly. My
>>> reorder points (minimum), and EOQ are recalculated each time the
>>> script
>>> runs. When ever any of the stocked items falls below their
>>> minimum an
>>> email is fired off to the person who does the parts ordering. The
>>> script also does Pareto Analysis (ABC) and labels each item as such
>>> along with its percentage of both sales and revenue.
>>>
>>
>> Can we see the scripts?
>>
>> Ed W
>
> You are still here, why?
>
> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.
> 7000309%40wildgooses.com&forum_name=ledger-smb-devel
>
>
> ----------------------------------------------------------------------
> ---
> 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
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X