Re: Customer Code ?
Donald Baud <donaldbaud-/[email protected]> Fri, 26 May 2006 13:34:55 -0700 (PDT)
| Newsgroups | gmane.comp.web.sql-ledger.user |
|---|---|
| Message-ID | <[email protected]> |
> On Thursday 25 May 2006 20:50, David J wrote: > > Hi Stuart > > Thx for the suggestion. > > Is there some way we can select customers by their > CODE, > > rather than by name, or part of name ? Isn't that > why > > customers have codes ? > > I've implemented this for a client of mine. Replace > sub get_name in > $BASE/SL/Form.pm with this code, and in that first > field, where you can put > the customer or vendor name, you can also put a > 'Customer Number' (I presume > that's what you mean by code) -- The same rules of > matching apply, if your > search string is a substring of another customer or > name, you'll have to > click it off the results. > This is good but when you search by customer name, you still have the "name" field as the clickable info, I really wish the customer number was the clickable field. Personally, I am simply discarding the customer number and using the customer name as the customer code. This is very unfortunate because: 1- customer name can have duplicates. 2- I have to use address1 as the official customer name Can someone please answer the original question on what is the purpose of customer-number in sql-ledger? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ sql-ledger-users mailing list sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/sql-ledger-users