Statistics on order arrivals include deleted arrivals

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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.