Ryan MacFarlane | 1 Aug 14:22 2010
Picon

Re: New to list + SMTP authentication when sending email


On 22/07/10 02:48 PM, Schmiechen wrote:
> According to (RFC 4409 I think)  a email sent from a domain other than the
> business own true domain is now technically spam.
>
> Currently the design intent of Ledgersmb is to support multiple businesses in
> its DB hence one install of code supports several different businesses.
> Each business has a unique DB different from the ledgersmb admin Db. Each
> business has a "defaults table". Mail prefs should be stored there.
>
> There is one user apache on the linux system running ledgersmb and sending
> mail.
> Each company using the ledgersmb system has a unique website/mail solution
> that is not in the same domain or network as the Ledgersmb server.
>
> Most businesses have dedicated mail servers they rent or maintain themselves.
> It is more practical security to have the accounting server in the office and
> not share with the mail server in a data canter.
> Also some mail providers flag mail from DSL lines as spam.
>
> I think to send out the most professional looking invoices and such Ledgersmb
> should act as a email client, and have the option send mail to a smtp host on
> port 587.  That way each business can send from there own email server.
>
> The patch we are talking about is really small, I tried this in Mailer.pm:
>
>     if ( ${LedgerSMB::Sysconfig::smtphost} ) {
>          if ( ${LedgerSMB::Sysconfig::smtpauthmethod} ){
>              $smtp = Net::SMTP::TLS->new( ${LedgerSMB::Sysconfig::smtphost},
>                  ${LedgerSMB::Sysconfig::smtpport},
(Continue reading)

Michael Richardson | 3 Aug 18:19 2010
Picon

Re: Features you would like to see in 2.0


>>>>> "Jeff" == Jeff Kowalczyk <jtk@...> writes:
    >> What features would you like to see in 2.0?

    Jeff> A Perl http mini server suitable for testing and debugging the
    Jeff> code during development and customization, prior to production
    Jeff> deployment.

I have this code, and I'm trying to post it.

Well, it's not perl http. It's some scripts that setup apache+postgresql
running in $PWD and running as $USER.  

What's I'd really like to do is to move all the stuff that needs to be
visible to the web server under "htdocs" or some other subdir, and use a
proper perl search path to get the rest from another directory. 

As this slightly changes how you can install ledgersmb: it's no longer
untar into subdir of /var/www, but rather, untar somewhere, and edit
apache.conf to point /ledgersmb -> DIR/htdocs, I don't know how welcome
this would be.  (Mind you: the debian dpkg already does this)

--

-- 
]       He who is tired of Weird Al is tired of life!           |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr@... http://www.sandelman.ottawa.on.ca/
|device driver[
   Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE>
	               then sign the petition. 

(Continue reading)

Ed W | 4 Aug 09:29 2010

Re: Features you would like to see in 2.0


Hi

* Automaticly refresh currency exchange rate from official web services (configurable somehow: when, from, which with multiple currencies). Example: In Hungary we must use www.mnb.hu, others should use anything else. Exchange rate should be like this: HUF/USD: 216,99 (Configurable)

This seems like a solution which could be contributed as a "plugin" of sorts?  Anyone want to step up?

I should think the solution will be found (or end up) on CPAN.  Quick search there shows a few:
    Finance::Currency::Convert::XE
    Finance::Currency::Convert::WebserviceX
    Finance::Quote
    Finance::Currency::Convert::Yahoo

Actually this raises the good point about checking T&Cs on any data source used.  XE has some specific T&Cs if you haven't paid for the data


Those not using XE for commercial purposes and hence not violating their T&Cs might consider something like the following script as a quick fix (run it via cron at a specific time of the day)

---------------------------------
#!/bin/bash

if [ $1 ]; then
    TODAY=$1
else
    TODAY=`date --rfc-3339='date'`
fi

# get exchangerate from XE
USD=`lynx -dump "http://www.xe.com/ucc/convert.cgi?Amount=1&From=USD&To=GBP" | grep "1 USD =" | awk '{print $4}'`
EUR=`lynx -dump "http://www.xe.com/ucc/convert.cgi?Amount=1&From=EUR&To=GBP" | grep "1 EUR =" | awk '{print $4}'`
if [ -n $EUR ] ; then
    EXIST=`psql -U sql-ledger -t -c "SELECT * FROM exchangerate WHERE curr = 'EUR' AND transdate = '$TODAY';" nippynetworks`
    if [ -n "$EXIST" ] ; then
    psql -U sql-ledger -q -c "DELETE FROM exchangerate WHERE curr='EUR' AND transdate='$TODAY';" nippynetworks
    fi
#    echo "EUR: $EUR"
    psql -U sql-ledger -q -c "INSERT INTO exchangerate (curr,transdate,buy,sell) VALUES('EUR','$TODAY',$EUR + 0.01,$EUR);" nippynetworks
else
    echo "Failed to retrieve EUR rates"
fi

if [ -n $USD ] ; then
    EXIST=`psql -U sql-ledger -t -c "SELECT * FROM exchangerate WHERE curr = 'USD' AND transdate = '$TODAY';" nippynetworks`
    if [ -n "$EXIST" ] ; then
    psql -U sql-ledger -q -c "DELETE FROM exchangerate WHERE curr='USD' AND transdate='$TODAY';" nippynetworks
    fi
#    echo "USD: $USD"
    psql -U sql-ledger -q -c "INSERT INTO exchangerate (curr,transdate,buy,sell) VALUES('USD','$TODAY',$USD + 0.01,$USD);" nippynetworks
else
    echo "Failed to retrieve USD rates"
fi
-----------------------------------
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Pongrácz István | 11 Aug 13:22 2010
Picon

Re: Features you would like to see in 2.0

Dear Ed,

Thank you very much for your email, it was really useful for me :)

It would be really nice to have a "plugin library" for common "problems" like exports, imports. Probably imports are more important than exports (depends on users).

Finally I figured out how to get a fresh currency from our government site (www.mnb.hu), which we have to use officially. We cannot use other source. Rules....

The trick is:

---------------------

TODDAY=`date +%Y.%m.%d.`
THISY=`date +%Y`

USD=`lynx -dump "http://mnb.hu/arfolyam-tablazat?query=$TODDAY,$TODDAY,1,USD" | grep $THISY | awk '{print $4}'`
EUR=`lynx -dump "http://mnb.hu/arfolyam-tablazat?query=$TODDAY,$TODDAY,1,EUR" | grep $THISY | awk '{print $4}'`
---------------------

Cheers,

István

Üdvözlettel / Kind regards

Pongrácz István
ügyvezető / CEO

StartIT Kft.
+36 20 4489 581

StartIT Kft.  |  Fit-PC2 oldal  Csoportmunka  |  Webáruház  |  Javasolt Google motoros kereső  |  Keress a Facebook-on


 

----------------eredeti üzenet-----------------
Feladó: "Ed W" <lists-XJavvHiACVh0ubjbjo6WXg@public.gmane.org>
Címzett: "Development discussion for LedgerSMB" <ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Dátum: Wed, 04 Aug 2010 08:29:17 +0100
----------------------------------------------------------



Hi

* Automaticly refresh currency exchange rate from official web services (configurable somehow: when, from, which with multiple currencies). Example: In Hungary we must use www.mnb.hu, others should use anything else. Exchange rate should be like this: HUF/USD: 216,99 (Configurable)

This seems like a solution which could be contributed as a "plugin" of sorts?  Anyone want to step up?

I should think the solution will be found (or end up) on CPAN.  Quick search there shows a few:
    Finance::Currency::Convert::XE
    Finance::Currency::Convert::WebserviceX
    Finance::Quote
    Finance::Currency::Convert::Yahoo

Actually this raises the good point about checking T&Cs on any data source used.  XE has some specific T&Cs if you haven't paid for the data


Those not using XE for commercial purposes and hence not violating their T&Cs might consider something like the following script as a quick fix (run it via cron at a specific time of the day)

---------------------------------
#!/bin/bash

if [ $1 ]; then
    TODAY=$1
else
    TODAY=`date --rfc-3339='date'`
fi

# get exchangerate from XE
USD=`lynx -dump "http://www.xe.com/ucc/convert.cgi?Amount=1&From=USD&To=GBP" | grep "1 USD =" | awk '{print $4}'`
EUR=`lynx -dump "http://www.xe.com/ucc/convert.cgi?Amount=1&From=EUR&To=GBP" | grep "1 EUR =" | awk '{print $4}'`
if [ -n $EUR ] ; then
    EXIST=`psql -U sql-ledger -t -c "SELECT * FROM exchangerate WHERE curr = 'EUR' AND transdate = '$TODAY';" nippynetworks`
    if [ -n "$EXIST" ] ; then
    psql -U sql-ledger -q -c "DELETE FROM exchangerate WHERE curr='EUR' AND transdate='$TODAY';" nippynetworks
    fi
#    echo "EUR: $EUR"
    psql -U sql-ledger -q -c "INSERT INTO exchangerate (curr,transdate,buy,sell) VALUES('EUR','$TODAY',$EUR + 0.01,$EUR);" nippynetworks
else
    echo "Failed to retrieve EUR rates"
fi

if [ -n $USD ] ; then
    EXIST=`psql -U sql-ledger -t -c "SELECT * FROM exchangerate WHERE curr = 'USD' AND transdate = '$TODAY';" nippynetworks`
    if [ -n "$EXIST" ] ; then
    psql -U sql-ledger -q -c "DELETE FROM exchangerate WHERE curr='USD' AND transdate='$TODAY';" nippynetworks
    fi
#    echo "USD: $USD"
    psql -U sql-ledger -q -c "INSERT INTO exchangerate (curr,transdate,buy,sell) VALUES('USD','$TODAY',$USD + 0.01,$USD);" nippynetworks
else
    echo "Failed to retrieve USD rates"
fi
-----------------------------------

------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm
_______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

 

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
David A. Bandel | 11 Aug 15:35 2010
Picon

Re: Features you would like to see in 2.0

On Thu, Jul 29, 2010 at 11:00, Joshua D. Drake
<jd@...> wrote:
> Hello,
>
> What features would you like to see in 2.0?
>
> The number one feature for me is:
>

A way to include line items for a client (charges) that accumulate and
are posted as one invoice at the end of the month.

Example:
on 3 Aug: billed Example Corp for a new VPN
on 7 Aug: billed Example Corp for modifications in their PBX
on 18 Aug: billed Example Corp for more modification in their PBX

At the end of the month (31 Aug), the secretary will print monthly
bills.  The first line is a monthly maintenance charge, then each of
the three above saved items is also posted on that bill.

I've been looking at how to do this for a PBX service I provide as
well, to allow LedgerSMB to get items from a "temporary" table.  This
table is where some CDR information  is written with billing
information (min x cents/min) on each call.  At EOM, one bill is
posted which incorporates all line items from the CDR plus a monthly
recurring fee.

This would also be useful for attorneys who charge by the hour and may
bill a client for several hours on various days, but only want to give
them one monthly statement.

Ciao,

David A. Bandel
--

-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto
Visit my blog at: http://www.pananix.com/cgi-bin/blosxom

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
Joshua D. Drake | 11 Aug 21:22 2010

Re: Features you would like to see in 2.0

On Wed, 2010-08-11 at 08:35 -0500, David A. Bandel wrote:

> This would also be useful for attorneys who charge by the hour and may
> bill a client for several hours on various days, but only want to give
> them one monthly statement.

What you want is a billing module. That you can group billables into and
click "invoice"

Joshua D. Drake

--

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
Luke | 11 Aug 22:43 2010

Re: Features you would like to see in 2.0

On Wed, 11 Aug 2010, David A. Bandel wrote:

> A way to include line items for a client (charges) that accumulate and
> are posted as one invoice at the end of the month.
>
> Example:
> on 3 Aug: billed Example Corp for a new VPN
> on 7 Aug: billed Example Corp for modifications in their PBX
> on 18 Aug: billed Example Corp for more modification in their PBX
>
> At the end of the month (31 Aug), the secretary will print monthly
> bills.  The first line is a monthly maintenance charge, then each of
> the three above saved items is also posted on that bill.

For now, why not post orders (one recurring for the monthly), and then 
consolidate and convert to invoice at the end of the month?
Or, just keep editing the same order--have the recurring system post one 
at the start of a month, and then edit more items on to it as the month 
progresses.

Also invoices on hold would probably solve this for you, assuming that 
means what I consider it to mean.

What would also probably solve it, is account statement capability.  They 
would post as separate invoices, but you could invoice them with a 
statement each month.

Luke

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
Chris Travers | 17 Aug 23:40 2010
Picon

HST change fixes in branches/1.2

Hi all;

Sorry for the delay on these but we have working HST fixes in branches
1.2.  I would expect a pre-release later this week,

To use these you, I would recommend having all the db hotfixes
(sql/fixes/*) run on the database prior, and you will have to set your
taxes to a rate of 0 for the time period they are not in effect.

I.e. HST would be a rate of 0, valid until July 1 of this year with
then the appropriate rate(s) after that (if applicable, for various
accounts).  Similarly GST would be valid until that same date, and
have a rate of 0 after, and the same with PST.

Please check to make sure the user interface is correct and that
invoices print out properly.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
o1bigtenor | 18 Aug 01:57 2010
Picon

Debian environment startup and scripts

Greetings

I have had someone I know develop a script for installing LedgerSMB in
Debian. The script is written in Pearl. There was quite a few hours of
back and forth as we tried to get things to work. With a fresh system
things should go well. I am having a problem in establishing a user.
Is there anyone who would please be able to give a step by step
(preferably with screen shots) guide? The second thing I could use
would be 7 digit account numbers -  any suggestions as to where that
could be changed as a global variable?

I really need this kind of program for my businesses and am looking
forward to putting something back into the community starting with the
script.

Darald

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
Armaghan Saqib | 18 Aug 02:40 2010

Re: Debian environment startup and scripts


On 08/17/2010 07:57 PM, o1bigtenor wrote:
Greetings I have had someone I know develop a script for installing LedgerSMB in Debian. The script is written in Pearl. There was quite a few hours of back and forth as we tried to get things to work. With a fresh system things should go well. I am having a problem in establishing a user.
You create users through admin interface which is accessible through http://your-server/ledgersmb/admin.pl. The admin password is what you set during installation.

Here are some docs related to sql-ledger but should apply to LedgerSMB too.
   > http://ledger123.com/docs/doku.php?id=users

Is there anyone who would please be able to give a step by step (preferably with screen shots) guide? The second thing I could use would be 7 digit account numbers - any suggestions as to where that could be changed as a global variable?
You don't need to set any global variable/preference to use 7 digit account number. Just create your accounts with 7 digits.

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

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Gmane