sql-ledger-users — SQL-Ledger users

part / assembly + pricing

[J. R. <ho...@ea...>]

a few quick questions:

1) is there a way to auto-update all assemblies when their component parts change price? i.e., we make 'partA' and set it's price to $50, use that in 'assemblyA'. when 'partA' jumps in price to, say, $150, is it possible to automatically adjust the price of the assembly, rather than doing it manually? (if it's possible to do this as a script/cronjob/whatever, that's fine -- just need a way to do it that doesn't require the user to manually update 1000 assemblies.)

2) quantity on hand seems broken, or i'm not understanding something.

example: i create three parts, and stock them with a vendor invoice. i create an assembly using those parts, and stock, say, 50 of them. the quantity on hand of the parts changes as expected. create a new customer, create a sales order for 50 of the assembly.

now, it's my understanding that when i create an invoice for that order and post it to the system, the quantity on hand should change, yes? (invoice equating to 'this order needs to be shipped and the customer will pay us in 'x' days?)

i would guess that as soon as i post the invoice, the quantity on hand for the assembly should drop to 0. from the tests i've done, it doesn't. i've tried leaving the original sales order intact, or deleting it when prompted. nothing seems to make the quantity change at all.

when i delete the posted invoice, however, i end up with 100 of the that assembly in inventory, opposed to the 50 i started with.

huh?

(this is using the most current version btw, 1.8.2)

thanks in advance -
justin
ho...@ea...
-- 

Re: posting to this list

[Sergio A. K. <ser...@ho...>]

http://groups.yahoo.com set the reply-to to the list.

the bad news: the administrator have to have a yahoo account
and yahoo insert html advertising in the foot of every msg.

otherwise is a very nice and flexible system.

/sergio

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>


> Sourceforge has turned off the Reply-To list feature because apparently it
> is not proper email etiquette to force a reply-to. I too, on the other
> hand, feel that everyone on the list looses because a lot of the members
> on the list reply directly rather than to the list. This is evident when
> you look at the question/answer ratio.
>
> If someone has a suggestion of moving the list to another server please
> let me know and I'll move it. It's a great deal of work for me but I think
> it is worthwhile in the long run.
>
> I am not all that happy with how Sourceforge is handling various issues,
> including this tiny tidbit with the mailing lists.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Sat, 16 Feb 2002, Kenneth Gonsalves wrote:
>
> > hi all
> > i have been regularly posting to this list, but since i am a subscriber
to
> > several lists, i automatically delete any list message 'from' me without
> > reading it. so i just discovered that none of my posts are coming to the
list
> > - they are all going to the individual to whom i am replying. personally
i
> > feel that when pressing the 'reply' button on a message in a list, the
reply
> > should go to the list - else it is a big headache, and i feel the list
> > members are also losing in the sense that many replies to problems faced
are
> > not appearing on the list at all. could the list admin do something
about
> > this?
> > kg
> >
> >
>
>
>

Re: General Questions

[Steve D. <sd...@sw...>]

Hi Jeff.

Jeff Strope wrote:

> Hello all,
>
> First, I'd like to say thanks to everyone involved with this project. We're
> a company just beginning operations, and SQL-Ledger has given us a fantastic
> product for our initial accounting needs at an equally fantastic price.
> After my experiences with Oracle Fin. & Great Plains, I'm still a little
> confused on how we got this system built, deployed, and integrated with our
> on-line application in less than 3 weeks.

Something to do with having the source code, perhaps?

> Secondly, I do have a couple of questions that were given to me by a
> third-party who did a brief audit of the system, mostly non-technical. My
> knowledge of accounting best practices is minimal at best, so I would
> appreciate it if any of you would send along your experiences, fixes, or
> work-arounds for the following items. Thanks in advance for your advice.
>
> Here are a few of the questions he sent me:
>
> Is there functionality for write offs/bad debts?

Edit the acct. "bad debt exp." and check the deposit button under receivables.
Then if a customer sends you 9,000 for a 10,000 dollar invoice and tells you
that's it, they are bankrupt, you can apply the 1,000 left on their invoice to
bad debt expense and close the invoice.

That's the direct write-off method.

