Agreed
On 02/08/2012 12:26, Jeff Roberts wrote:
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
--
Jeff Kaminsky
Sr. Accountant / Logistics
IX Systems
408-943-4100 ext 122
408-943-4101 fax
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
