I am surprised that after all these years that SQL in any form doesn't
have a way to hide unused ship to's.
From what I can see when you ask for shipto addresses it queries the
shipto table for all unique addresses that are associated with that
customer from the entire history. The trouble may be in determining what
the criteria for "unused" is. If you do it by date you could end up
re-typing addresses just because you haven't shipped to that location in
a year, etc. You could then add a date selection process somewhere to
determine how far back to look for addresses eg: 6 months, 1 year,
all... but that adds extra clicks to the process that may not be
desirable for others.
I think the easiest way may be to have the shipto addresses shown in a
table form instead of a long sheet as they are now, that way you could
select the headers to sort by city, postal etc and it would make it
easier to find the one you want and ignore the rest.
Jeff Roberts
J.R. Electronics
604-241-1362
On 02/08/2012 11:31 AM, Jeff Kaminsky wrote:
I am in a manufacturing business, bill to and ship to are equally
vital information. I am surprised that after all these years that SQL
in any form doesn't have a way to hide unused ship to's.
On 02/08/2012 11:06, Jeff Roberts wrote:
Hi Jeff
Sure I am, just not with the original shipto address. All of the
financial data is still in tact. It's the billing address that's
important and I'm not touching that.
Jeff Roberts
J.R. Electronics
604-241-1362
On 02/08/2012 11:00 AM, Jeff Kaminsky wrote:
Hey Jeff,
I understand what you did, but as an accountant that makes me spasm
painfully as I see GAAP being violated horribly. If you ever lost
those paper archives you'd be unable to reproduce invoices to your
customers. Not an option for me :-(
Jeff
"the other jeff"
On 02/08/2012 10:48, Jeff Roberts wrote:
change trans_id to shipto in first sentence of third paragraph.
Hi Craig, Jeff
I once entered the same shipto address twice on successive invoices
with only a capitalization of one letter being the difference, the
result was it showed up as two ship to addresses in the list
thereafter and drove me nuts.
AFAIK there is no way to delete them from within SQL but I can tell
you that they are stored in the table "shipto" with a key called
"trans_id" that links them to their respective invoices.
I found that you can edit or delete lines from shipto and then the
list will be wiped out but the secondary result will be that if you
reprint past invoices the original "shipto" address will not be
reprinted. Not a problem if you have paper archives like I do.
The ability to have control over my data is the primary reason I
went with an open source product like SQL. I use pgAdmin for tasks
like this, it's easy to do, just don't screw with any of the tables
that involve the actual financial data and your books will stay in
tact.
Jeff Roberts
J.R. Electronics
604-241-1362
On 02/08/2012 08:51 AM, Craig Isdahl wrote:
Hello Everyone!
I'm probably missing something here but, how can I delete a
shipping address
for a customer?
When I go to the customer screen and click "shipping address" I
see a form
to add a new address and I see the existing address (the one I
want to
delete) listed below with a check box. How can I delete that
address.
Ver 2.8.36
Thanks!
-- Craig
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
