Statistics on order arrivals include deleted arrivals
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct,Direct,Local,Total Care
Description:
The acq-22 Order log report on arrivals (TYPE "08"), or SQL which reports on z71_type 08 records, includes deleted arrivals. How to get a count which doesn't include these?
Resolution:
When an order/item arrives, in addition to the z71 type 08, a z78 arrival record is created. When the item is "unarrived", this z78 is deleted.
It doesn't seem that anything can be done with the acq-22, but, if SQL is being used, it could be changed to include a check for the z78.