If you need to follow U.S. GAAP, you need to use the allowance method which
would go like this.

DON'T mark bad debt exp. as a deposit item (the default).  Add an acct. called
"Bad Debt Reserve" or "Allowance for bad debt".  Check it as a liability and
check it's deposit button under receivables.  Number it right after the AR
acct. number so it shows as a contra asset.

Say you figure 5% of your AR will be uncollectible.  Go into GL->Add
Transaction and book the following:
Debit - 5620 - Bad Debt Exp.    (5% of AR)
Credit - 1255 - Bad Debt reserve Seattle            (5% of AR)

Then when you have actual write-offs, you apply the amount to Bad debt reserve
like a payment.

I did an example of this on the Seattle demo (http://www.sql-ledger.com).

Look at the trial balance. See acct. 1255 for the 5% accrual and then see my
10,000 dollar write-off for customer Albatross's inv. # 324412

> Where will you track the customer's check numbers?  Source?

I believe that's the intent of the field as far as AR goes.

> How do you void checks?

Delete the AP transaction.

> How do you reissue checks?

Generate another AP transaction.

> How will you do a bank reconciliation?  Where do you mark that a check has
> cleared the bank?

On a spreadsheet.  Just put the bank statement balance at the top, the G/L cash
acct. balance at the bottom with a list of uncleared checks in between.  You
don't need to mark them cleared in the G/L because basically you pretend
they've cleared by reducing the cash acct. when they are issued.  It's just
like your personal checkbook, where you remove them from your balance when you
write them.  Untill the bank actually clears it, it's a rec item.

> Where are the check numbers in the system?  Are they the Source?
>
> That's it. Thanks so much for your help!

Good luck w/ everything.
Steve

>
>
> -Jeff Strope

Re: posting to this list

[Jonas S. <jo...@jo...>]

On Sat, 16 Feb 2002, Dieter Simader wrote:

> If someone has a suggestion of moving the list to another server please
> let me know and I'll move it. It's a great deal of work for me but I
> think it is worthwhile in the long run.

As suggested earlier I will gladly offer to host the mailinglist - setting
it up however is consensus (or Dieters final word).

And no - I won't put advertising anywhere. I never found out what it was
Dieter experienced looking at my server some time ago...

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: posting to this list

[kevin b. <kev...@bi...>]

hi there,

in the meantime maybe there could be a regular monthly reminder to tell 
people to hit the 'reply-all' button?

i'm not sure what sourceforge are playing at - surely its better for 
these crucial lists to work properly than follow some obscure etiquette?

kev bailey

Dieter Simader wrote:

> Sourceforge has turned off the Reply-To list feature because apparently it
> is not proper email etiquette to force a reply-to. I too, on the other
> hand, feel that everyone on the list looses because a lot of the members
> on the list reply directly rather than to the list. This is evident when
> you look at the question/answer ratio.
> 
> If someone has a suggestion of moving the list to another server please
> let me know and I'll move it. It's a great deal of work for me but I think
> it is worthwhile in the long run.
> 
> I am not all that happy with how Sourceforge is handling various issues, 
> including this tiny tidbit with the mailing lists.
> 
> 
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
> 
> On Sat, 16 Feb 2002, Kenneth Gonsalves wrote:
> 
> 
>>hi all
>>i have been regularly posting to this list, but since i am a subscriber to 
>>several lists, i automatically delete any list message 'from' me without 
>>reading it. so i just discovered that none of my posts are coming to the list 
>>- they are all going to the individual to whom i am replying. personally i 
>>feel that when pressing the 'reply' button on a message in a list, the reply 
>>should go to the list - else it is a big headache, and i feel the list 
>>members are also losing in the sense that many replies to problems faced are 
>>not appearing on the list at all. could the list admin do something about 
>>this?
>>kg
>>
>>
>>
> 
> 
> 
> 

Re: posting to this list

[Rod R. <ro...@su...>]

Well I feel it's close to a non-issue, as users always get to choose 
where their mail goes.  What the default reply-to does is "suggest"
where most replies should go.

Since replies tend to be answers to questions, and of interest to more
than one person, I prefer the reply-to header.  That way more good
stuff gets into the archives.

Of course I understand that Sourceforge wants to reduce their huge
bandwidth costs, and so does whatever they can to reduct demand.
Good for them, bad for us.

-- Rod
   http://www.sunsetsystems.com/

On Saturday 16 February 2002 10:11 am, Keld Jørn Simonsen wrote:
> I think it is great that sourceforge have turned this option off,
> and take it as yet another reason to stay with sourceforge.
> Automatic Reply-to has always annoyed me and none of the lists
> I administer use it.
>
> Kind regards
> Keld

Re: posting to this list

[<ke...@dk...>]

I think it is great that sourceforge have turned this option off,
and take it as yet another reason to stay with sourceforge.
Automatic Reply-to has always annoyed me and none of the lists
I administer use it.

Kind regards
Keld

On Sat, Feb 16, 2002 at 09:51:08AM -0700, Dieter Simader wrote:
> Sourceforge has turned off the Reply-To list feature because apparently it
> is not proper email etiquette to force a reply-to. I too, on the other
> hand, feel that everyone on the list looses because a lot of the members
> on the list reply directly rather than to the list. This is evident when
> you look at the question/answer ratio.
> 
> If someone has a suggestion of moving the list to another server please
> let me know and I'll move it. It's a great deal of work for me but I think
> it is worthwhile in the long run.
> 
> I am not all that happy with how Sourceforge is handling various issues, 
> including this tiny tidbit with the mailing lists.
> 
> 
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
> 
> On Sat, 16 Feb 2002, Kenneth Gonsalves wrote:
> 
> > hi all
> > i have been regularly posting to this list, but since i am a subscriber to 
> > several lists, i automatically delete any list message 'from' me without 
> > reading it. so i just discovered that none of my posts are coming to the list 
> > - they are all going to the individual to whom i am replying. personally i 
> > feel that when pressing the 'reply' button on a message in a list, the reply 
> > should go to the list - else it is a big headache, and i feel the list 
> > members are also losing in the sense that many replies to problems faced are 
> > not appearing on the list at all. could the list admin do something about 
> > this?
> > kg
> > 
> > 
> 

General Questions

[Jeff S. <js...@en...>]

Hello all,

First, I'd like to say thanks to everyone involved with this project. We're
a company just beginning operations, and SQL-Ledger has given us a fantastic
product for our initial accounting needs at an equally fantastic price.
After my experiences with Oracle Fin. & Great Plains, I'm still a little
confused on how we got this system built, deployed, and integrated with our
on-line application in less than 3 weeks.

Secondly, I do have a couple of questions that were given to me by a
third-party who did a brief audit of the system, mostly non-technical. My
knowledge of accounting best practices is minimal at best, so I would
appreciate it if any of you would send along your experiences, fixes, or
work-arounds for the following items. Thanks in advance for your advice.

Here are a few of the questions he sent me:

Is there functionality for write offs/bad debts?

Where will you track the customer's check numbers?  Source?

How do you void checks?

How do you reissue checks?

How will you do a bank reconciliation?  Where do you mark that a check has
cleared the bank?

Where are the check numbers in the system?  Are they the Source?

That's it. Thanks so much for your help!

-Jeff Strope

Re: posting to this list

[Wil C. <wc...@na...>]

Also Sprach Kenneth Gonsalves <la...@th...> on Sat, Feb 16, 2002=
 at 02:44:50AM PST
> hi all
> i have been regularly posting to this list, but since i am a subscriber t=
o=20
> several lists, i automatically delete any list message 'from' me without=
=20
> reading it. so i just discovered that none of my posts are coming to the =
list=20
> - they are all going to the individual to whom i am replying. personally =
i=20
> feel that when pressing the 'reply' button on a message in a list, the re=
ply=20
> should go to the list - else it is a big headache, and i feel the list=20
> members are also losing in the sense that many replies to problems faced =
are=20
> not appearing on the list at all. could the list admin do something about=
=20
> this?

Try the 'reply-to-all' button.

Wil
--=20
W. Reilly Cooley                           wc...@na...
Naked Ape Consulting                        http://nakedape.cc
irc.linux.com                                     #orlug,#lnxs

The public demands certainties;  it must be told definitely and a bit
raucously that this is true and that is false.  But there are no certaintie=
s.
		-- H.L. Mencken, "Prejudice"

Re: posting to this list

[Dieter S. <dsi...@sq...>]

Sourceforge has turned off the Reply-To list feature because apparently it
is not proper email etiquette to force a reply-to. I too, on the other
hand, feel that everyone on the list looses because a lot of the members
on the list reply directly rather than to the list. This is evident when
you look at the question/answer ratio.

If someone has a suggestion of moving the list to another server please
let me know and I'll move it. It's a great deal of work for me but I think
it is worthwhile in the long run.

I am not all that happy with how Sourceforge is handling various issues, 
including this tiny tidbit with the mailing lists.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sat, 16 Feb 2002, Kenneth Gonsalves wrote:

> hi all
> i have been regularly posting to this list, but since i am a subscriber to 
> several lists, i automatically delete any list message 'from' me without 
> reading it. so i just discovered that none of my posts are coming to the list 
> - they are all going to the individual to whom i am replying. personally i 
> feel that when pressing the 'reply' button on a message in a list, the reply 
> should go to the list - else it is a big headache, and i feel the list 
> members are also losing in the sense that many replies to problems faced are 
> not appearing on the list at all. could the list admin do something about 
> this?
> kg
> 
> 

posting to this list

[Kenneth G. <la...@th...>]

hi all
i have been regularly posting to this list, but since i am a subscriber to 
several lists, i automatically delete any list message 'from' me without 
reading it. so i just discovered that none of my posts are coming to the list 
- they are all going to the individual to whom i am replying. personally i 
feel that when pressing the 'reply' button on a message in a list, the reply 
should go to the list - else it is a big headache, and i feel the list 
members are also losing in the sense that many replies to problems faced are 
not appearing on the list at all. could the list admin do something about 
this?
kg

Re: Setting up initial account balances

[Richard L. <ri...@th...>]

On Saturday 16 February 2002  8:13, Tom Cooper wrote:
> Hi all,
> 
> I am rying to set up a new database. How do i set up initial
> account balances? The FAQ mentoins doing a GL entry,
> but I can't do it. If I want to credit the cheque account, what
> do I debit?

Unless you are in the red, you probably want to _debit_ the cheque account.

Use your balance sheet at the end of the previous period to set all the 
starting balances, which should then be in balance.

What I would do (I'm no accountant so ask an expert) when I have to leave the 
account out of balance temporarily, is this. I set up a liability account 
called "starting balance" to hold the unbalanced amount.  That account 
reverts to zero once I have sorted the balances of all the accounts.

--
richard

Setting up initial account balances

[Tom C. <to...@ne...>]

Hi all,

I am rying to set up a new database. How do i set up initial
account balances? The FAQ mentoins doing a GL entry,
but I can't do it. If I want to credit the cheque account, what
do I debit?

Regards,

Tom Cooper

Porting of SQL-Ledger to run on top of phpgroupware

[C K Wu <ck...@ch...>]

Hello, folks,

This is a rather lengthy post.  Please bear with me.

I have started a project at sourceforge and named it, CK-Ledger, which
is a port of SQL-Ledger to phpgroupware.  Before I go any further, I
like to congratulate Dieter Simader and the SQL-Ledger team in
developing an excellent open source solution.

Since CK-Ledger is based on SQL-Ledger, its functionalities are very
similar to SQL-Ledger's.  The features that I have added, include,

LedgerAdmin =96 data backup/restore;
Ledger =96 audit control report, account journal history, ledger listing;
Inventory =96 audit control report, inventory in/out history, explicit
inventory adjustment transaction, goods receipt transaction, good
delivery transaction;
Service =96 separate module for access by non-warehouse staff;
Accounts Payable =96 audit control report, manual override of system
calculated tax, separate rate and account setting for tax received and
paid, explicit payment transaction, matching of payment against invoice
allowing one payment settling multiple invoices, invoice/PO matching,
invoice payment history, cheque printing;
Accounts Receivable =96 audit control report, manual override of system
calculated tax, separate rate and account setting for tax received and
paid, explicit receipt transaction, matching of receipt against invoice
allowing one receipt settling multiple invoices, invoice/SO matching,
invoice receipt history, customer statement, invoice reminder, official
receipt;
Purchase Order =96 audit control report, purchase order billing history;
Sales Order =96 audit control report, sales order billing history, order
acknowledgement;

However, there are SQL-Ledger features that I have not (or not yet)
implemented, notably standalone AP/AR transactions and foreign currency
translation.  At the same time, the internal data structure of CK-Ledger
and SQL-Ledger are different.

Most transactions are provided with standard search, add, view copy and
delete facilities.  Journal reversing feature is included.  While
currently, here in Hong Kong, we do not charge a transactional tax (in
the form of sales or VAT tax), such tax is being contemplated.
Therefore, I have produced, 2 streams, to handle invoices, POs and SOs
that do and do not carry tax.

CK-Ledger is structured as 8 phpgroupware modules, LedgerAdmin, Ledger,
Inventory, Service, AccountsPayable, AccountsReceivable, PurchaseOrder
and SalesOrder.  Each of these modules can be set up as visible or
hidden from specific user (group) utilizing phpgroupware's native
grouping and admin functions.

Please, be warned that the current version, v.0.0.5, is a half-baked
edition of a pre-alpha version, so DON'T and I repeat, DON'T, apply this
version in any production environment.  For one thing, the rounding and
presentation of tax calculation results have not been sufficiently
stress tested.  However, I did test this version against the following
configuration without any major error:

RedHat 7.2, Apache 1.3.20, PostgreSQL 7.1.3, phpgroupware 0.9.12 (most
stable setup)
RedHat 7.2, Apache 1.3.20, PostgreSQL 7.1.3, phpgroupware 0.9.14RC1
(Some errors occurred when logging out of phpgroupware, but this would
not affect the working of CK-Ledger)
Mandrake 8.1, Apache 1.3.20, PostgreSQL 7.1.2, phpgroupware 0.9.14RC1
(Same errors as with RedHat 7.2)

To test drive CK-Ledger, download the tarball from sourceforge.net.
Expand the tarball into 8 folders (ledadmin, ledger, inventory, service,
ap, ar, po, so) within the phpgroupware directory.  Login as
phpgroupware administrator to enable individually the 8 modules.  [To
avoid confusion with phpgroupware's native inventory module, you may
like to name CK-Ledger's inventory module, as something like,
CK-Inventory.]  Invoke LedgerAdmin and create test data as indicated in
the index page.  I have also posted the detail installation procedure at
ck-...@li....  Please report any error you
found to ck-...@li..., I'll gladly rectify any
error as soon as possible.

I have not applied for CK-Ledger to be included under phpgroupware
because,

1.Currently, it only work with PostgreSQL.  Back when I started the
software porting, MySQL was still being criticised for =93not supporting
transactions=94
2.I don't intend to make CK-Ledger compatible with fee charging database
engines, ie Oracle, MSSQL, Sybase, etc, although I am OCP(Oracle8) and
MCDBA certified.
3.Currently, CK-Ledger definitely fails some of phpgroupware's coding
standards.
4.The protracted discussion over =93gif=94 is too much a drag for me.  I =
am
not a political puritan by any standard.
5.I have not even started to consider php3 compatibility.  CK-Ledger is
developed using php-4.0.6.

If you are wondering why I did the software porting in the first place,
here are the reasons,

1.I am fully unemployed at the moment, so may as well use the spare
time.
2.My backgrounds are LPIC-1, OCP(AD, Order Fulfillment, Procurement),
MCSE, MCDBA, MCSD, FHKSA, CISA, so when I saw Antonio Gallardo's email
back in Jan-2001 suggesting integration of SQL-Ledger and phpgroupware,
it was too tempting to pass over.

My immediate plan is to produce a simplified/traditional Chinese version
of CK-Ledger for use in the Greater China region (PRC, Hong Kong, Macau,
Taiwan) and, at the same time, work on an hr and payroll extension for
CK-Ledger and to better integrate CK-Ledger with phpgroupware.  I'll
probably create a Setup3 compliant version when phpgroupware 0.9.14 is
formally released.

I would like to appeal for assistance from other developers in the
Greater China region in helping to produce the Chinese version of
CK-Ledger, especially in terms of the format of reports required by the
local taxation authority when reporting VAT received and recovery
claimed.

At the same time, assistance from other phpgroupware developers is most
welcome.  Comparing to phpgroupware developers, I am definitely email
novice.  While CK-Ledger does implement auto emailing of invoice,
statement, order acknowledgement to customer, and purchase order to
vendor, such features are rather rudimentary.  The only audit trail of
having a email sent is a bcc back to the sender's email address.  It
would be nice to have copy of the email auto dropped into invoice_sent,
statement_sent, po_sent (etc) folders within the phpgroupware
environment, or dropped into a customer/vendor specific folder.  With
direct emailing of purchase order to vendor, the email could be a
primary piece of legal evidence on the T&Cs of goods/service provision.
Thus, whether the email has been sent/received and the timing of the
email posting/receipt could have  major legal implications.  It would be
nice to have options to sent receipt-requesting email, to auto-attach
electronic signature or to have the email sent via SSL, etc, etc, etc.
Again it would be nice to have the various documents auto-faxed instead
of being emailed.  I have actually tried html2ps+gs+efax and
successively faxed out but the resulting fax was simply too ugly.  All
these features are beyond me, so your assistance, in any form, is most
welcome and will be acknowledged.  The importance of such features is
evidenced by a SQL-Ledger user indicating his/her main use of SQL-Ledger
was to automate the sending of invoices.  Other phpgroupware module
developers integrating his/her module with CK-Ledger, eg time billing,
would also be most welcome.

Assistance from MySQL developers to ensure CK-Ledger works with MySQL
will also be highly appreciated.  For one thing, I am sure the Data
Restore routine will not work with MySQL, because I am getting lazy and
simply use a PostgreSQL command, =93psql=94, to facilitate the data resto=
re.

Currently, there is only one default template.  Both idsociety and
verdilak are empty.  Developers with an artistic touch are welcome to
fill in the missing templates or to provide other new templates.

While contributions will be graciously acknowledged in the index page of
each module, I don't like to go into political arguments as to how major
a contribution should be, before it is acknowledged, so you will have to
trust me on deciding who and what to acknowledge.

Come to think about it.  If some folks would consolidate phpgroupware's
file handling capability, add in the ability to manipulate
OpenOffice/KOffice docs, CAD (QCAD, SuperMap, AutoCAD, Microstation)
files, etc, to produce a Document Management System within phpgroupware,
then phpgroupware would probably become phpCorporateWare with phpgw
consultants everywhere.

This is my HK$0.02 contribution towards phpgroupware v.1.0.

Have a nice, happy and perhaps belated Chinese New Year (be you Chinese
or not),
Wu Chiu Kay aka CK Wu aka CK (CK is the preferred alias)
Hong Kong

Re: sql-ledger: drop down item list

[Ho-Sheng H. <qa...@ne...>]

On Thu, Feb 14, 2002 at 07:15:16PM -0000, James Tryand wrote:
> All in all, I suggest the easiest way is the 'crib sheet' with judicious use
> of the numeric keypad. :) It does save a helluvalot of time. ;)

