Kitpickingstart

Form KitPickingStart

• Unit name: Forms.KitPickingStart
• Form name: KitPickingStartForm
• Old form name: form10 (unit10)

Synopsis

Form to start a picking operation for kits.

Functionalities

1. Grid with kit orders for which picking is still needed (view KitOrdersForPick). When a row is selected, set the location dropdown to the item with index equal to the row ID. (so the kits are distributed over available locations)
2. Dropdown for production locations which are empty. (view KitProductionLocation)
3. Button to execute StartPicking action.
4. Button to execute Cancel action.

Actions

StartPicking

1. Enabled when a row is selected in the grid, and a valid location.
2. When executed, shows form PickItemsForm and passes the selected order number and location.
3. Close form.

Cancel

1. Always enabled.
2. when executed, closes the form and shows the main form.

Tables/Views

• KitProductionLocation

  SELECT
    A.LOCATION
  FROM
    Location A
    LEFT OUTER JOIN STOCTOTAL_KIT B ON A.LOCATION = B.LOCATION
  WHERE
    A.LOCATION LIKE 'P%'
  GROUP BY
    A.location
  HAVING
    (SUM(QTYIN - QTYOUT) <= 0) OR (A.Location='P.00.00.A')
  ORDER BY
    A.LOCATION;
  

• KitOrdersForPick

SELECT
  BlockNo AS Block,
  DATA AS ImpDate,
  AVIZ AS OrderNo
FROM
  OUT A
WHERE
  (A.AVIZ LIKE 'KG%')
  AND (A.DATA >= dateadd(DAY, - 100, getdate()))
  AND EXISTS (SELECT 1 FROM OUTDETAILS B WHERE (A.AVIZ = B.AVIZNO) AND (B.TRANSACTIONTYPE = 'KIT') AND (PICKEDBY=''))
ORDER BY
  BLOCKNO DESC

Needed Service Calls

None.

Reports

None.