davidc wrote:
> Thanks Roy
> from you info, i been able to get it via phpPgadmin, it is in the
> shipto table.
> but this is not satisfactory to past to the office to do as a daily
> procedure, just can not give root access to every one to use.
> mush be from inside Ledger sql for that.
> This will be my wish list for **** Dieter **** to add for the future
>
> cheers
> Allan
>
> R Pennington wrote:
>
>
>> On Thursday 30 November 2006 9:06 pm, davidc wrote:
>>
>>
>>
>>> HI
>>> I am running version 2.6.5, are there any ways to list the shipping
>>> address of customers ??
>>>
>>> thanks for any help in advance
>>> Allan
>>>
>>>
>>>
>> Hello Allan.
>>
>> The only way is to query the database directly via psql.
>>
>> If I remember correctly it's a query against the "customer", "shipto" and one other ? table
>> Unfortunately I don't have a system in from of me to tell you specifically which tables to query.
>>
>> Maybe someone else has a system close by and be more specific.
>>
>> Cheers,
>> Roy
This has been discussed many times before. It would be wonderful if
things were changed so that you could search by shipto from both the
invoice and the PO screens. Heck for that matter why not add searching
by Employee too - I think someone, earlier this week, was looking for
commission. If you could search and subtotal by employee it would sure
help in figuring out commissions!
Dunc
|
