sql-ledger-users

Customers & Vendors

[Peter D. <mer...@ma...>]

Hi
Personally I have no problem with customers and vendors have been=20
separated. I'm in distribution business
and chance to have person or firm to be customer an vendor in the same=20=

time is very small.
But I've got different problem.
I would like to have multiple entry for delivery address. For example if=
=20
I got customer who owns a chain of shops
I have to invoice the head office and make individual packing lists for =

every shop to make multiple delivery
Peter D.

RE: Customers & Vendors

[<ma...@ds...>]

Hi Peter,

Why not create all retail branches in client table, with billing info to
head office and shipping info to retail branch?  I did not check if SL
offers 2 addresses for the client, but it would be an easy fix to simply add
a 2nd address in client table.

Here is an example:
Tim Hortons - Head Office |
1 Central Avenue          | Billing Address
Suite 5000
New York, NY
123456

Tim Hortons - Plattsburg
2 Main Road			  | Shipping Address
Plattsburg, Ney York
44455555

...

Good luck!
Sergio

RE: Customers & Vendors

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

Hi Peter!

For multiple shipping addresses you'd have to add another table (shipto)
and link it to the 'ar' table.


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, 4 Jan 2002, ma...@ds... wrote:

> Hi Peter,
> 
> Why not create all retail branches in client table, with billing info to
> head office and shipping info to retail branch?  I did not check if SL
> offers 2 addresses for the client, but it would be an easy fix to simply add
> a 2nd address in client table.
> 
> Here is an example:
> Tim Hortons - Head Office |
> 1 Central Avenue          | Billing Address
> Suite 5000
> New York, NY
> 123456
> 
> Tim Hortons - Plattsburg
> 2 Main Road			  | Shipping Address
> Plattsburg, Ney York
> 44455555
> 
> ...
> 
> Good luck!
> Sergio
> 
> 
>