Trolleypickarticles

Form TrolleyPickArticles

• Unit name: Forms.TrolleyPickArticles
• Form name: TrolleyPickArticlesForm
• Old form name: unit trolley_m_pick

Synopsis

Form to accompany putting articles in trolley locations.

Functionalities

1. Edit box to enter trolley location. When enter key is hit, Scanlocation is executed.
2. Listbox to list locations and quantities of the article, as provided by view TrolleyLocationPickArticles. Items are shown read until scanned, then they are shown green.
3. Close button to execute OK action.
4. Properties to set article, invoice, location, lotno and pickedby.

Actions

ScanLocation

1. Enabled when a location is entered in edit box.
2. When executed, checks that the location is identical to the selected location in the listbox.
3. If not, an error message is shown.
4. If yes, the trolley location edit is emptied. If there is a next line in the listbox, it is selected. If not, the form is closed with modal result
5. mrYes if all listbox items were scanned
6. mrNo if all some listbox items were not scanned.

OK

1. Always enabled.
2. the form is closed with modal result
3. mrYes if all listbox items were scanned
4. mrNo if all some listbox items were not scanned.

Tables/Views

TrolleyLocationPickArticles

SELECT
  isnull(TLOCATION, ''),
  isnull(sum(B.QTY), 0) aS QTY
from
  OUT A
  INNER JOIN OUTDETAILS B ON (A.AVIZ = B.AVIZNO)
  INNER JOIN INVDETAILS C ON (B.INVOICENO = C.ID) and (C.ARTCODE = B.ArtCode)
WHERE
  (A.AVIZ IN :Invoice)
  AND (B.ARTCODE = :Article)
  AND (C.LOCATION = :Location) AND
  AND (C.LOTNO = :LOTNO) AND
  (B.PICKEDBY = :PickedBy)
GROUP BY
  isnull(TLOCATION, '')

Needed Service Calls

None.

Reports

None.