nelsonm - 9:53 pm on Oct 24, 2012 (gmt 0)
The client wants to be able to make corrections to the snapshot/closed work order payment records in cases where...
1. (Edit) they make a wrong payment entry and it's not discovered until the work order is closed and moved to the snapshot tables.
2. (Edit or Delete) a payment check bounces after the work order is closed and moved to the snapshot tables. They don't use a check funds checking service.
3. (Add) they close and moved to the snapshot table a work order with a partial or no payment, then later the customer makes a payment or pays the balance.
This is the way the client wants their system to work.
The current system does not allow records associated with a closed work order to be moved from the snapshot tables back to the live tables to be reopened.