Form PickPaletteForm

• Unit name: Forms.PickPalette
• Form name: PickPaletteForm
• Old form name: form40 (unit40, scanner app)

Synopsis

Form to pick an article from an order from a palette.

Functionalities

1. Edit to enter order number. On enter key, call ShowOrder action.
2. Button to execute ShowOrder action.
3. Grid to show order content using OrderForPalette view. Records where the pickedby is not empty, are colored green.
4. Edit to enter palette number. On enter key, call CreateOrder action.
5. Button to execute CreateOrder action.
6. Button to execute Close form.

Actions

ShowOrder

1. Enabled when there is an order number.
2. When executed, refreshes the grid OrderForPalette view.

CreateOrder

1. Enabled when
2. there is an order number and the order has data.
3. There is palette number is not empty.
4. The palette number equals the palette number of the currently selected line.
5. The current selected line in the grid has 'Picked' is not 'Y'.
6. When executed, it executes the service call returns.PickFromPalette passing it the following parameters: OrderNumber,Return number (from current line), pallette number

Close

1. Always enabled.
2. When executed, close form with ModalResult mrOK

Tables/Views

OrderForPalette

SELECT
  A.IDNO, A.PalNo, A.ReturNo, A.TransactionType, A.CREATIONDATE, A.CREATIONTIME,
  A.PCNAME, A.Picked, A.PickedBy, A.PickedDate, A.ID, MAX(B.LOCATION) AS LOCATION
FROM
  RETUROUTDET A
  INNER JOIN INVDETAILS B ON
    (A.ReturNo=B.INVOICE)
    AND (A.PALNO=B.COLNO)
WHERE
   (A.IDNO=:ReturnID)
GROUP BY
  A.IDNO, A.PalNo, A.ReturNo, A.TransactionType, A.CREATIONDATE, A.CREATIONTIME,
  A.PCNAME, A.Picked, A.PickedBy, A.PickedDate, A.ID
ORDER BY
  A.PALNO ASC

Needed Service Calls

Call 1

Call 2

Reports