Deliveriesjamberry

Report DeliveriesJamberry

Filename: DeliveriesJamberry
Title: Delivery report
Sample: Unit208

Synopsis

Formulier om lijst van deliveries voor Jamberry af te drukken.

SQL

Data: Detail

Select
  B.AVIZNO AS OrderNo,
  (CASE WHEN left(A.TrackingNumber, 1)='J' THEN A.TrackingNumber ELSE '' END) AS TrackingNumber,
  max(B.CheckedDate) AS ShippedDate,
  B.Artcode as SKU,
  sum(B.QTY) as QTY,
  A.COUNTRY  
from
  OUT A
  INNER JOIN OUTDETAILS B ON (A.AVIZ=B.AVIZNO)
  INVDETAILS D ON (B.InvoiceNo=D.ID) and (B.ARTCODE=D.ARTCODE)
WHERE
  (B.CheckedDate>=:StartDate) AND (B.CheckedDate<:EndDate)
 AND (A.CLIENT = 'JAMBERRY')
GROUP
  BY B.AVIZNO, A.TrackingNumber, B.Artcode, A.COUNTRY
ORDER BY
  B.AVIZNO,  B.Artcode

Parameters

StartDate (TDateTime)
EndDate (TDateTime)

Accessible in forms

InvoiceReports