Resumepickingjobs

Form ResumePickingJobsForm

• Unit name: Forms.ResumePickingJobs
• Form name: TResumePickingJobsForm
• Old form name: (unit59) form59

Synopsis

Form to start picking based on started job.

Functionalities

1. Grid to show ResumePickingjobs view.
2. Button to execute 'Cancel' action
3. Button to execute 'StartPicking' action
4. Radiogroup to select picking order: 0 -> 99 or 99->0.

Actions

StartPicking

1. When executed, the selected order is added to a picking job using service call DeliveryControl.AddToPickJob
2. The PickItems form is shown, with the following parameters:
3. The picking job ID.
4. The sort order.
5. The pickingType ptResume.
6. Current form is closed.

Cancel

1. Always active.
2. Closes form and shows pickmethod form.

Tables/Views

ResumePickingJobs

Select
  A.PickingJobID,
  A.Client,
  Max(A.PLPrintingDate) as PL_PrintDate
from
  OUT A
  INNER JOIN OUTDETAILS B ON (A.AVIZ = B.AVIZNO)
WHERE
  (A.DATA >= dateadd(day, - 10, getdate()))
  AND (A.PickingJobID > 0)
group by
  A.PickingJobID,
  A.Client
having
  sum(CASE
        WHEN ISNULL(PICKEDBY, '') = '' THEN 1
        ELSE 0
      END) > 0
order by
  A.PickingJobID desc

Needed Service Calls

None.

Reports

None.