[Ledger-smb-users] Sales order to invoice

2017-03-12 Thread lai
Hi: I have a sales order to invoice question for Ledger SMB. What happens when a user had forgotten to post an invoice after it was transferred from a sales order? It happens to us sometimes and and the browser was closed and we would discovered later that the sales invoice was missing. Further, t

Re: [Ledger-smb-users] Returning Security Deposits

2013-08-08 Thread lai
Bill: I'm not an accountant but SL user since 2002... I would set up deposit as a liability account with receivable income and payable expense as options as it certainly isn't an asset nor revenue... Don't use AR invoice and use AR transaction to receive the deposite as you neither offering a se

Re: [Ledger-smb-users] Request for comments: towards CRM functionality

2011-07-27 Thread lai
>> LX-Office is also a fork of SQL-Ledger. >> http://sourceforge.net/projects/lx-office/ >> >> There is a CRM extension available as well as a shop interface. >> I could imagine the interface works with OSC. >> http://sourceforge.net/projects/lx-office/files/ >> LX-Office has it addressed the reve

Re: [Ledger-smb-users] Future of LedgerSMB: Ideas and RFC

2011-05-19 Thread lai
Has LedgerSMB a way to deal with the good ole COGS error with reversing sales invoice? I imagine this fundamental error is something important to users who offer tangible goods. One suggestion in the past was to restock items under AP, but that's not as easy as it seems. For a small business doing

Re: [Ledger-smb-users] An Actual Payroll Module - When?

2011-01-31 Thread lai
Seriously, for $30 a month we pay Chase for our payroll solution it is well worthwhile...it includes tax filing reminder and all the forms...just have integration for payroll GL entry import/export seems reasonable...my $0.02... > On Mon, Jan 31, 2011 at 9:08 AM, ERACC Subscriptions > wrote: >> O

Re: [Ledger-smb-users] Integration with e-commerce software?

2010-05-26 Thread lai
Perl API that's about it. It is powerful and we use it to enter customers and sales orders. You should also look into using slony for replication, we use it to support real time inventory, and paperless invoice. If you are not a programmer/business consultant, get one if you are serious with the bu

Re: [Ledger-smb-users] Running away from SQL-Ledger

2010-04-21 Thread lai
> Thanks Tim. Your welcome! I recall last year when we upgarded to Centos 5.3 and SL 2.6 we were neck deep...the Centos/Perl distribution by default compiles with usethread. > We found the info you kindly pointed us to before asking the question. > In some cases, the error goes away, although it

Re: [Ledger-smb-users] Running away from SQL-Ledger

2010-04-20 Thread lai
no need to run...it has to do with perl and certain platforms. checkout the links below...we were able to solve it in an afternoon. just recompile perl without the usethread option. we are using sl 2.8.17., and will be using it probably for the next ten years as we had invested a lot of times in re

Re: [Ledger-smb-users] Remote login

2010-03-28 Thread lai
er had probably wondered why we had paid for support twice in 8 years--the first time the manual for starting with the software, and the second time the manual when an upgraded was performed. Yes, the upgarde was painful. Tim > On Sat, Mar 27, 2010 at 12:06 PM, Tim Lai > wrote: >> T

Re: [Ledger-smb-users] Remote login

2010-03-27 Thread Tim Lai
Try openswan way back redhat7.3. Can't get it to compile. Is openswan easier to implement now? We are always short of time so had to take the easier path. Tim Sent from my iPhone On Mar 27, 2010, at 9:14 AM, Chris Travers wrote: > particularly scalable. > OpenVPN while fairly scalable was

Re: [Ledger-smb-users] Remote login

2010-03-26 Thread Tim Lai
Use openvpn for six years now. It works great, except for remote login from iPhones. Some of the phones got upgraded to the latest firmware and can't be jailedbreaked, so no openvpn support. Then again, there is no official support of openvpn on iPhones. The tmp solution...random dir name a

Re: [Ledger-smb-users] Problem With Saving Parts