The deployment I did for this place, the crib sheet was direct link
into the "Search Parts" functionality, with pre-set defaults. 

I also added a barcode field. Unfortauntely, it's not very useful
until we get the most commonly sold items matched up against it's UPC
code... if it has one. But we label things with the partnumber and a
barcode-representation of the partnumber on each incoming item, so it
would actually be useful if the motherboard powersupply on the retail
computer has enough juice to keep the scanner on...

-- 
-Qaexl-

Re: sql-ledger: drop down item list

[James T. <ja...@ci...>]

>> Is there an easy way, or how would I go about changing/creating the
Invoicepage to include a drop down list of >> all items? (instead of looking
up thenumber for an item and typing it in)Thanks

>> ill second that notion at moment its kinda unintuitive.

Hi I understand that it can be a pain, but I've seen big problems with a
setup like this, and the whole 'dropdown' contents can open a whole can of
worms.

As an undergraduate I did some summerwork doing dataentry. The company (a
major uk retailer) had some overgrown homebrew effort. Everybody who was
permanent staff loved it, and yes it had a dropdown of EVERY item that they
sold. Unsurprisingly *each* it took in excess of five minuites to load a new
record. There were other problems with the program (it taught me many things
about UI why many things are needed in programming!) but they are not
currently relevent.

