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
--
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
