Form ReturnsToStockForm

• Unit name: Forms.ReturnsToStock
• Form name: ReturnsToStockForm
• Old form name: Form45 (unit45, scanner app)

Synopsis

Form to enter returned goods into the stock.

Functionalities

1. Edit for return number.
2. On change, clear grid and detail display.
3. On enter key, execute Search action.
4. Button to execute Search action.
5. Edit for quantity.
6. On enter, move to location edit.
7. Combobox for return type (filled from view ReturnTypes)
8. Edit for location. On enter key, execute Move action.
9. Button to execute Move action.

Actions

Search

1. Enabled when there is a return invoice no.
2. When executed, refreshes the ReturnContents view.

Move

1. Enabled when
2. there is a return invoice
3. there are detail records
4. return type
5. A positive quantity, smaller than the quantity of the selected article line.
6. There is a destination location.
7. When executed, executes the Returns.MoveArticleToStock service call with all parameters as entered.
8. When the service call returns, the display of articles (returncontents) is refreshed, quantity, location are cleared, and quantity is focused.

Tables/Views

ReturnTypes

SELECT RTYPE FROM RETURNTYPE ORDER BY SQ ASC

ReturnContents

SELECT
  A.artcode, A.qty, A.LOTNO, B.NAME2, A.LOCATION, A.ID, A.STOCKCODE,
  isnull( A.SugestedLocationRet , ''x'') AS XLOCATION,
  isnull(Y.sqwpk, ''X'') as MySQ
FROM
  INVDETAILS A  
  LEFT OUTER JOIN Location Y on  A.SugestedLocationRet=Y.LOCATION
  INNER JOIN ARTICLE B A.ARTCODE=B.NAME
WHERE  
  (A.INVOICE = 'RET'+:ReturnInvoice)
  AND (A.location='R.00.00.A')
ORDER BY
  MySQ ASC, A.ARTCODE ASC

Needed Service Calls

Call 1

Call 2

Reports