sql-ledger-users — SQL-Ledger users

Re: pretty cool app

[David A. B. <da...@pa...>]

On Tue, 1 Jan 2002 13:56:43 -0700 (MST)
Dieter Simader <dsi...@sq...> spewed into the bitstream:

> David!
> 
> Before making any false statements read the documentation, see the FAQ
for
> a solution about audit control.

Apologies.  But it does come "out of the box" with delete buttons on
accounts that shouldn't have them (at least according to my accountant). 
While I will look at the FAQ, I did read the documentation.  I probably
missed something (won't be the first time).

Can the delete buttons be removed?  If this is in the FAQ, sorry.  

Suggestion:  a GAAP checkbox that changes the "Delete" buttons to "Reverse
Entry" buttons and creates the reverse automagically.

I'll shut up now.


> 
> 
> 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 Tue, 1 Jan 2002, David A. Bandel wrote:
> 
> > On Tue, 1 Jan 2002 04:31:16 -0800 (PST)
> > Caffeinate The World <moc...@ya...> spewed into the
bitstream:
> > 
> > Apart from adding "me too" (Tm AOLusers), I'd like to add that the
only
> > "problem" I see with using SQL-Ledger, at least for US businesses, is
that
> > you can delete transactions.  I don't know about Canada, but at least
in
> > the US, GAAP (Generally Accepted Accounting Practice) is (or at least
was)
> > that you don't delete transactions, you create reversing entries.  I
will
> > admit, it's been a long time since I looked at GAAP, so apart from
that I
> > have no idea how far from accepted practice SQL-Ledger strays. 
> > Fortunately, my accountant is just happy I'm using something other
than a
> > shoe box with receipts thrown in it.
> > 
> > Ciao,
> > 
> > David A. Bandel
> > 
> 

David A. Bandel
-- 
Focus on the dream, not the competition.
		-- Nemesis Racing Team motto
Internet (H323) phone: 206.28.187.30

RE: SQL-Ledger-users digest, Vol 1 #113 - 15 msgs

[csaunders <csa...@da...>]

You could write a trigger  (i assume postgres supports triggers?)

usually modern sql engines support theoretical temp tables (in ms sql they 
are #inserted and #deleted i think) that allow you to check data as it is 
added or deleted. you could check the id against existing invoices (same 
for dup customer info as well) and ignore if null or blank and roll back 
with message if duplicate found. don't know how the front end will cope 
with a roll back.

in very rough psuedo code:
*********************************
create trigger blah

@invoice_id integer
@invoice_id = select invoice_id from #inserted

if @invoice_id in (select invoice_id from invoice_tbl) ----hope there is a 
good index on here!
then comit
else roll back

end trigger
*********************************

maybee this could be generised with some front end form for the most 
important tables, invoice, customer, supplier (not sure of what the SL erd 
is though...)

cs
===============================
Message: 1
Date: Fri, 28 Dec 2001 13:40:33 -0700 (MST)
From: Dieter Simader <dsi...@sq...>
To: Roger Samour <rs...@ma...>
cc: sql-ledger users mailing list <sql...@li...>
Subject: Re: Duplicity?

Invoices are distinguished by an internal ID, not the invoice number or
a combination of invoice number and name.

So, yes, you can enter the same information again, however, the invoices
are different.


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 Fri, 28 Dec 2001, Roger Samour wrote:

> Hi, I was entering a Vendor invoice, and just to test it I entered
> another invoice with the same Invoice number and under the same vendor
> and it allowed me to do that. Am I doing something wrong? or does it
> allow duplicate invoice numbers under the same vendor?
>
> Roger J. Samour
>
>
>



--__--__--

Message: 2
From: alta <al...@al...>
Reply-To: al...@al...
Organization: Alta Research
To: <sql...@li...>
Subject: Re: Duplicity?
Date: Fri, 28 Dec 2001 13:08:55 -0800


Roger...

If you are concerned that the possibility of creating two invoices
with the same number is an integrity issue (or a potential for
confusion), consider trying a UNIQUE constraint on the invoice number
field.

However, I tried something similar to prevent duplicate customer
records, and got an error.  If I understand Dieter's explanation,
this is because the record is created with a null in the id field.
So, my sggestion may not work for other tables, either.

... Reed

upgrading

[adrian <ad...@sn...>]

I am about to upgrade to version 1.8.1 from 1.6.11. 

I will do all the backups etc but I am concerned as last time I upgraded
from 1.4. to 1.6 some of the data fields got mixed up and I lost a lot
of information. Some of it was was totally my own fault.

I have been using sql-ledger for over 12 months with live data and it
has been excellent.

Has anyone experienced and serious problems in the upgrade process ? 
Any tips, do and don't ??


Adrian
-- 
Adrian Blake
Snowy Technology Pty Ltd
37 Commissioner St.
P.O. Box 57
Cooma, NSW 2630
Ph 2-64-524338 mobile 0407 232 978

Re: pretty cool app

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

Happy new year all!

Yes, it is documented in the faq, but I would rather that it was
an integrated feature of the system. It is an accountant-level
requirement, and what is documented in the FAQ is a systems administrators
solution. An accountant cannot call on a system administrator, that
has the appropiate systems accessabilities, and knowledge of sql database
handling, every time the locking needs to be done. The locking
must in principle be done for every transaction! But there is also
a need for functionality to only do it when requested, eg
every quarter. As far as I understand it, the requirement is
considered "good accountant practice" in most countries. At
least this was what was reported earlier on this list by a
number of people.

Kind regards
Keld

On Tue, Jan 01, 2002 at 01:56:43PM -0700, Dieter Simader wrote:
> David!
> 
> Before making any false statements read the documentation, see the FAQ for
> a solution about audit control.
> 
> 
> 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 Tue, 1 Jan 2002, David A. Bandel wrote:
> 
> > On Tue, 1 Jan 2002 04:31:16 -0800 (PST)
> > Caffeinate The World <moc...@ya...> spewed into the bitstream:
> > 
> > Apart from adding "me too" (Tm AOLusers), I'd like to add that the only
> > "problem" I see with using SQL-Ledger, at least for US businesses, is that
> > you can delete transactions.  I don't know about Canada, but at least in
> > the US, GAAP (Generally Accepted Accounting Practice) is (or at least was)
> > that you don't delete transactions, you create reversing entries.  I will
> > admit, it's been a long time since I looked at GAAP, so apart from that I
> > have no idea how far from accepted practice SQL-Ledger strays. 
> > Fortunately, my accountant is just happy I'm using something other than a
> > shoe box with receipts thrown in it.
> > 
> > Ciao,
> > 
> > David A. Bandel
> > 
> 
> 

Reversing entries as opposed to deleting entries (US G.A.A.P.) WAS: pretty cool app,

[Marvin D. <pe...@be...>]

Hi David,

If I am not mistaken, you can setup sql-ledger to force users to reverse 
entries (As opposed to the ability to delete entries) by issuing a REVOKE 
DELETE rights statement for users: 


GRANT SELECT, INSERT, UPDATE, DELETE ON <all the SQL-Ledger tables> TO 
username 

REVOKE DELETE ON acc_trans FROM username 


Take it easy.

PS: I didn't know you were on this list....


On Tuesday 01 January 2002 10:29, you wrote:
> Apart from adding "me too" (Tm AOLusers), I'd like to add that the only
> "problem" I see with using SQL-Ledger, at least for US businesses, is that
> you can delete transactions.  I don't know about Canada, but at least in
> the US, GAAP (Generally Accepted Accounting Practice) is (or at least was)
> that you don't delete transactions, you create reversing entries.  
>
> Ciao,
>
> David A. Bandel

GST-Purchases & GST-Sales Verification

[Caffeinate T. W. <moc...@ya...>]

Back in November there was a discussion about having two separate GST
accounts to track tax already paid and tax to be collected:

http://www.geocrawler.com/archives/3/7966/2001/11/0/7125075/
---cut---
> > Ned Lukies wrote:
> > >
> > > Is it possible to seperate the single GST account into to so that
I have
> > > an asset GST account for GST paid on purchases and a liability
GST account
> > > for GST collected on sales? If so, how?
> 
> > in Italy we use only the two accounts solution. We have to do this
way
> > because we have to write two different books, one for sales and the
> > other
> > for purchases. Just modify your accounts list and put the
> > flag AP_tax in the 'GST for purchases' account and the AR_tax in
the
> > 'GST for sales' account.
> >
> > What we do is to put this together once pro month in a third
account
> > called something like 'GST summary'. Then I go to pay just the
> > sum of this third account.
---/cut---

I'm trying to document this into an FAQ, but I'm not sure if I am
understanding the above correctly. The original post asked to make a
GST account for purchases (GST-Purchases) to track taxes that has been
paid (asset). In the reply to that post, Luca suggested to flag AP_tax.


That is where I'm lost. Isn't AP_tax a liability that we have to pay
later? Since we already paid for that tax, shouldn't that be AR_tax
flagged for GST-Purchases, and AP_tax flagged for GST-Sales?


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Re: pretty cool app

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

David!

Before making any false statements read the documentation, see the FAQ for
a solution about audit control.


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 Tue, 1 Jan 2002, David A. Bandel wrote:

> On Tue, 1 Jan 2002 04:31:16 -0800 (PST)
> Caffeinate The World <moc...@ya...> spewed into the bitstream:
> 
> Apart from adding "me too" (Tm AOLusers), I'd like to add that the only
> "problem" I see with using SQL-Ledger, at least for US businesses, is that
> you can delete transactions.  I don't know about Canada, but at least in
> the US, GAAP (Generally Accepted Accounting Practice) is (or at least was)
> that you don't delete transactions, you create reversing entries.  I will
> admit, it's been a long time since I looked at GAAP, so apart from that I
> have no idea how far from accepted practice SQL-Ledger strays. 
> Fortunately, my accountant is just happy I'm using something other than a
> shoe box with receipts thrown in it.
> 
> Ciao,
> 
> David A. Bandel
> 

Re: pretty cool app

[David A. B. <da...@pa...>]

On Tue, 1 Jan 2002 04:31:16 -0800 (PST)
Caffeinate The World <moc...@ya...> spewed into the bitstream:

Apart from adding "me too" (Tm AOLusers), I'd like to add that the only
"problem" I see with using SQL-Ledger, at least for US businesses, is that
you can delete transactions.  I don't know about Canada, but at least in
the US, GAAP (Generally Accepted Accounting Practice) is (or at least was)
that you don't delete transactions, you create reversing entries.  I will
admit, it's been a long time since I looked at GAAP, so apart from that I
have no idea how far from accepted practice SQL-Ledger strays. 
Fortunately, my accountant is just happy I'm using something other than a
shoe box with receipts thrown in it.

Ciao,

David A. Bandel
-- 
Focus on the dream, not the competition.
		-- Nemesis Racing Team motto
Internet (H323) phone: 206.28.187.30

pretty cool app

[Caffeinate T. W. <moc...@ya...>]

just want to let you guys know that i've spent the last two days really
using Sql-Ledger. The more I use it, the more I like it. I think it's a
wonderful application, and really easy to use, once you get the hang of
how things work. Very well thought out in the coding structure too. 

as I'm slowly learning Sql-Ledger, I'm also writing documents for it at
the same time. I don't see much of any documents for it. I think it
would have helped me much to learn it with some sort of tutorial, even
an intro to accounting. I'll try to write it as I do my accounting with
Sql-ledger. I've written some stuff, but not much. If you want to see
it:

  http://www.minnesota.com/sql-ledger/glossary.html

I will most likely slowly port it to PHP, as most of what I have done
is in PHP and would be nice to integrate with the rest of my other
stuff. Things like shopping cart integration, customer viewing their
bills (integrate with my login system in PHP), bill their CC each month
automatically, i.e. recurring invoice (cron job would do in perl too).

Just want to thank all those who helped develop Sql-ledger to what it
is today. Thanks! Happy New Year.

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Re: email, print invoice bug

[Caffeinate T. W. <moc...@ya...>]

--- Caffeinate The World <moc...@ya...> wrote:
> the field item NUMBER doesn't have the item number listed in both
> email
> invoice and print invoice option. as of version 1.8.1.

i figured out why. my item was a service and i guess services don't get
their "number" printed in the email invoice or the print option, but is
listed in the actual invoice edit form.

i wanted my service number to be listed, so i had to comment out (in
IS.pm:

#      if ($form->{"inventory_accno_$i"} || $form->{"assembly_$i"}) {
        push(@{ $form->{number} }, qq|$form->{"partnumber_$i"}|);
        push(@{ $form->{bin} }, qq|$form->{"bin_$i"}|);
#      } else {
#       push(@{ $form->{number} }, " ");
#      }

would be nice to have an extra field "service_num_on" in table
"defaults" so we can choose if we want it on or off. then test it in
the if above for the config setting. also change AM.pm module to
reflect the above.

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

expensing employees work related expenses

[Caffeinate T. W. <moc...@ya...>]

what's the correct way of entering employee's work related expenses?
would i have to create a vendor account for each one of those employee,
track their expenses into my expense accounts, owe them in accounts
payable?

that would be really cumbersome, if you had thousands of employees who
need to expense work related expenses.

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

email, print invoice bug

[Caffeinate T. W. <moc...@ya...>]

the field item NUMBER doesn't have the item number listed in both email
invoice and print invoice option. as of version 1.8.1.

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

RE: relation of expense to a service

[Caffeinate T. W. <moc...@ya...>]

--- "Leo R. Masciuch" <Le...@Ne...> wrote:
> To increase an expense is to increase an asset.  This second entry of
> the double entry would likely be Accounts Receivable in this case
> since
> you would be invoicing your customer.

from the default setup, it has for the Expense: 

  5010-Purchases
  5100-Freight
  5781-Internet

I chose 5781-Internet as an expense for my new service. Which didn't
really make sense to be, but it fits more than the other two options.

When a customer make a purchase of a service, like this particlar ad
space, Account Receivable gets Debited, and Sales/Ad Banner gets
credited.

But what about the expense (5781-Internet) chosen above? I don't see
any relation to that expense account in any chart after a customer get
invoiced for the ad banner.

> -----Original Message-----
> From: Caffeinate The World [mailto:moc...@ya...]
> Sent: December 31, 2001 15:51
> To: sql...@li...
> Subject: relation of expense to a service
> 
> 
> We sell ad space on our web site. I think it would be considered a
> service in inventor and not a part. So I needed to add a service:
> 
> 1. Inventory / Add Service
> 2. Number: BRS120120 
>    ...
> Then I get to Links Accounts:
> 
> Income: 4050-Sales/Banner Ads
> Expense: *** THIS IS WHERE I DON'T GET IT ***
> 
> How does expense relate to the service being sold?
> 
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> 


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

relation of expense to a service

[Caffeinate T. W. <moc...@ya...>]

We sell ad space on our web site. I think it would be considered a
service in inventor and not a part. So I needed to add a service:

1. Inventory / Add Service
2. Number: BRS120120 
   ...
Then I get to Links Accounts:

Income: 4050-Sales/Banner Ads
Expense: *** THIS IS WHERE I DON'T GET IT ***

How does expense relate to the service being sold?

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

COGS

[Caffeinate T. W. <moc...@ya...>]

could someone help me understand how Cost Of Goods Sold (COGS) is used
in a transaction?

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Re: is this entry correct?

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

This isn't too far off.  Please see my comments below.

Caffeinate The World wrote:

> I just set up SQL-Ledger-1.8.0. Trying to learn how to use it. I wanted
> to add this transaction, but I'm not sure if I'm doing it correctly.
>
> We needed a SSL Certificate (which will be renewed yearly). My partner
> went online to Thawte and paid $125 for one with her visa. They gave
> her an invoice after charging her VISA. My company will have to
> reimburst my partner for the $125 later.
>
> In SQL-Ledger, I did the following:
>
> 1. added Thawte as a vendor.
> 2. AP/Add Transaction:
>    Record In: 2100-Accounts Payable
>    Vendor: Thawte-10075

>    Invoice Number: SSL2001
>    Order Number: *** LEFT BLANK CAUSE NO PO ***
>    ...
>    Amount Total: 125   => 5795-Registration

The vendor actually should be your partner.  You don't owe Thawte anything
currently.

This creates the following transaction:
Debit Registration expense --    125.00
Credit Accts. Payable (to your partner)--  125.00

>    ...Amount: 125 ...Account: 2680-Loan From Shareholder
>    ...Source: PartnerName

Leave this blank until you pay your partner.  Pull up the invoice later when
you pay the partner and record the $125.00 payment from cash.  That creates
the following:
Debit Accts. Payable (to your partner)--    125.00
Credit Cash --                                                        125.00

Now everything is recorded and the invoice is closed or settled.

>
> My question for that transaction is, were those the right steps? Should
> I have created a PO first via Order Entry/Add Purchase Order? If I
> created a PO, it would have asked me to add in the
> Inventory/Parts/Services, which isn't an inventory, but an expense. We
> aren't going to resell the SSL Certificate, it's for the webserver to
> use.

You wouldn't want to use a PO.

>
>
> My next questions is when the company pays my partner back, for her
> $125, how should that be entered? I would think via the General
> Ledger/Add Transaction. Credit 125 1061-Checking, Debit 125 2680-Loans
> from Shareholders. It wouldn't make sense to do AP/Add Transaction
> cause she's not really a vendor.

See above.  Go back and apply the payment to close out the invoice when you
pay your partner.  You actually could have done the whole transaction thru
G/L Add trans. also without creating an invoice.  You could have just made
the two journal entries above at the appropriate times.

>
>
> Is my thinking right? BTW, how is "Source" used in the GL/Add Transaction?

Not sure here if that's for comments, or a user name or something.  You don't
need to use it.

>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com

is this entry correct?

[Caffeinate T. W. <moc...@ya...>]

I just set up SQL-Ledger-1.8.0. Trying to learn how to use it. I wanted
to add this transaction, but I'm not sure if I'm doing it correctly.

We needed a SSL Certificate (which will be renewed yearly). My partner
went online to Thawte and paid $125 for one with her visa. They gave
her an invoice after charging her VISA. My company will have to
reimburst my partner for the $125 later.

In SQL-Ledger, I did the following:

1. added Thawte as a vendor.
2. AP/Add Transaction:
   Record In: 2100-Accounts Payable
   Vendor: Thawte-10075
   Invoice Number: SSL2001
   Order Number: *** LEFT BLANK CAUSE NO PO ***
   ...
   Amount Total: 125   => 5795-Registration

   ...Amount: 125 ...Account: 2680-Loan From Shareholder 
   ...Source: PartnerName

My question for that transaction is, were those the right steps? Should
I have created a PO first via Order Entry/Add Purchase Order? If I
created a PO, it would have asked me to add in the
Inventory/Parts/Services, which isn't an inventory, but an expense. We
aren't going to resell the SSL Certificate, it's for the webserver to
use.

My next questions is when the company pays my partner back, for her
$125, how should that be entered? I would think via the General
Ledger/Add Transaction. Credit 125 1061-Checking, Debit 125 2680-Loans
from Shareholders. It wouldn't make sense to do AP/Add Transaction
cause she's not really a vendor. 

Is my thinking right? BTW, how is "Source" used in the GL/Add Transaction?

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Number Formats and Fractional Cents

[David R. <dr...@su...>]

Hello everyone,

Two Questions Today:
1. I have a question today about how to change number formats for purchase 
orders, vendor invoices, and stock valuations....

I have many items that are purchased in fractions of cents, that is

6000 FT @ $ 0.06125

sql-ledger rounds the numbers off, which of course produces a significant 
error.

How can I change the number format such that fractional cents are allowed?


2. Does anyone have a simple solution for unit conversions between purchased 
units and stocked units???

I have an application where we buy an epoxy in 1 EA cartridge, but consume it 
on assemblies in a smaller unit (i.e Grams) - that is 1 cartridge can build 
500 units but if I put 1 EA on the assembly BOM, I'll be up to my ears in the 
stuff!!

Of course this problem might go away with the solution to the first problem 
if I can put a fractional item into an assembly, i.e.  (0.001 EA)


Thanks
-Dave Ratte
dr...@su...

HELP! Permissions Denied

[Terry C. <pa...@lv...>]

Hi all!

I finally got everthing loaded and was able to pull up sql-ledger in Netscape 
browser. Finished admin process and was able to login as user but when I try 
to run setup items or reports such as list the chart of accounts I get the 
following errors:


Error!

SELECT accno,
SUM(acc_trans.amount) AS amount
FROM chart, acc_trans
WHERE chart.id = acc_trans.chart_id
GROUP BY accno
ERROR: chart: Permission denied. 

Error!

SELECT * FROM defaults
ERROR: defaults: Permission denied. csu

I have tried to change as many permissions as I could but to luck. I followed 
instructions on setting up user for postgres permissions. Still no luck.

I am now purched on the top of my monitor and am prepared to jump (feet 
first) Please offer sany uggestions or let me know what further information 
you may need. I have also scoured emails with  no sucess.

Best regards

Terry Canfield
Pace Chem Industries, Inc
Las Vegas, NV

Error Creating New Customer Invoice...

[David R. <dr...@su...>]

Hello all,

V1.8 so far has lived up to all the expectations and more! Many thanks to 
Dieter and all who labor in the testing process.

I have an error that comes up when I try to enter a customer invoice (listed 
in full below). It happens only when billing a PART or ASSEMBLY, *NOT* when 
billing a SERVICE.

I corrected the problem with the following change to IS.pm
LINE 500: AND i.qty < 0			(change to specify 'i.')
LINE 501: AND (i.qty + i.allocated) < 0	(change to specify 'i.')



========================================================
Error!

SELECT i.id, i.qty, i.allocated, i.sellprice,
(SELECT c.accno FROM chart c
WHERE p.inventory_accno_id = c.id)
AS inventory_accno,
(SELECT c.accno FROM chart c
WHERE p.income_accno_id = c.id)
AS income_accno,
(SELECT c.accno FROM chart c
WHERE p.expense_accno_id = c.id)
AS expense_accno
FROM invoice i, parts p
WHERE i.parts_id = p.id
AND i.parts_id = 12356
AND qty < 0
AND (qty + allocated) < 0
ORDER BY id
ERROR: Column 'allocated' is ambiguous 
=============================================
-Dave Ratte
Superior Circuit Technologies, Inc.
321-254-4201 x 204
dr...@su...

Hola again!

[Roger S. <rs...@ma...>]

Jess:

  Ok, I see where you were coming from. I still don't see how
you think Tiff influenced my opinion about courtship. Because I
think we talked probably once about it and it was a positive
thing, and we never even mentioned it after that. But
regardless, I understand your point of view in regards to Tiff.
If you have the time, could you elaborate on: "I have other
things to say about everything that happened. The way I view
things are changing. And I think its good that were just
friends." Anyhoo, tell me how you're doing? How you been? I've
been thinking about all kinds of stuff, school, church, the
future, the present, the past... you get my point =)... I've
also been attending a church here every Sunday morning which has
been a major help! But listen I want you to know, above anything
that I don't have any resentment towards you and I hope you
don't have any towards me. I hope that if something that I've
done has made you angry or sad, please let me know so I can do
something about it. I'll let you go for now, I hope you have a
good weekend, say hi to Matt, Wes, KenDon and the rest of the
gang...

your friend,

Ro

Re: Duplicate customer records, anyone?

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

On Fri, 28 Dec 2001, alta wrote:

> This is because the next id comes from a PostgreSQL proprietary 
> sequence table called "id".

FYI.  Sequences are SQL standards.  They are not proprietary to
PostgreSQL.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

current_date single quote bug

[Caffeinate T. W. <moc...@ya...>]

i have pgsql 7.2b4 installed. when i setup sql-ledger 1.8.0p1 i had to
change all occurrances of 

  'current_date' 

to 

  current_date

in the ./sql directory, files:

  Pg-tables.sql
  upgrade-*

note the missing single quotes. 

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Vendor invoice vs. merchandise received

[Philip R. <p....@li...>]

Hello list,
is stumbled across another question. This one is not all that important but 
nonetheless I'm curious about it.
What is the difference between "Add vendor invoice" and "Merchandise received"?
They both seem to use the same form and affect the same accounts.
And they both affect the inventory. My guess was that Merchandise received 
affects the inventory and Vendor invoice does not, but apparently I'm wrong.
Is this behavior expected, I think I remember in an earlier version it was 
different.

Anyone can give me a hint?

Thanks.

Bye,
Philip

--
LINET Services
Linux im Intra- und InterNet

Rebenring 33                                    Tel.:   0531-280 191 71
38106 Braunschweig                              Fax:    0531-280 191 72

http://www.linet-services.de
mailto:in...@li...

Re: Duplicate customer records, anyone?

[alta <al...@al...>]

Mystery solved.

Here's what happened:

I loaded a bunch of custormers from another system.
When I created a new customer, sql-ledger wrote over one of the 
loaded customers and created a new record.  The result was a 
blown-away customer and a new customer with duplicate records.

This is because the next id comes from a PostgreSQL proprietary 
sequence table called "id".  It does not really know what is in the 
customer table, it just supplies the next number in sequence.  
Because there are no checks in sql-ledger for an existing number or 
uniqueness, it happened.

Anyway, problem solved, and I'm a happy camper.

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...