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
