sql-ledger-users

Duplicate customer records, anyone?

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

Is anyone else seeing duplicate customer records whenever they create 
a new customer?

I get 2 identical records per customer with Version 1.8 and 
PostgreSQL 7.2.  If I put a put a UNIQUE constraint on the id field, 
I get a duplicate record error, which prevents the customer from 
being entered.

If you have not tested this, I would appreciate someone else running 
a test.  Anyone?

Thanks ... Reed

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

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...

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

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...