From: Steve <st...@se...> - 2007-01-25 23:36:14
|
There is a whole opening procedure in the manual under setting up system. Basically at the beginning you have the sales, etc. to gl settings No in Company info. You do one entry (I think an invoice) for each customer with each customer's balance. That does the customer area. However, it currently has nothing to do with g/l. Later when you enter all the g/l opening balance for all accounts it will contain the opening balance for receivables. The total of the customer openings must be equal to the opening in receivables then you turn on the links. Did I say that right? Steve -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of Daniel Britez Sent: Thursday, January 25, 2007 3:46 PM To: web...@li... Subject: [webERP-users] How can I entry customers initial balances ? How can I entry customers inital balances ? I had posted the inital balance of the "Receivable" GL account with "Journal Entry"...BUT: I need to set the customers initial balances to have the "Debtor Balances At A Prior Month End" reconcilied with the "Receivable" GL account. Daniel Britez ------------------------------------------------------------------------- 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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 1/24/2007 6:48 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 1/24/2007 6:48 PM |
From: Alex Plumbley-J. <al...@bp...> - 2007-01-27 12:11:16
|
Hi everyone, This is a question for the Smaller firms here: What do you do when your accountant asks for your data at the end of the year? My accountant likes QB and imports my data into his package so that he has access to almost almost everything native. Having migrated to webERP do you just send trial balances etc? Anyone prepare a script to output a well known format csv etc. Do your accountants have access to the data online? Thanks. Al. |
From: Steve <st...@se...> - 2007-01-28 00:23:24
|
Sure, give him access to it either from outside or when he comes to your = place depending on the level of security you believe in. You can always = set your router to allow only him, if he has a dedicated ip address then = no one else will be allowed. You can run webERP under SSL (https) and = set it only to allow access under https in system settings thereby = encrypting all info passed between the server and him like the banks. =20 It kind of depends on the amount of hands-on they do and the amount your = in-house people do. If you do most to all of the hands-on then reports = are fine. =20 =20 Your accountant may enjoy a real accounting/ERP system such as webERP = instead of a mess ;) It could be a breath of fresh air for him, = depending on his experience or lack of. =20 Steve _____ =20 From: web...@li... = [mailto:web...@li...] On Behalf Of Alex = Plumbley-Jones Sent: Saturday, January 27, 2007 7:11 AM To: web...@li... Subject: [webERP-users] A quck question on interfacing with accountants Hi everyone, This is a question for the Smaller firms here: What do you do when your accountant asks for your data at the end of the = year? My accountant likes QB and imports my data into his package so that he = has access to almost almost everything native. Having migrated to webERP do you just send trial balances etc? Anyone = prepare a script to output a well known format csv etc. Do your accountants have access to the data online? Thanks.=20 Al.=20 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: = 1/26/2007 11:11 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: = 1/26/2007 11:11 AM |
From: Alex Plumbley-J. <al...@bp...> - 2007-01-28 13:52:50
|
That's what I'd like ot do but I think he's on dialup or a cheap provider with non-static IP addresses. I don't want to open the SSH port to and was looking for an alternative setup until I can get going; so I wondered if anyone has built an export function or something. I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking - single packet) and http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your-closed-linux-firewall/ (firewall knocking) which kinda solves my problem. I thought I'd list it here just in case anyone has the same idea. Thanks. Al. PS: Apologies to Daniel Britez whose thread I broke into - the mail headers must contain some additional info to put the replies in order so that my 'new thread' wasn't one. I hope he didn't think I was being rude; just careless in thought, and I'll put the list address in a proper place now! Sorry. On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: > Sure, give him access to it either from outside or when he comes to > your place depending on the level of security you believe in. You can > always set your router to allow only him, if he has a dedicated ip > address then no one else will be allowed. You can run webERP under > SSL (https) and set it only to allow access under https in system > settings thereby encrypting all info passed between the server and him > like the banks. > > It kind of depends on the amount of hands-on they do and the amount > your in-house people do. If you do most to all of the hands-on then > reports are fine. > > Your accountant may enjoy a real accounting/ERP system such as > webERP instead of a mess ;) It could be a breath of fresh air for > him, depending on his experience or lack of. > > Steve > > > > > ______________________________________________________________________ > From: web...@li... > [mailto:web...@li...] On Behalf Of Alex > Plumbley-Jones > Sent: Saturday, January 27, 2007 7:11 AM > To: web...@li... > Subject: [webERP-users] A quck question on interfacing with > accountants > > > > > Hi everyone, > > This is a question for the Smaller firms here: > What do you do when your accountant asks for your data at the end of > the year? > > My accountant likes QB and imports my data into his package so that he > has access to almost almost everything native. > Having migrated to webERP do you just send trial balances etc? Anyone > prepare a script to output a well known format csv etc. > Do your accountants have access to the data online? > > Thanks. > > Al. > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > 1/26/2007 11:11 AM > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > 1/26/2007 11:11 AM > > > > ------------------------------------------------------------------------- > 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 > _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
From: <ec...@un...> - 2007-01-29 01:47:01
|
Quoting Alex Plumbley-Jones <al...@bp...>: > That's what I'd like ot do but I think he's on dialup or a cheap > provider with non-static IP addresses. > I don't want to open the SSH port to and was looking for an alternative > setup until I can get going; so I wondered if anyone has built an export > function or something. Do you have http or https internet access to the server that is =20 hosting WebERP or are they only accessable on the internal network? thanks, ed > > I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking > - single packet) and > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-you= r-closed-linux-firewall/ (firewall knocking) which kinda solves my =20 > problem. > > I thought I'd list it here just in case anyone has the same idea. > > Thanks. > > Al. > > PS: Apologies to Daniel Britez whose thread I broke into - the mail > headers must contain some additional info to put the replies in order so > that my 'new thread' wasn't one. I hope he didn't think I was being > rude; just careless in thought, and I'll put the list address in a > proper place now! Sorry. > > > > On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >> Sure, give him access to it either from outside or when he comes to >> your place depending on the level of security you believe in. You can >> always set your router to allow only him, if he has a dedicated ip >> address then no one else will be allowed. You can run webERP under >> SSL (https) and set it only to allow access under https in system >> settings thereby encrypting all info passed between the server and him >> like the banks. >> >> It kind of depends on the amount of hands-on they do and the amount >> your in-house people do. If you do most to all of the hands-on then >> reports are fine. >> >> Your accountant may enjoy a real accounting/ERP system such as >> webERP instead of a mess ;) It could be a breath of fresh air for >> him, depending on his experience or lack of. >> >> Steve >> >> >> >> >> ______________________________________________________________________ >> From: web...@li... >> [mailto:web...@li...] On Behalf Of Alex >> Plumbley-Jones >> Sent: Saturday, January 27, 2007 7:11 AM >> To: web...@li... >> Subject: [webERP-users] A quck question on interfacing with >> accountants >> >> >> >> >> Hi everyone, >> >> This is a question for the Smaller firms here: >> What do you do when your accountant asks for your data at the end of >> the year? >> >> My accountant likes QB and imports my data into his package so that he >> has access to almost almost everything native. >> Having migrated to webERP do you just send trial balances etc? Anyone >> prepare a script to output a well known format csv etc. >> Do your accountants have access to the data online? >> >> Thanks. >> >> Al. >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> -- >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share y= our >> opinions on IT & business topics through brief surveys - and earn cash >> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDEV >> _______________________________________________ web-ERP-users =20 >> mailing list web...@li... =20 >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
From: Alex Plumbley-J. <al...@bp...> - 2007-01-29 11:06:21
|
Ed, Unfortunately, it's early days yet so it's my own server (with a couple of firewalls between it and the outside world). I have ssh access from a couple of known and static addresses. I'll have to get https going too. The aim is to change over accounting for April. I'm also looking at vtiger or sugar implementation; I've got an accounts system which I don't like but kinda works - the QB file is getting big so it seems to become unstable when it's actually happily processing - but our CRM system is not particularly well formed! Best. Al. -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of ec...@un... Sent: 29 January 2007 01:47 To: web...@li... Subject: Re: [webERP-users] A quck question on interfacing with accountants Quoting Alex Plumbley-Jones <al...@bp...>: > That's what I'd like ot do but I think he's on dialup or a cheap > provider with non-static IP addresses. > I don't want to open the SSH port to and was looking for an alternative > setup until I can get going; so I wondered if anyone has built an export > function or something. Do you have http or https internet access to the server that is hosting WebERP or are they only accessable on the internal network? thanks, ed > > I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking > - single packet) and > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- closed-linux-firewall/ (firewall knocking) which kinda solves my > problem. > > I thought I'd list it here just in case anyone has the same idea. > > Thanks. > > Al. > > PS: Apologies to Daniel Britez whose thread I broke into - the mail > headers must contain some additional info to put the replies in order so > that my 'new thread' wasn't one. I hope he didn't think I was being > rude; just careless in thought, and I'll put the list address in a > proper place now! Sorry. > > > > On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >> Sure, give him access to it either from outside or when he comes to >> your place depending on the level of security you believe in. You can >> always set your router to allow only him, if he has a dedicated ip >> address then no one else will be allowed. You can run webERP under >> SSL (https) and set it only to allow access under https in system >> settings thereby encrypting all info passed between the server and him >> like the banks. >> >> It kind of depends on the amount of hands-on they do and the amount >> your in-house people do. If you do most to all of the hands-on then >> reports are fine. >> >> Your accountant may enjoy a real accounting/ERP system such as >> webERP instead of a mess ;) It could be a breath of fresh air for >> him, depending on his experience or lack of. >> >> Steve >> >> >> >> >> ______________________________________________________________________ >> From: web...@li... >> [mailto:web...@li...] On Behalf Of Alex >> Plumbley-Jones >> Sent: Saturday, January 27, 2007 7:11 AM >> To: web...@li... >> Subject: [webERP-users] A quck question on interfacing with >> accountants >> >> >> >> >> Hi everyone, >> >> This is a question for the Smaller firms here: >> What do you do when your accountant asks for your data at the end of >> the year? >> >> My accountant likes QB and imports my data into his package so that he >> has access to almost almost everything native. >> Having migrated to webERP do you just send trial balances etc? Anyone >> prepare a script to output a well known format csv etc. >> Do your accountants have access to the data online? >> >> Thanks. >> >> Al. >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> -- >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ web-ERP-users >> mailing list web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
From: <ec...@un...> - 2007-01-29 13:43:59
|
Quoting Alex Plumbley-Jones <al...@bp...>: > Ed, > > Unfortunately, it's early days yet so it's my own server (with a couple of > firewalls between it and the outside world). I have ssh access from a > couple of known and static addresses. I'll have to get https going too. Hi Al, I really don't see https as being important yet, but two firewalls =20 between your weberp installation and the world is important. It also =20 opens up many questions. I will throw out a couple of possible =20 solutions to the unknown questions but all be need firewall =20 cooperation. The easiest would be to just stick weberp on the machine =20 facing the internet and open a port for it to not interfere with =20 standard http traffic and it would also give a bit of security by =20 obscurity but not actually important. Another option equally quick =20 would be to redirect through the firewalls to the internal machine. =20 Both the above would give you and others access from home, the road, =20 etc. The only other one I can think of that is completely =20 restrictive, would be a vpn to your accountant but that opens up a can =20 of worms that I'm not sure is even worth the time. From your comments =20 and from experience he could be still using windows 3.11. Anyone else =20 got an idea? ed > The aim is to change over accounting for April. I'm also looking at vtige= r > or sugar implementation; I've got an accounts system which I don't like bu= t > kinda works - the QB file is getting big so it seems to become unstable wh= en > it's actually happily processing - but our CRM system is not particularly > well formed! > > Best. > > Al. > > > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of > ec...@un... > Sent: 29 January 2007 01:47 > To: web...@li... > Subject: Re: [webERP-users] A quck question on interfacing with accountant= s > > Quoting Alex Plumbley-Jones <al...@bp...>: > >> That's what I'd like ot do but I think he's on dialup or a cheap >> provider with non-static IP addresses. >> I don't want to open the SSH port to and was looking for an alternative >> setup until I can get going; so I wondered if anyone has built an export >> function or something. > > Do you have http or https internet access to the server that is > hosting WebERP or are they only accessable on the internal network? > > thanks, > > ed > >> >> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking >> - single packet) and >> > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-you= r- > closed-linux-firewall/ (firewall knocking) which kinda solves my >> problem. >> >> I thought I'd list it here just in case anyone has the same idea. >> >> Thanks. >> >> Al. >> >> PS: Apologies to Daniel Britez whose thread I broke into - the mail >> headers must contain some additional info to put the replies in order so >> that my 'new thread' wasn't one. I hope he didn't think I was being >> rude; just careless in thought, and I'll put the list address in a >> proper place now! Sorry. >> >> >> >> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >>> Sure, give him access to it either from outside or when he comes to >>> your place depending on the level of security you believe in. You can >>> always set your router to allow only him, if he has a dedicated ip >>> address then no one else will be allowed. You can run webERP under >>> SSL (https) and set it only to allow access under https in system >>> settings thereby encrypting all info passed between the server and him >>> like the banks. >>> >>> It kind of depends on the amount of hands-on they do and the amount >>> your in-house people do. If you do most to all of the hands-on then >>> reports are fine. >>> >>> Your accountant may enjoy a real accounting/ERP system such as >>> webERP instead of a mess ;) It could be a breath of fresh air for >>> him, depending on his experience or lack of. >>> >>> Steve >>> >>> >>> >>> >>> ______________________________________________________________________ >>> From: web...@li... >>> [mailto:web...@li...] On Behalf Of Alex >>> Plumbley-Jones >>> Sent: Saturday, January 27, 2007 7:11 AM >>> To: web...@li... >>> Subject: [webERP-users] A quck question on interfacing with >>> accountants >>> >>> >>> >>> >>> Hi everyone, >>> >>> This is a question for the Smaller firms here: >>> What do you do when your accountant asks for your data at the end of >>> the year? >>> >>> My accountant likes QB and imports my data into his package so that he >>> has access to almost almost everything native. >>> Having migrated to webERP do you just send trial balances etc? Anyone >>> prepare a script to output a well known format csv etc. >>> Do your accountants have access to the data online? >>> >>> Thanks. >>> >>> Al. >>> >>> >>> -- >>> No virus found in this incoming message. >>> Checked by AVG Free Edition. >>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>> 1/26/2007 11:11 AM >>> >>> >>> >>> -- >>> No virus found in this outgoing message. >>> Checked by AVG Free Edition. >>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>> 1/26/2007 11:11 AM >>> >>> >>> >>> ------------------------------------------------------------------------= - >>> 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=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >>> _______________________________________________ web-ERP-users >>> mailing list web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
From: Steve <st...@se...> - 2007-01-29 16:39:16
|
You know, I heard some additional arguments about giving the accountant access from the outside. Considering all the stuff that can be done including special port, https, even restrict through firewall to one ip remembering that if it changes periodically he's probably still good for some hours after you do it, it is a bigger security and data risk not to. If you're sending the data through courier or anything it could easily get lost and into outside hands. How do you know the accountant is wise enough to take care of your data like you would? Did you setup his computer and know it's never vulnerable? How much is he going to care about your data if he leaves? I mean, he should be a professional and always keep it secure but even with good intentions, what happens when he gets a new computer? Does he do a proper destruction of your data? Does he cut up the cds you sent? An additional point is now you have two copies. He can't make any changes or see the information real-time if anyone including you makes changes. Also, what about if he thinks he is making changes but they're really on his copy? In other words confusion about being at home and being on your real system. So, giving him access in a "safe" way is actually much more secure and intelligent than any other way. Steve -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of Alex Plumbley-Jones Sent: Monday, January 29, 2007 6:06 AM To: 'For the general discussion of webERP project' Subject: Re: [webERP-users] A quck question on interfacing with accountants Ed, Unfortunately, it's early days yet so it's my own server (with a couple of firewalls between it and the outside world). I have ssh access from a couple of known and static addresses. I'll have to get https going too. The aim is to change over accounting for April. I'm also looking at vtiger or sugar implementation; I've got an accounts system which I don't like but kinda works - the QB file is getting big so it seems to become unstable when it's actually happily processing - but our CRM system is not particularly well formed! Best. Al. -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of ec...@un... Sent: 29 January 2007 01:47 To: web...@li... Subject: Re: [webERP-users] A quck question on interfacing with accountants Quoting Alex Plumbley-Jones <al...@bp...>: > That's what I'd like ot do but I think he's on dialup or a cheap > provider with non-static IP addresses. > I don't want to open the SSH port to and was looking for an alternative > setup until I can get going; so I wondered if anyone has built an export > function or something. Do you have http or https internet access to the server that is hosting WebERP or are they only accessable on the internal network? thanks, ed > > I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking > - single packet) and > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- closed-linux-firewall/ (firewall knocking) which kinda solves my > problem. > > I thought I'd list it here just in case anyone has the same idea. > > Thanks. > > Al. > > PS: Apologies to Daniel Britez whose thread I broke into - the mail > headers must contain some additional info to put the replies in order so > that my 'new thread' wasn't one. I hope he didn't think I was being > rude; just careless in thought, and I'll put the list address in a > proper place now! Sorry. > > > > On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >> Sure, give him access to it either from outside or when he comes to >> your place depending on the level of security you believe in. You can >> always set your router to allow only him, if he has a dedicated ip >> address then no one else will be allowed. You can run webERP under >> SSL (https) and set it only to allow access under https in system >> settings thereby encrypting all info passed between the server and him >> like the banks. >> >> It kind of depends on the amount of hands-on they do and the amount >> your in-house people do. If you do most to all of the hands-on then >> reports are fine. >> >> Your accountant may enjoy a real accounting/ERP system such as >> webERP instead of a mess ;) It could be a breath of fresh air for >> him, depending on his experience or lack of. >> >> Steve >> >> >> >> >> ______________________________________________________________________ >> From: web...@li... >> [mailto:web...@li...] On Behalf Of Alex >> Plumbley-Jones >> Sent: Saturday, January 27, 2007 7:11 AM >> To: web...@li... >> Subject: [webERP-users] A quck question on interfacing with >> accountants >> >> >> >> >> Hi everyone, >> >> This is a question for the Smaller firms here: >> What do you do when your accountant asks for your data at the end of >> the year? >> >> My accountant likes QB and imports my data into his package so that he >> has access to almost almost everything native. >> Having migrated to webERP do you just send trial balances etc? Anyone >> prepare a script to output a well known format csv etc. >> Do your accountants have access to the data online? >> >> Thanks. >> >> Al. >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> -- >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ web-ERP-users >> mailing list web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM |
From: Alex Plumbley-J. <al...@bp...> - 2007-02-04 13:17:04
|
That's a good and interesting post Steve. Thank you. I had to think about it for some while. Like everything, there comes a point where you just have to let go. If my accountant decides to turn rogue (or his staff are even accidentally indiscreet or careless), because he has so much financial information, it would be a small disaster regardless. Not because i have done anything wrong, but because of the repeated whisper effect. I radically changed my thoughts on what I was going to do. I was going to put a copy in the DMZ and decided that I could really confuse myself with that not to mention them. My primary concern is not so much keeping the accountant at bay but keeping the rest of the netizens at bay! Thank you everyone for your posts. It will be a while before I digest it all. Must get on and make it real! Al. On Mon, 2007-01-29 at 11:38 -0500, Steve wrote: > You know, I heard some additional arguments about giving the accountant > access from the outside. Considering all the stuff that can be done > including special port, https, even restrict through firewall to one ip > remembering that if it changes periodically he's probably still good for > some hours after you do it, it is a bigger security and data risk not to. > If you're sending the data through courier or anything it could easily get > lost and into outside hands. How do you know the accountant is wise enough > to take care of your data like you would? Did you setup his computer and > know it's never vulnerable? How much is he going to care about your data if > he leaves? I mean, he should be a professional and always keep it secure > but even with good intentions, what happens when he gets a new computer? > Does he do a proper destruction of your data? Does he cut up the cds you > sent? > > An additional point is now you have two copies. He can't make any changes > or see the information real-time if anyone including you makes changes. > Also, what about if he thinks he is making changes but they're really on his > copy? In other words confusion about being at home and being on your real > system. > > So, giving him access in a "safe" way is actually much more secure and > intelligent than any other way. > > Steve > > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of Alex > Plumbley-Jones > Sent: Monday, January 29, 2007 6:06 AM > To: 'For the general discussion of webERP project' > Subject: Re: [webERP-users] A quck question on interfacing with accountants > > Ed, > > Unfortunately, it's early days yet so it's my own server (with a couple of > firewalls between it and the outside world). I have ssh access from a > couple of known and static addresses. I'll have to get https going too. > > The aim is to change over accounting for April. I'm also looking at vtiger > or sugar implementation; I've got an accounts system which I don't like but > kinda works - the QB file is getting big so it seems to become unstable when > it's actually happily processing - but our CRM system is not particularly > well formed! > > Best. > > Al. > > > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of > ec...@un... > Sent: 29 January 2007 01:47 > To: web...@li... > Subject: Re: [webERP-users] A quck question on interfacing with accountants > > Quoting Alex Plumbley-Jones <al...@bp...>: > > > That's what I'd like ot do but I think he's on dialup or a cheap > > provider with non-static IP addresses. > > I don't want to open the SSH port to and was looking for an alternative > > setup until I can get going; so I wondered if anyone has built an export > > function or something. > > Do you have http or https internet access to the server that is > hosting WebERP or are they only accessable on the internal network? > > thanks, > > ed > > > > > I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking > > - single packet) and > > > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- > closed-linux-firewall/ (firewall knocking) which kinda solves my > > problem. > > > > I thought I'd list it here just in case anyone has the same idea. > > > > Thanks. > > > > Al. > > > > PS: Apologies to Daniel Britez whose thread I broke into - the mail > > headers must contain some additional info to put the replies in order so > > that my 'new thread' wasn't one. I hope he didn't think I was being > > rude; just careless in thought, and I'll put the list address in a > > proper place now! Sorry. > > > > > > > > On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: > >> Sure, give him access to it either from outside or when he comes to > >> your place depending on the level of security you believe in. You can > >> always set your router to allow only him, if he has a dedicated ip > >> address then no one else will be allowed. You can run webERP under > >> SSL (https) and set it only to allow access under https in system > >> settings thereby encrypting all info passed between the server and him > >> like the banks. > >> > >> It kind of depends on the amount of hands-on they do and the amount > >> your in-house people do. If you do most to all of the hands-on then > >> reports are fine. > >> > >> Your accountant may enjoy a real accounting/ERP system such as > >> webERP instead of a mess ;) It could be a breath of fresh air for > >> him, depending on his experience or lack of. > >> > >> Steve > >> > >> > >> > >> > >> ______________________________________________________________________ > >> From: web...@li... > >> [mailto:web...@li...] On Behalf Of Alex > >> Plumbley-Jones > >> Sent: Saturday, January 27, 2007 7:11 AM > >> To: web...@li... > >> Subject: [webERP-users] A quck question on interfacing with > >> accountants > >> > >> > >> > >> > >> Hi everyone, > >> > >> This is a question for the Smaller firms here: > >> What do you do when your accountant asks for your data at the end of > >> the year? > >> > >> My accountant likes QB and imports my data into his package so that he > >> has access to almost almost everything native. > >> Having migrated to webERP do you just send trial balances etc? Anyone > >> prepare a script to output a well known format csv etc. > >> Do your accountants have access to the data online? > >> > >> Thanks. > >> > >> Al. > >> > >> > >> -- > >> No virus found in this incoming message. > >> Checked by AVG Free Edition. > >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > >> 1/26/2007 11:11 AM > >> > >> > >> > >> -- > >> No virus found in this outgoing message. > >> Checked by AVG Free Edition. > >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > >> 1/26/2007 11:11 AM > >> > >> > >> > >> ------------------------------------------------------------------------- > >> 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 > >> _______________________________________________ web-ERP-users > >> mailing list web...@li... > >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 > 9:04 AM > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 > 9:04 AM > > > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
From: Steve <st...@se...> - 2007-01-29 16:39:46
|
You know, I heard some additional arguments about giving the accountant access from the outside. Considering all the stuff that can be done including special port, https, even restrict through firewall to one ip remembering that if it changes periodically he's probably still good for some hours after you do it, it is a bigger security and data risk not to. If you're sending the data through courier or anything it could easily get lost and into outside hands. How do you know the accountant is wise enough to take care of your data like you would? Did you setup his computer and know it's never vulnerable? How much is he going to care about your data if he leaves? I mean, he should be a professional and always keep it secure but even with good intentions, what happens when he gets a new computer? Does he do a proper destruction of your data? Does he cut up the cds you sent? An additional point is now you have two copies. He can't make any changes or see the information real-time if anyone including you makes changes. Also, what about if he thinks he is making changes but they're really on his copy? In other words confusion about being at home and being on your real system. So, giving him access in a "safe" way is actually much more secure and intelligent than any other way. Steve -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of Alex Plumbley-Jones Sent: Monday, January 29, 2007 6:06 AM To: 'For the general discussion of webERP project' Subject: Re: [webERP-users] A quck question on interfacing with accountants Ed, Unfortunately, it's early days yet so it's my own server (with a couple of firewalls between it and the outside world). I have ssh access from a couple of known and static addresses. I'll have to get https going too. The aim is to change over accounting for April. I'm also looking at vtiger or sugar implementation; I've got an accounts system which I don't like but kinda works - the QB file is getting big so it seems to become unstable when it's actually happily processing - but our CRM system is not particularly well formed! Best. Al. -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of ec...@un... Sent: 29 January 2007 01:47 To: web...@li... Subject: Re: [webERP-users] A quck question on interfacing with accountants Quoting Alex Plumbley-Jones <al...@bp...>: > That's what I'd like ot do but I think he's on dialup or a cheap > provider with non-static IP addresses. > I don't want to open the SSH port to and was looking for an alternative > setup until I can get going; so I wondered if anyone has built an export > function or something. Do you have http or https internet access to the server that is hosting WebERP or are they only accessable on the internal network? thanks, ed > > I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking > - single packet) and > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- closed-linux-firewall/ (firewall knocking) which kinda solves my > problem. > > I thought I'd list it here just in case anyone has the same idea. > > Thanks. > > Al. > > PS: Apologies to Daniel Britez whose thread I broke into - the mail > headers must contain some additional info to put the replies in order so > that my 'new thread' wasn't one. I hope he didn't think I was being > rude; just careless in thought, and I'll put the list address in a > proper place now! Sorry. > > > > On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >> Sure, give him access to it either from outside or when he comes to >> your place depending on the level of security you believe in. You can >> always set your router to allow only him, if he has a dedicated ip >> address then no one else will be allowed. You can run webERP under >> SSL (https) and set it only to allow access under https in system >> settings thereby encrypting all info passed between the server and him >> like the banks. >> >> It kind of depends on the amount of hands-on they do and the amount >> your in-house people do. If you do most to all of the hands-on then >> reports are fine. >> >> Your accountant may enjoy a real accounting/ERP system such as >> webERP instead of a mess ;) It could be a breath of fresh air for >> him, depending on his experience or lack of. >> >> Steve >> >> >> >> >> ______________________________________________________________________ >> From: web...@li... >> [mailto:web...@li...] On Behalf Of Alex >> Plumbley-Jones >> Sent: Saturday, January 27, 2007 7:11 AM >> To: web...@li... >> Subject: [webERP-users] A quck question on interfacing with >> accountants >> >> >> >> >> Hi everyone, >> >> This is a question for the Smaller firms here: >> What do you do when your accountant asks for your data at the end of >> the year? >> >> My accountant likes QB and imports my data into his package so that he >> has access to almost almost everything native. >> Having migrated to webERP do you just send trial balances etc? Anyone >> prepare a script to output a well known format csv etc. >> Do your accountants have access to the data online? >> >> Thanks. >> >> Al. >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> -- >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >> 1/26/2007 11:11 AM >> >> >> >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ web-ERP-users >> mailing list web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM |
From: <ec...@un...> - 2007-01-30 00:00:35
|
Quoting Steve <st...@se...>: > You know, I heard some additional arguments about giving the accountant > access from the outside. Considering all the stuff that can be done > including special port, https, even restrict through firewall to one ip > remembering that if it changes periodically he's probably still good for > some hours after you do it, it is a bigger security and data risk not to. > If you're sending the data through courier or anything it could easily get > lost and into outside hands. How do you know the accountant is wise enoug= h > to take care of your data like you would? Did you setup his computer and > know it's never vulnerable? How much is he going to care about your data = if > he leaves? I mean, he should be a professional and always keep it secure > but even with good intentions, what happens when he gets a new computer? > Does he do a proper destruction of your data? Does he cut up the cds you > sent? > > An additional point is now you have two copies. He can't make any changes > or see the information real-time if anyone including you makes changes. > Also, what about if he thinks he is making changes but they're really on h= is > copy? In other words confusion about being at home and being on your real > system. > > So, giving him access in a "safe" way is actually much more secure and > intelligent than any other way. > > Steve AMEN ed > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of Alex > Plumbley-Jones > Sent: Monday, January 29, 2007 6:06 AM > To: 'For the general discussion of webERP project' > Subject: Re: [webERP-users] A quck question on interfacing with accountant= s > > Ed, > > Unfortunately, it's early days yet so it's my own server (with a couple of > firewalls between it and the outside world). I have ssh access from a > couple of known and static addresses. I'll have to get https going too. > > The aim is to change over accounting for April. I'm also looking at vtige= r > or sugar implementation; I've got an accounts system which I don't like bu= t > kinda works - the QB file is getting big so it seems to become unstable wh= en > it's actually happily processing - but our CRM system is not particularly > well formed! > > Best. > > Al. > > > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of > ec...@un... > Sent: 29 January 2007 01:47 > To: web...@li... > Subject: Re: [webERP-users] A quck question on interfacing with accountant= s > > Quoting Alex Plumbley-Jones <al...@bp...>: > >> That's what I'd like ot do but I think he's on dialup or a cheap >> provider with non-static IP addresses. >> I don't want to open the SSH port to and was looking for an alternative >> setup until I can get going; so I wondered if anyone has built an export >> function or something. > > Do you have http or https internet access to the server that is > hosting WebERP or are they only accessable on the internal network? > > thanks, > > ed > >> >> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking >> - single packet) and >> > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-you= r- > closed-linux-firewall/ (firewall knocking) which kinda solves my >> problem. >> >> I thought I'd list it here just in case anyone has the same idea. >> >> Thanks. >> >> Al. >> >> PS: Apologies to Daniel Britez whose thread I broke into - the mail >> headers must contain some additional info to put the replies in order so >> that my 'new thread' wasn't one. I hope he didn't think I was being >> rude; just careless in thought, and I'll put the list address in a >> proper place now! Sorry. >> >> >> >> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >>> Sure, give him access to it either from outside or when he comes to >>> your place depending on the level of security you believe in. You can >>> always set your router to allow only him, if he has a dedicated ip >>> address then no one else will be allowed. You can run webERP under >>> SSL (https) and set it only to allow access under https in system >>> settings thereby encrypting all info passed between the server and him >>> like the banks. >>> >>> It kind of depends on the amount of hands-on they do and the amount >>> your in-house people do. If you do most to all of the hands-on then >>> reports are fine. >>> >>> Your accountant may enjoy a real accounting/ERP system such as >>> webERP instead of a mess ;) It could be a breath of fresh air for >>> him, depending on his experience or lack of. >>> >>> Steve >>> >>> >>> >>> >>> ______________________________________________________________________ >>> From: web...@li... >>> [mailto:web...@li...] On Behalf Of Alex >>> Plumbley-Jones >>> Sent: Saturday, January 27, 2007 7:11 AM >>> To: web...@li... >>> Subject: [webERP-users] A quck question on interfacing with >>> accountants >>> >>> >>> >>> >>> Hi everyone, >>> >>> This is a question for the Smaller firms here: >>> What do you do when your accountant asks for your data at the end of >>> the year? >>> >>> My accountant likes QB and imports my data into his package so that he >>> has access to almost almost everything native. >>> Having migrated to webERP do you just send trial balances etc? Anyone >>> prepare a script to output a well known format csv etc. >>> Do your accountants have access to the data online? >>> >>> Thanks. >>> >>> Al. >>> >>> >>> -- >>> No virus found in this incoming message. >>> Checked by AVG Free Edition. >>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>> 1/26/2007 11:11 AM >>> >>> >>> >>> -- >>> No virus found in this outgoing message. >>> Checked by AVG Free Edition. >>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>> 1/26/2007 11:11 AM >>> >>> >>> >>> ------------------------------------------------------------------------= - >>> 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=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >>> _______________________________________________ web-ERP-users >>> mailing list web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 > 9:04 AM > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 > 9:04 AM > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
From: Todd M. <to...@ko...> - 2007-01-29 20:51:18
|
Well what if your accountant has dial-up internet, so his/her IP address is not static? How do you configure your firewall then? Todd. ----- Original Message ----- From: <ec...@un...> To: <web...@li...> Sent: Tuesday, January 30, 2007 2:43 AM Subject: Re: [webERP-users] A quck question on interfacing with accountants > Quoting Alex Plumbley-Jones <al...@bp...>: > >> Ed, >> >> Unfortunately, it's early days yet so it's my own server (with a couple >> of >> firewalls between it and the outside world). I have ssh access from a >> couple of known and static addresses. I'll have to get https going too. > Hi Al, > > I really don't see https as being important yet, but two firewalls > between your weberp installation and the world is important. It also > opens up many questions. I will throw out a couple of possible > solutions to the unknown questions but all be need firewall > cooperation. The easiest would be to just stick weberp on the machine > facing the internet and open a port for it to not interfere with > standard http traffic and it would also give a bit of security by > obscurity but not actually important. Another option equally quick > would be to redirect through the firewalls to the internal machine. > Both the above would give you and others access from home, the road, > etc. The only other one I can think of that is completely > restrictive, would be a vpn to your accountant but that opens up a can > of worms that I'm not sure is even worth the time. From your comments > and from experience he could be still using windows 3.11. Anyone else > got an idea? > > ed > >> The aim is to change over accounting for April. I'm also looking at >> vtiger >> or sugar implementation; I've got an accounts system which I don't like >> but >> kinda works - the QB file is getting big so it seems to become unstable >> when >> it's actually happily processing - but our CRM system is not particularly >> well formed! >> >> Best. >> >> Al. >> >> >> -----Original Message----- >> From: web...@li... >> [mailto:web...@li...] On Behalf Of >> ec...@un... >> Sent: 29 January 2007 01:47 >> To: web...@li... >> Subject: Re: [webERP-users] A quck question on interfacing with >> accountants >> >> Quoting Alex Plumbley-Jones <al...@bp...>: >> >>> That's what I'd like ot do but I think he's on dialup or a cheap >>> provider with non-static IP addresses. >>> I don't want to open the SSH port to and was looking for an alternative >>> setup until I can get going; so I wondered if anyone has built an export >>> function or something. >> >> Do you have http or https internet access to the server that is >> hosting WebERP or are they only accessable on the internal network? >> >> thanks, >> >> ed >> >>> >>> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking >>> - single packet) and >>> >> http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- >> closed-linux-firewall/ (firewall knocking) which kinda solves my >>> problem. >>> >>> I thought I'd list it here just in case anyone has the same idea. >>> >>> Thanks. >>> >>> Al. >>> >>> PS: Apologies to Daniel Britez whose thread I broke into - the mail >>> headers must contain some additional info to put the replies in order so >>> that my 'new thread' wasn't one. I hope he didn't think I was being >>> rude; just careless in thought, and I'll put the list address in a >>> proper place now! Sorry. >>> >>> >>> >>> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >>>> Sure, give him access to it either from outside or when he comes to >>>> your place depending on the level of security you believe in. You can >>>> always set your router to allow only him, if he has a dedicated ip >>>> address then no one else will be allowed. You can run webERP under >>>> SSL (https) and set it only to allow access under https in system >>>> settings thereby encrypting all info passed between the server and him >>>> like the banks. >>>> >>>> It kind of depends on the amount of hands-on they do and the amount >>>> your in-house people do. If you do most to all of the hands-on then >>>> reports are fine. >>>> >>>> Your accountant may enjoy a real accounting/ERP system such as >>>> webERP instead of a mess ;) It could be a breath of fresh air for >>>> him, depending on his experience or lack of. >>>> >>>> Steve >>>> >>>> >>>> >>>> >>>> ______________________________________________________________________ >>>> From: web...@li... >>>> [mailto:web...@li...] On Behalf Of Alex >>>> Plumbley-Jones >>>> Sent: Saturday, January 27, 2007 7:11 AM >>>> To: web...@li... >>>> Subject: [webERP-users] A quck question on interfacing with >>>> accountants >>>> >>>> >>>> >>>> >>>> Hi everyone, >>>> >>>> This is a question for the Smaller firms here: >>>> What do you do when your accountant asks for your data at the end of >>>> the year? >>>> >>>> My accountant likes QB and imports my data into his package so that he >>>> has access to almost almost everything native. >>>> Having migrated to webERP do you just send trial balances etc? Anyone >>>> prepare a script to output a well known format csv etc. >>>> Do your accountants have access to the data online? >>>> >>>> Thanks. >>>> >>>> Al. >>>> >>>> >>>> -- >>>> No virus found in this incoming message. >>>> Checked by AVG Free Edition. >>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>> 1/26/2007 11:11 AM >>>> >>>> >>>> >>>> -- >>>> No virus found in this outgoing message. >>>> Checked by AVG Free Edition. >>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>> 1/26/2007 11:11 AM >>>> >>>> >>>> >>>> ------------------------------------------------------------------------- >>>> 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 >>>> _______________________________________________ web-ERP-users >>>> mailing list web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > -- > Internal Virus Database is out-of-date. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.5/645 - Release Date: 22/01/2007 > 4:10 p.m. > > |
From: <ec...@un...> - 2007-01-29 23:56:55
|
Quoting Todd Martin <to...@ko...>: > Well what if your accountant has dial-up internet, so his/her IP address i= s > not static? How do you configure your firewall then? In this case I would probably just choose an unused port, redirect it =20 for incoming traffic to the server that is running WebERP. The syntax =20 will depend on your firewall but in PF, the one I use with freebsd for =20 example something simple like the following will do the redirect. rdr on $ext_if inet proto tcp from any to ($ext_if) port 8001 -> 192.168.1.4 ext_if =3D external interface int_if =3D internal interface 192.168.1.4 would changed based on the IP of your webserver that you =20 are redirecting too. You may find something being blocked and will need to adjust other =20 firewall rules but it is usually pretty straight forward. Of course =20 anyone, not just your accountant, can access the webserver that you =20 have set up on port 8001 but if you only have WebERP configured on =20 that port in you webserver, they will only see the login screen. If =20 they want to try and login, just let them. The same you would do on =20 any webserver. Hope this helps, ed > > Todd. > > ----- Original Message ----- > From: <ec...@un...> > To: <web...@li...> > Sent: Tuesday, January 30, 2007 2:43 AM > Subject: Re: [webERP-users] A quck question on interfacing with accountant= s > > >> Quoting Alex Plumbley-Jones <al...@bp...>: >> >>> Ed, >>> >>> Unfortunately, it's early days yet so it's my own server (with a couple >>> of >>> firewalls between it and the outside world). I have ssh access from a >>> couple of known and static addresses. I'll have to get https going too. >> Hi Al, >> >> I really don't see https as being important yet, but two firewalls >> between your weberp installation and the world is important. It also >> opens up many questions. I will throw out a couple of possible >> solutions to the unknown questions but all be need firewall >> cooperation. The easiest would be to just stick weberp on the machine >> facing the internet and open a port for it to not interfere with >> standard http traffic and it would also give a bit of security by >> obscurity but not actually important. Another option equally quick >> would be to redirect through the firewalls to the internal machine. >> Both the above would give you and others access from home, the road, >> etc. The only other one I can think of that is completely >> restrictive, would be a vpn to your accountant but that opens up a can >> of worms that I'm not sure is even worth the time. From your comments >> and from experience he could be still using windows 3.11. Anyone else >> got an idea? >> >> ed >> >>> The aim is to change over accounting for April. I'm also looking at >>> vtiger >>> or sugar implementation; I've got an accounts system which I don't like >>> but >>> kinda works - the QB file is getting big so it seems to become unstable >>> when >>> it's actually happily processing - but our CRM system is not particularl= y >>> well formed! >>> >>> Best. >>> >>> Al. >>> >>> >>> -----Original Message----- >>> From: web...@li... >>> [mailto:web...@li...] On Behalf Of >>> ec...@un... >>> Sent: 29 January 2007 01:47 >>> To: web...@li... >>> Subject: Re: [webERP-users] A quck question on interfacing with >>> accountants >>> >>> Quoting Alex Plumbley-Jones <al...@bp...>: >>> >>>> That's what I'd like ot do but I think he's on dialup or a cheap >>>> provider with non-static IP addresses. >>>> I don't want to open the SSH port to and was looking for an alternative >>>> setup until I can get going; so I wondered if anyone has built an expor= t >>>> function or something. >>> >>> Do you have http or https internet access to the server that is >>> hosting WebERP or are they only accessable on the internal network? >>> >>> thanks, >>> >>> ed >>> >>>> >>>> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knockin= g >>>> - single packet) and >>>> >>> http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-y= our- >>> closed-linux-firewall/ (firewall knocking) which kinda solves my >>>> problem. >>>> >>>> I thought I'd list it here just in case anyone has the same idea. >>>> >>>> Thanks. >>>> >>>> Al. >>>> >>>> PS: Apologies to Daniel Britez whose thread I broke into - the mail >>>> headers must contain some additional info to put the replies in order s= o >>>> that my 'new thread' wasn't one. I hope he didn't think I was being >>>> rude; just careless in thought, and I'll put the list address in a >>>> proper place now! Sorry. >>>> >>>> >>>> >>>> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >>>>> Sure, give him access to it either from outside or when he comes to >>>>> your place depending on the level of security you believe in. You can >>>>> always set your router to allow only him, if he has a dedicated ip >>>>> address then no one else will be allowed. You can run webERP under >>>>> SSL (https) and set it only to allow access under https in system >>>>> settings thereby encrypting all info passed between the server and him >>>>> like the banks. >>>>> >>>>> It kind of depends on the amount of hands-on they do and the amount >>>>> your in-house people do. If you do most to all of the hands-on then >>>>> reports are fine. >>>>> >>>>> Your accountant may enjoy a real accounting/ERP system such as >>>>> webERP instead of a mess ;) It could be a breath of fresh air for >>>>> him, depending on his experience or lack of. >>>>> >>>>> Steve >>>>> >>>>> >>>>> >>>>> >>>>> ______________________________________________________________________ >>>>> From: web...@li... >>>>> [mailto:web...@li...] On Behalf Of Alex >>>>> Plumbley-Jones >>>>> Sent: Saturday, January 27, 2007 7:11 AM >>>>> To: web...@li... >>>>> Subject: [webERP-users] A quck question on interfacing with >>>>> accountants >>>>> >>>>> >>>>> >>>>> >>>>> Hi everyone, >>>>> >>>>> This is a question for the Smaller firms here: >>>>> What do you do when your accountant asks for your data at the end of >>>>> the year? >>>>> >>>>> My accountant likes QB and imports my data into his package so that he >>>>> has access to almost almost everything native. >>>>> Having migrated to webERP do you just send trial balances etc? Anyone >>>>> prepare a script to output a well known format csv etc. >>>>> Do your accountants have access to the data online? >>>>> >>>>> Thanks. >>>>> >>>>> Al. >>>>> >>>>> >>>>> -- >>>>> No virus found in this incoming message. >>>>> Checked by AVG Free Edition. >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>>> 1/26/2007 11:11 AM >>>>> >>>>> >>>>> >>>>> -- >>>>> No virus found in this outgoing message. >>>>> Checked by AVG Free Edition. >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>>> 1/26/2007 11:11 AM >>>>> >>>>> >>>>> >>>>> ----------------------------------------------------------------------= --- >>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>> Join SourceForge.net's Techsay panel and you'll get the chance to shar= e >>> your >>>>> opinions on IT & business topics through brief surveys - and earn cash >>>>> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >>>>> _______________________________________________ web-ERP-users >>>>> mailing list web...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-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=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >>> _______________________________________________ >>> web-ERP-users mailing list >>> web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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=3Djoin.php&p=3Dsourceforge&CID= =3DDEVDEV >>> _______________________________________________ >>> web-ERP-users mailing list >>> web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDEV >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> >> >> >> >> -- >> Internal Virus Database is out-of-date. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.5/645 - Release Date: 22/01/200= 7 >> 4:10 p.m. >> >> > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share yo= ur > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DD= EVDEV > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
From: Steve <st...@se...> - 2007-01-30 00:45:56
|
and you could even do the regular .htaccess password thing thereby having double login with the different systems. Set it up with https if you want too. Steve -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of ec...@un... Sent: Monday, January 29, 2007 6:57 PM To: web...@li... Subject: Re: [webERP-users] A quck question on interfacing with accountants Quoting Todd Martin <to...@ko...>: > Well what if your accountant has dial-up internet, so his/her IP address is > not static? How do you configure your firewall then? In this case I would probably just choose an unused port, redirect it for incoming traffic to the server that is running WebERP. The syntax will depend on your firewall but in PF, the one I use with freebsd for example something simple like the following will do the redirect. rdr on $ext_if inet proto tcp from any to ($ext_if) port 8001 -> 192.168.1.4 ext_if = external interface int_if = internal interface 192.168.1.4 would changed based on the IP of your webserver that you are redirecting too. You may find something being blocked and will need to adjust other firewall rules but it is usually pretty straight forward. Of course anyone, not just your accountant, can access the webserver that you have set up on port 8001 but if you only have WebERP configured on that port in you webserver, they will only see the login screen. If they want to try and login, just let them. The same you would do on any webserver. Hope this helps, ed > > Todd. > > ----- Original Message ----- > From: <ec...@un...> > To: <web...@li...> > Sent: Tuesday, January 30, 2007 2:43 AM > Subject: Re: [webERP-users] A quck question on interfacing with accountants > > >> Quoting Alex Plumbley-Jones <al...@bp...>: >> >>> Ed, >>> >>> Unfortunately, it's early days yet so it's my own server (with a couple >>> of >>> firewalls between it and the outside world). I have ssh access from a >>> couple of known and static addresses. I'll have to get https going too. >> Hi Al, >> >> I really don't see https as being important yet, but two firewalls >> between your weberp installation and the world is important. It also >> opens up many questions. I will throw out a couple of possible >> solutions to the unknown questions but all be need firewall >> cooperation. The easiest would be to just stick weberp on the machine >> facing the internet and open a port for it to not interfere with >> standard http traffic and it would also give a bit of security by >> obscurity but not actually important. Another option equally quick >> would be to redirect through the firewalls to the internal machine. >> Both the above would give you and others access from home, the road, >> etc. The only other one I can think of that is completely >> restrictive, would be a vpn to your accountant but that opens up a can >> of worms that I'm not sure is even worth the time. From your comments >> and from experience he could be still using windows 3.11. Anyone else >> got an idea? >> >> ed >> >>> The aim is to change over accounting for April. I'm also looking at >>> vtiger >>> or sugar implementation; I've got an accounts system which I don't like >>> but >>> kinda works - the QB file is getting big so it seems to become unstable >>> when >>> it's actually happily processing - but our CRM system is not particularly >>> well formed! >>> >>> Best. >>> >>> Al. >>> >>> >>> -----Original Message----- >>> From: web...@li... >>> [mailto:web...@li...] On Behalf Of >>> ec...@un... >>> Sent: 29 January 2007 01:47 >>> To: web...@li... >>> Subject: Re: [webERP-users] A quck question on interfacing with >>> accountants >>> >>> Quoting Alex Plumbley-Jones <al...@bp...>: >>> >>>> That's what I'd like ot do but I think he's on dialup or a cheap >>>> provider with non-static IP addresses. >>>> I don't want to open the SSH port to and was looking for an alternative >>>> setup until I can get going; so I wondered if anyone has built an export >>>> function or something. >>> >>> Do you have http or https internet access to the server that is >>> hosting WebERP or are they only accessable on the internal network? >>> >>> thanks, >>> >>> ed >>> >>>> >>>> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall knocking >>>> - single packet) and >>>> >>> http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your- >>> closed-linux-firewall/ (firewall knocking) which kinda solves my >>>> problem. >>>> >>>> I thought I'd list it here just in case anyone has the same idea. >>>> >>>> Thanks. >>>> >>>> Al. >>>> >>>> PS: Apologies to Daniel Britez whose thread I broke into - the mail >>>> headers must contain some additional info to put the replies in order so >>>> that my 'new thread' wasn't one. I hope he didn't think I was being >>>> rude; just careless in thought, and I'll put the list address in a >>>> proper place now! Sorry. >>>> >>>> >>>> >>>> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: >>>>> Sure, give him access to it either from outside or when he comes to >>>>> your place depending on the level of security you believe in. You can >>>>> always set your router to allow only him, if he has a dedicated ip >>>>> address then no one else will be allowed. You can run webERP under >>>>> SSL (https) and set it only to allow access under https in system >>>>> settings thereby encrypting all info passed between the server and him >>>>> like the banks. >>>>> >>>>> It kind of depends on the amount of hands-on they do and the amount >>>>> your in-house people do. If you do most to all of the hands-on then >>>>> reports are fine. >>>>> >>>>> Your accountant may enjoy a real accounting/ERP system such as >>>>> webERP instead of a mess ;) It could be a breath of fresh air for >>>>> him, depending on his experience or lack of. >>>>> >>>>> Steve >>>>> >>>>> >>>>> >>>>> >>>>> ______________________________________________________________________ >>>>> From: web...@li... >>>>> [mailto:web...@li...] On Behalf Of Alex >>>>> Plumbley-Jones >>>>> Sent: Saturday, January 27, 2007 7:11 AM >>>>> To: web...@li... >>>>> Subject: [webERP-users] A quck question on interfacing with >>>>> accountants >>>>> >>>>> >>>>> >>>>> >>>>> Hi everyone, >>>>> >>>>> This is a question for the Smaller firms here: >>>>> What do you do when your accountant asks for your data at the end of >>>>> the year? >>>>> >>>>> My accountant likes QB and imports my data into his package so that he >>>>> has access to almost almost everything native. >>>>> Having migrated to webERP do you just send trial balances etc? Anyone >>>>> prepare a script to output a well known format csv etc. >>>>> Do your accountants have access to the data online? >>>>> >>>>> Thanks. >>>>> >>>>> Al. >>>>> >>>>> >>>>> -- >>>>> No virus found in this incoming message. >>>>> Checked by AVG Free Edition. >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>>> 1/26/2007 11:11 AM >>>>> >>>>> >>>>> >>>>> -- >>>>> No virus found in this outgoing message. >>>>> Checked by AVG Free Edition. >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: >>>>> 1/26/2007 11:11 AM >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------- >>>>> 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 >>>>> _______________________________________________ web-ERP-users >>>>> mailing list web...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 >>> _______________________________________________ >>> web-ERP-users mailing list >>> web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 >>> _______________________________________________ >>> web-ERP-users mailing list >>> web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> >> >> >> >> -- >> Internal Virus Database is out-of-date. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.17.5/645 - Release Date: 22/01/2007 >> 4:10 p.m. >> >> > > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-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 _______________________________________________ web-ERP-users mailing list web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-users -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 9:04 AM |
From: Phil D. <we...@pa...> - 2007-01-30 06:01:48
|
Apache security allows you to set a password for htaccess but also you can allow connections from a specific IP address that doesn't need an apache login at all - so if your accountant has a fixed IP then you can tell apache to allow his IP without an apache password. I think a twin set of user name password and https should satisfy most for security! Phil On Tuesday 30 January 2007 13:45, Steve wrote: > and you could even do the regular .htaccess password thing thereby having > double login with the different systems. Set it up with https if you want > too. > > Steve > > -----Original Message----- > From: web...@li... > [mailto:web...@li...] On Behalf Of > ec...@un... > Sent: Monday, January 29, 2007 6:57 PM > To: web...@li... > Subject: Re: [webERP-users] A quck question on interfacing with accountants > > Quoting Todd Martin <to...@ko...>: > > Well what if your accountant has dial-up internet, so his/her IP address > > is > > > not static? How do you configure your firewall then? > > In this case I would probably just choose an unused port, redirect it > for incoming traffic to the server that is running WebERP. The syntax > will depend on your firewall but in PF, the one I use with freebsd for > example something simple like the following will do the redirect. > > rdr on $ext_if inet proto tcp from any to ($ext_if) port 8001 -> > 192.168.1.4 > > ext_if = external interface > int_if = internal interface > 192.168.1.4 would changed based on the IP of your webserver that you > are redirecting too. > > You may find something being blocked and will need to adjust other > firewall rules but it is usually pretty straight forward. Of course > anyone, not just your accountant, can access the webserver that you > have set up on port 8001 but if you only have WebERP configured on > that port in you webserver, they will only see the login screen. If > they want to try and login, just let them. The same you would do on > any webserver. > > Hope this helps, > > ed > > > Todd. > > > > ----- Original Message ----- > > From: <ec...@un...> > > To: <web...@li...> > > Sent: Tuesday, January 30, 2007 2:43 AM > > Subject: Re: [webERP-users] A quck question on interfacing with > > accountants > > >> Quoting Alex Plumbley-Jones <al...@bp...>: > >>> Ed, > >>> > >>> Unfortunately, it's early days yet so it's my own server (with a couple > >>> of > >>> firewalls between it and the outside world). I have ssh access from a > >>> couple of known and static addresses. I'll have to get https going > >>> too. > >> > >> Hi Al, > >> > >> I really don't see https as being important yet, but two firewalls > >> between your weberp installation and the world is important. It also > >> opens up many questions. I will throw out a couple of possible > >> solutions to the unknown questions but all be need firewall > >> cooperation. The easiest would be to just stick weberp on the machine > >> facing the internet and open a port for it to not interfere with > >> standard http traffic and it would also give a bit of security by > >> obscurity but not actually important. Another option equally quick > >> would be to redirect through the firewalls to the internal machine. > >> Both the above would give you and others access from home, the road, > >> etc. The only other one I can think of that is completely > >> restrictive, would be a vpn to your accountant but that opens up a can > >> of worms that I'm not sure is even worth the time. From your comments > >> and from experience he could be still using windows 3.11. Anyone else > >> got an idea? > >> > >> ed > >> > >>> The aim is to change over accounting for April. I'm also looking at > >>> vtiger > >>> or sugar implementation; I've got an accounts system which I don't like > >>> but > >>> kinda works - the QB file is getting big so it seems to become unstable > >>> when > >>> it's actually happily processing - but our CRM system is not > > particularly > > >>> well formed! > >>> > >>> Best. > >>> > >>> Al. > >>> > >>> > >>> -----Original Message----- > >>> From: web...@li... > >>> [mailto:web...@li...] On Behalf Of > >>> ec...@un... > >>> Sent: 29 January 2007 01:47 > >>> To: web...@li... > >>> Subject: Re: [webERP-users] A quck question on interfacing with > >>> accountants > >>> > >>> Quoting Alex Plumbley-Jones <al...@bp...>: > >>>> That's what I'd like ot do but I think he's on dialup or a cheap > >>>> provider with non-static IP addresses. > >>>> I don't want to open the SSH port to and was looking for an > >>>> alternative setup until I can get going; so I wondered if anyone has > >>>> built an > > export > > >>>> function or something. > >>> > >>> Do you have http or https internet access to the server that is > >>> hosting WebERP or are they only accessable on the internal network? > >>> > >>> thanks, > >>> > >>> ed > >>> > >>>> I stumbled on this: http://www.cipherdyne.org/fwknop/ (firewall > > knocking > > >>>> - single packet) and > > http://www.ducea.com/2006/07/05/how-to-safely-connect-from-anywhere-to-your >- > > >>> closed-linux-firewall/ (firewall knocking) which kinda solves my > >>> > >>>> problem. > >>>> > >>>> I thought I'd list it here just in case anyone has the same idea. > >>>> > >>>> Thanks. > >>>> > >>>> Al. > >>>> > >>>> PS: Apologies to Daniel Britez whose thread I broke into - the mail > >>>> headers must contain some additional info to put the replies in order > > so > > >>>> that my 'new thread' wasn't one. I hope he didn't think I was being > >>>> rude; just careless in thought, and I'll put the list address in a > >>>> proper place now! Sorry. > >>>> > >>>> On Sat, 2007-01-27 at 19:23 -0500, Steve wrote: > >>>>> Sure, give him access to it either from outside or when he comes to > >>>>> your place depending on the level of security you believe in. You > >>>>> can always set your router to allow only him, if he has a dedicated > >>>>> ip address then no one else will be allowed. You can run webERP > >>>>> under SSL (https) and set it only to allow access under https in > >>>>> system settings thereby encrypting all info passed between the server > >>>>> and him like the banks. > >>>>> > >>>>> It kind of depends on the amount of hands-on they do and the amount > >>>>> your in-house people do. If you do most to all of the hands-on then > >>>>> reports are fine. > >>>>> > >>>>> Your accountant may enjoy a real accounting/ERP system such as > >>>>> webERP instead of a mess ;) It could be a breath of fresh air for > >>>>> him, depending on his experience or lack of. > >>>>> > >>>>> Steve > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> _____________________________________________________________________ > >>>>>_ From: web...@li... > >>>>> [mailto:web...@li...] On Behalf Of > >>>>> Alex Plumbley-Jones > >>>>> Sent: Saturday, January 27, 2007 7:11 AM > >>>>> To: web...@li... > >>>>> Subject: [webERP-users] A quck question on interfacing with > >>>>> accountants > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> Hi everyone, > >>>>> > >>>>> This is a question for the Smaller firms here: > >>>>> What do you do when your accountant asks for your data at the end of > >>>>> the year? > >>>>> > >>>>> My accountant likes QB and imports my data into his package so that > >>>>> he has access to almost almost everything native. > >>>>> Having migrated to webERP do you just send trial balances etc? Anyone > >>>>> prepare a script to output a well known format csv etc. > >>>>> Do your accountants have access to the data online? > >>>>> > >>>>> Thanks. > >>>>> > >>>>> Al. > >>>>> > >>>>> > >>>>> -- > >>>>> No virus found in this incoming message. > >>>>> Checked by AVG Free Edition. > >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > >>>>> 1/26/2007 11:11 AM > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> No virus found in this outgoing message. > >>>>> Checked by AVG Free Edition. > >>>>> Version: 7.5.432 / Virus Database: 268.17.12/653 - Release Date: > >>>>> 1/26/2007 11:11 AM > > ------------------------------------------------------------------------- > > >>>>> 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 > > >>>>> _______________________________________________ web-ERP-users > >>>>> mailing list web...@li... > >>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 > > >>> _______________________________________________ > >>> web-ERP-users mailing list > >>> web...@li... > >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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 > > >>> _______________________________________________ > >>> web-ERP-users mailing list > >>> web...@li... > >>> https://lists.sourceforge.net/lists/listinfo/web-erp-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=DEVDE > >>V _______________________________________________ > >> web-ERP-users mailing list > >> web...@li... > >> https://lists.sourceforge.net/lists/listinfo/web-erp-users > >> > >> > >> > >> > >> -- > >> Internal Virus Database is out-of-date. > >> Checked by AVG Free Edition. > >> Version: 7.5.432 / Virus Database: 268.17.5/645 - Release Date: > > 22/01/2007 > > >> 4:10 p.m. > > > > ------------------------------------------------------------------------- > > 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 > > _______________________________________________ > > web-ERP-users mailing list > > web...@li... > > https://lists.sourceforge.net/lists/listinfo/web-erp-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 > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.14/657 - Release Date: 1/29/2007 > 9:04 AM |
From: Phil D. <we...@pa...> - 2007-01-28 06:11:31
|
Well its even easier than that you can just give them a login! Phil Alex Plumbley-Jones wrote: > Hi everyone, > > This is a question for the Smaller firms here: > What do you do when your accountant asks for your data at the end of the > year? > > My accountant likes QB and imports my data into his package so that he > has access to almost almost everything native. > Having migrated to webERP do you just send trial balances etc? Anyone > prepare a script to output a well known format csv etc. > Do your accountants have access to the data online? > > Thanks. > > Al. > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------ > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > ------------------------------------------------------------------------ > > Internal Virus Database is out-of-date. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.12.8/455 - Release Date: 22/09/2006 > |