Deliverydifferences

Report DeliveryDifferences

• Filename: DeliveryDifferences
• Title: Delivery differences
• Sample: unit19

Synopsis

List showing differences between quantity asked and quantity delivered

SQL

select
  AVIZ, BLOCKNO, QTYASKED, ARTCODE, SUM(QTY) AS QTYDEL,  ROWNO
FROM
  OUT A
  INNER JOIN OUTDETAILS B ON (A.AVIZ = B.AVIZNO)
WHERE  
  (BLOCKNO = :BLOCKNO)
GROUP BY
  AVIZ, BLOCKNO, QTYASKED, ARTCODE, ROWNO
HAVING
  QTYASKED<>SUM(QTY)
ORDER BY
  BLOCKNO DESC, AVIZ, ROWNO

Parameters

• BlockNo block number.

Accessible in forms

1. Deliveries Grid
2. Deliveries details