Movehighstart

Form MoveHighStart

• Unit name: Forms.MoveHighStart
• Form name: MoveHighStartForm
• Old form name: Form3/Form38 (unit3/unit38)

Synopsis

Form to move articles from high to low locations.

Functionalities

1. Grid to show MoveCandidates view. Filled on form show.
2. Button to execute OK action.
3. On show check if there any active import jobs. If there any, show a message:

   An import is in progress.
   

   Close the form, show Move Menu form.
4. Button to execute Cancel action.

Actions

OK

1. Enabled if a record is selected.
2. Show the MoveHighLocation form.

Cancel

1. Enabled if a record is selected.
2. On execute, close the form, show Move Menu form.

Action2

Tables/Views

• MoveCandidates

  SELECT
    DISTINCT A.BlockNo AS Block,
    A.Country AS Ct,
    A.Data AS ImpDate,
    A.AVIZ AS OrderNo,
    isnull(D.SQ, 99) AS MySQ,
    F.SQPK
  FROM
    OUT A
    LEFT OUTER JOIN COUNTRYORDER C ON
      (DATEPART(WeekDay, A.DATA) = C.DayOfWeek)
      AND (A.COUNTRY = C.COUNTRY)
    LEFT OUTER JOIN SUPPLIERS F ON A.CLIENT = F.NAME,
    INNER JOIN OUTDETAILS B ON A.AVIZ = B.AVIZNO
    INNER JOIN INVDETAILS D (B.INVOICENO = D.ID)
  WHERE
    ((D.LOCATION, 1) <> 'A')
    AND (A.CLIENT <> 'JAMBERRY')
    AND (DATA >= dateadd(DAY, - 1, getdate()))
    AND B.TRANSACTIONTYPE IN ('ORD', 'KIT')
  ORDER BY
    F.SQPK ASC,
    MYSQ ASC,
    A.BLOCKNO DESC
  

Needed Service Calls

Call 1

Call 2

Reports