2009-12-09 Thread lai
my guest is it is a primary key of the table partsvendor and you should check and see if it is generated by a sequence or if it is from an input variable. if it is the latter may be you are entering duplicated partsvendor info. the other would be the code has a booboo. lastly, something similar ha

Re: [Ledger-smb-users] Postgres Access Timing

2009-07-23 Thread lai
it seems like you would need transaction control. also, in you sql statement, there should be a clause that allows you to set a wait time for data control language (dcl) when encountered a locking issue. often, it is undesirable to have locking issues within an app. probably should start looking at

Re: [Ledger-smb-users] On Hand correction

2009-02-19 Thread lai
It seems no one has a fix for this COGS thing still, I started using SL since 02. It is critical and I can't imagine how many real customers it'll bring with a fix. Ideally speaking, if the logics were there, then there should not be an issue with COG. However, since there are not, may be the whole

Re: [Ledger-smb-users] Credit Card Accounting

2008-10-30 Thread lai
May I add... >> I created a new ledger 2150 - American express >> >> Now, let's say I have 25 purchases using the credit card over the month >> I >> need to account for. Do I add each one of those purchases one at a time >> in >> the "Vender Transaction" interface? > > I would recommend this. W

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
Chris: Thank you for the response! As we really need the data near real time so we are probably going to head down the Slony-I direction. Thanks for the pointer on the primary key and it just darn on me when I read your email. However, it probably shouldn't be a show stoper as it should be alright

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
Thanks for the reply! We do use Openvpn for our offices but as this server is hosted so by company policy it is not allowed to have a VPN connection into to our network. Further, when it comes to the data layer we would like to have it be managed by our databases. I apologize that we still use SL,

[Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
hello all...our business has now the need to replicate our sl/postgres db from our main office in ca to ny as the ny system (public and outside of our firewall) has the need to generate non-critical read only invoice and inventory reports. our requirements are real simple and slony-i seems to be an

Re: [Ledger-smb-users] Transaction reversal - I think

2008-05-20 Thread lai
don't panic it seems like you have your old system you can still use. then worst come to worst for example in the u.s. you'll just have to pay a penalty for filing late. that is probably still less then the fees for a good consultant. anyhow have you checked your purchase and compare it with your o

Re: [Ledger-smb-users] Transaction reversal - I think

2008-05-19 Thread lai
if you sell tangible goods check to see the purchase/cogs are calculated properly. our businese use sl and at each monthend we have to do a journal entry to correct cog/inventory to reflect the actual values and it is typical that the values are off by 15-20%. that could be quite a bit of money if

Re: [Ledger-smb-users] Not Strictly LSMB but....

2008-04-22 Thread lai
richard, i have not looked into lsmb's schema but in the ole sl schema partnumber isn't unique so in the long run it would be a better idea to use id instead of partnumber in your where clause. we have thousands of partnumber coming from different suppliers and the only way we are able to check fo

Re: [Ledger-smb-users] PDF invoice pain

2007-12-18 Thread lai
check the few invoices that are causing the issue as they are isolated cases. typical issue with latex is if you have a slash "/" in your note field and that could cause problems with latex. good luck...tim >> Are you using custom templates? I've seen this happen before with >> templates with LaT

Re: [Ledger-smb-users] Fixing incorrect inventory

2007-09-10 Thread lai
Start a new book is a good idea too...this is the worst part of the softwares. If you only have a few inventories that are off you should look into the AR and AP to see how it happened and try correcting it. Remember, when you create an invoice from sales order and if that invoice is only a partia

Re: [Ledger-smb-users] Is LSMB really suitable for the public?

2007-04-27 Thread lai
> >> That's probably what I would do one day when I feel SMB is more suitable >> to my business than SL. > > Lets explore those reasons that are holding you back then? Are they... My dad taught me if it ain't broken don't touch it and if it is then get the duct tape out. Well, putting the joke as

Re: [Ledger-smb-users] Is LSMB really suitable for the public?

2007-04-25 Thread lai
> Problems notwithstanding, I feel way more comfortable with your > approach. Congratulations, and keep up the good work. Same here for me... > If I dump my old SL system and start again, should I expect problems > with a clean install? Our financial year ends 30 June, and my intention > was to s