A quick fix to all of this is to print out a crib sheet (if no printer :
another browser window to alt tab to)

One other thing is if you are to load a list of items, do you subdivide the
list and if so how do you choose categories : tree climbing can be just as
annoying to users when done on a repetitive basis if too deep. With the
final list: do you cache it somewhere and if you do how do you handle
updates to the list (cannot assume that it will be static), is the list
dropped serverside, or calculated clientside.

Oh and one little joyful one I came accross recently: I was doing a data
based program, where the servers were busy with the large number of slim
clients. I decided to use XML (DOM), my back-of-envelope sums led me to
believe that by dropping a treelike structure and populating it on an as
needed basis would be the most efficient, safest and plausible. Until I
descovered that XML DOM can sap up to 10x the data required with handling
the internal tree for the data.

All in all, I suggest the easiest way is the 'crib sheet' with judicious use
of the numeric keypad. :) It does save a helluvalot of time. ;)

Regards
James

Notes(Help)

[h <h...@gr...>]

Hi,

 I'm writing a notes module that will work for "credit note" and "debit 
note". Now I'm working on the addnote function(add), It works well, It 
generates the "Add Credit Note" and "Add Debit Note" pages, but It doesn't 
shows the section where you add the products. Please help me to find why 
it's happening?
 I think the problem is at the "update_form" function in the invocation to 
