• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Description: 
The acq-10 and acq-16 reports -- and a full list of transactions for each budget from the GUI pasted into a spreadsheet -- show that certain orders are missing. 

The orders cannot be retrieved in the GUI. Is it possible to retrieve them from the server to find out what actions were taken? 

Solution: 
Do the following SQL to confirm that the orders are no longer present: 

SQL> select z68_rec_key from z68 where z68_order_number = 'xxxx'; 

[where "xxxx" is the order number]. 

If the result is "No rows found", then the order record is no longer present. 

Aside from the Delete button in GUI Acq, the only way that z68 order records can be deleted is via SQL. If you are certain that there was no deletion of these orders via SQL, the only alternative is deletion in GUI Acq. 

If the z68_rec_key were known, it's *possible* that it could be determined who deleted the order, but it's not clear that it could be determined even with the rec-key.

• Article last edited: 12-Mar-2016