On Mon, 14 Feb 2011, Rich Shepard wrote:
What steps do I need to do to roll back the invoice and sales order?
I _think_ I have this correct.
First, I deleted the invoice from AR.
Second, I need to "unclose" the specific time cards. If I'm correct, I
need to select each id from 'jcitems' and change the allocated column to
NULL by
update jcitems set allocated is null where id = 87;
and repeat for each id. Yes? Is the select syntax correct, or should it be
... allocated == null ...?
Is there any other cleaning I need to do on this in other tables?
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