display_form. 

 I attached my module files. 

sALudos 

Alberto Ladron

Re: sql-ledger: drop down item list

[Jonas S. <jo...@jo...>]

On Wed, 13 Feb 2002, Luke Myers wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
>   <title></title>
> </head>
> <body>
> lee johnson wrote:<br>
> <blockquote type="cite" cite="mid:1013634958.4765.10.camel@imyourhandiman">
>   <pre wrap="">On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:<br></pre>

Please avoid HTML emails - or at least provide a text version as well.

The above is quite difficult to read in text-based mail programs.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: sql-ledger: drop down item list

[Luke M. <luk...@ya...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
lee johnson wrote:<br>
<blockquote type="cite" cite="mid:1013634958.4765.10.camel@imyourhandiman">
  <pre wrap="">On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:<br></pre>
  <blockquote type="cite">
    <pre wrap="">Is there an easy way, or how would I go about changing/creating the Invoice<br>page to include a drop down list of all items? (instead of looking up the<br>number for an item and typing it in)<br><br>Thanks<br></pre>
    </blockquote>
    <pre wrap=""><!----><br>ill second that notion at moment its kinda unintuitive..i'll help if<br>need be just point me<br><br>also any futher ideas about why i can't load sql-ledger in opera<br>5?..opera5 has background printing which should help me with my<br>background not printing in netscape .....in opera5 all I get is 'unknown<br>terminal'<br><br>thx<br>lee<br><br><br><br></pre>
    </blockquote>
For a quick fix, go to your Opera network preferences and change "Browser
Identification" to indentify as Opera as Mozilla or MSIE.<br>
    <br>
-- Luke Kale Myers<br>
    <br>
    </body>
    </html>

Re: sql-ledger: drop down item list

[lee j. <le...@im...>]

On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:
> Is there an easy way, or how would I go about changing/creating the Invoice
> page to include a drop down list of all items? (instead of looking up the
> number for an item and typing it in)
> 
> Thanks

ill second that notion at moment its kinda unintuitive..i'll help if
need be just point me

also any futher ideas about why i can't load sql-ledger in opera
5?..opera5 has background printing which should help me with my
background not printing in netscape .....in opera5 all I get is 'unknown
terminal'

thx
lee

sql-ledger: drop down item list

[Ro0tSiEgE <ro0...@ho...>]

Is there an easy way, or how would I go about changing/creating the Invoice
page to include a drop down list of all items? (instead of looking up the
number for an item and typing it in)

Thanks

Re: Loggin onto admin.pl

[Roderick A. A. <raa...@ti...>]

On Thu, 14 Feb 2002, Lee Yuen Wai wrote:

> I did the "chown nobody" part of the install but I think I may have missed 
> something simple.  Would appreciate any help.

Check to make sure but I believe it should be apache with Redhat Linux
7.1.


Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Loggin onto admin.pl

[Lee Y. W. <yw...@pa...>]

Hi,

I'm new to sql-ledger.  Did the install according to the instructions on 
redhat 7.1 but got the following message when tried to log on in my web 
browser.


"Forbidden You don't have permission to access /sql-ledger/admin.pl on this 
server.

Apache/1.3.19 Server at localhost.localdomain Port 80"

I did the "chown nobody" part of the install but I think I may have missed 
something simple.  Would appreciate any help.


Regards


Y W Lee 

Re: SQL Ledger on Red Hat anyone?

[Ed W. <ew...@rh...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

on redhat 7.2 it should be apache.apache
>
> Mmmm, I've run "chown nobody:nobody users templates" and I can see that a
> user and group called 1000 own most of these files, including admin.pl.

- -- 
Ed Wiget
Owner/Senior Network Security Consultant
RHP Studios
"Keeping Your Data Safe!"
http://www.rhpstudios.com
email: ew...@rh...
email2: sec...@rh...
Office: 606-564-0046
Toll Free: 866-G02-RHPS (866-402-7477)
Fax: 606-564-0076

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8anHb+EoLKxIs7PwRAnHMAJ9fJttoRkZJ1jTILR0fVxEqH7Zt+wCeMiDG
rb8+lSkw+tzqLlXOgTnGbWw=
=iqT9
-----END PGP SIGNATURE-----

Re: SQL Ledger on Red Hat anyone?

[James T. <ja...@ci...>]

What are the permissions of the appropriate files. I found that sql-ledger
did this to me.

Okay you are but a gnats whisker (do they have whiskers I thought they had
probosci) from getting it going.

Unfortuantely you are going to have to compromise your security for a while.

at the commandline from the sql-ledger directory
as the owner or su enter:
chmod 777 users/memebers

You may have to do this with the directory itself.
chmod 777 users

and hey presto your security is completely compromised.

Also who does apache run as.
You MAY find that it is as 'nobody' or 'apache' it is best that you match
the two up. or even set it to nobody.

after you have you db set up and users made, play with making it the
permissions more secure until you break it again.
BTW I do not reccomend doing any of this over an unsecured internet
connection.

Regards
James
----- Original Message -----
From: "Lee Kimber" <lee...@ki...>
To: "Joe MacDonald" <jam...@hw...>; "Lee Kimber"
<le...@ki...>
Cc: <sql...@li...>
Sent: Wednesday, February 13, 2002 2:00 AM
Subject: Re: SQL Ledger on Red Hat anyone?


> Wow! You folks are amazing! I'm on the Linux Router Project mailing list
> and even that doesn't produce so many responses so quickly.
>
> OK, I've got to fess up to one of those doh moments here. I forgot to put
> the forward slash before "usr" in one of the httpd.conf lines...
>
> However, now that I have done that, hitting
> http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by
> a line of black text saying:
>
> "Permission denied: users/members"
>
> Mmmm, I've run "chown nobody:nobody users templates" and I can see that a
> user and group called 1000 own most of these files, including admin.pl.
>
> If I've understood this correctly, this is the script I need to run to set
> up users and members so I'm a bit stuck here.
>
> Thanks for any ideas.
>
> Lee
>
> At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote:
> >I got it running with out any problems.
> >
> >As long as your permissions are correct and apache is setup to run perl
> >scripts then you should be okay.
> >
> >I found that putting an index.html file in your /sql-ledger directory
> >helps with resolving any path and permission problems. Then just have a
> >link in the index.html file that points to login.pl
> >
> >Good Luck
> >
> >Joe MacDonald
>
>