Report and repair Orphaned Transactions

Top  Previous  Next

 

This pair of functions (one for Reservations and one for Customers), accessed through Maintenance / Database Maintenance, will report and repair situations where a transaction is in the system and linked to a reservation, but the reservation's link to the transaction has been broken (or likewise for customers).  In this case, it looks like everything is fine from the point of view of the Transactions tab view, reports, etc., but if you look at the Transactions for the reservation (e.g. through Reservation Details), the transaction does not show up and is not added to the balance.  This is most likely due a program crash and/or incomplete database recovery.

 

If there are no orphans found, a simple message will appear saying there are no problems.  

 

If any orphans do exist, each orphaned transaction will be shown in a list with the most relevant details.  You should print this list before making any changes, just in case you find out later that fixing the problem causes balances to be incorrect.  (This can result if the operator added the transaction again, after seeing it missing from the reservation.)

 

First you should check each transaction determine if it should be fixed or deleted.  Double-clicking on the transaction will open the Transactions dialog for the given reservation or customer.  Naturally, since it's orphaned, the transaction won't show up there.  What you need to determine is whether the transaction should be there, or whether another transaction has already been added to replace it.  Generally this can be determined by the balance due, but checking more details may be necessary.

 

If the transaction should be deleted (i.e. it would be a duplicate if it was fixed to show up on the reservation), then click the transaction in the list to highlight it, and click Delete Selected Transactions.  If it should be fixed (i.e. you want it to show up on the reservation), then leave it in the list.

 

Once all transactions have been checked, then click the Fix... button at the bottom to fix any that are in the list.  The links will be repaired automatically so the transactions will appear on their respective reservation or customer transaction lists.

 


Page URL http://CampgroundMaster.com/help/reportandrepairtransactions.html

Campground Master Home