Thread: I am starting off...

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Which version should I use?
1.6.x or 1.8?

Thanx

Roger

Hello everyone,
I'm trying to build a bridge between the groupware solution we are using 
and sql-ledger.
Both are using postgresql, so I was thinking I use a single database for 
both programs and write a trigger that updates the customer and vendor 
relation for sql-ledger every time I add or edit a contact in my groupware. 
The groupware has fields which make it possible to distinguish between 
vendor and customer.
So far everything seems pretty straightforward. My question is: When I add 
a customer or vendor through the webinterface, are only the customer or 
vendor relation affected or is there more to do?

Any help would be highly appreciated.

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

On Fri, 28 Dec 2001 17:53:39 +0100  Philip Reetz wrote:
 +------------------
 | 
 | 
 | Hello everyone,
 | I'm trying to build a bridge between the groupware solution we are using 
 | and sql-ledger.
 | Both are using postgresql, so I was thinking I use a single database for 
 | both programs and write a trigger that updates the customer and vendor 
 | relation for sql-ledger every time I add or edit a contact in my groupware. 
 | The groupware has fields which make it possible to distinguish between 
 | vendor and customer.
 | So far everything seems pretty straightforward. My question is: When I add 
 | a customer or vendor through the webinterface, are only the customer or 
 | vendor relation affected or is there more to do?
 | 
 | Any help would be highly appreciated.
 | 
 | 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...
 | 
 | 
 +------------------

--
    Chris Fedde
    303 773 9134

Philip ...

I have loaded the customer table externally, and it seems to be the 
only table needed for customer info.  Note that for each record, you 
have to provide an integer id that does not conflict with another 
identical number in another record.  If you do not take care, you may 
end up with double records with the same id, as the id field is not 
UNIQUE in the customer table.  Otherwise, the process is 
straight-forward.

... Reed

On Friday 28 December 2001 08:53, you wrote:
> Hello everyone,
> I'm trying to build a bridge between the groupware solution we are
> using and sql-ledger.
> Both are using postgresql, so I was thinking I use a single
> database for both programs and write a trigger that updates the
> customer and vendor relation for sql-ledger every time I add or
> edit a contact in my groupware. The groupware has fields which make
> it possible to distinguish between vendor and customer.
> So far everything seems pretty straightforward. My question is:
> When I add a customer or vendor through the webinterface, are only
> the customer or vendor relation affected or is there more to do?
>
> Any help would be highly appreciated.
>
> Bye,
> Philip

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

The customertax and vendortax tables are used to lookup tax links.

customer -> customertax
vendor -> vendortax

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, Philip Reetz wrote:

> 
> 
> Hello everyone,
> I'm trying to build a bridge between the groupware solution we are using 
> and sql-ledger.
> Both are using postgresql, so I was thinking I use a single database for 
> both programs and write a trigger that updates the customer and vendor 
> relation for sql-ledger every time I add or edit a contact in my groupware. 
> The groupware has fields which make it possible to distinguish between 
> vendor and customer.
> So far everything seems pretty straightforward. My question is: When I add 
> a customer or vendor through the webinterface, are only the customer or 
> vendor relation affected or is there more to do?
> 
> Any help would be highly appreciated.
> 
> 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...
> 
> 
> 

Thread: I am starting off...

sql-ledger-users