Ga naar inhoud

Inventaris

  1. Returns GR

  2. Form 26: Start return

    1. Form57 to create new return.
    2. Form51 to select/add invoices to return.
    3. Form52 to add return content to stock.

  3. Returns All

  4. Form 60: Start return

    1. Form57 to create new return.
    2. Form61 to pick articles from original order.

  5. Return to locations

  6. Form45 : Enter location where returned goods will be placed.

  7. Damaged returns

  8. Form28 : start damages return (stockcode S, transaction type RETFGRC)

    1. Form57 to create new return.
    2. Form51 to select/add invoices to return.
    3. Form52 to add return content to stock.

  9. GRC damaged returns.
    Identiek aan Damaged returns maar (stockcode K2, transaction type RETDGRC)

  10. Pal(lette) content

  11. Form37 Show content of palette. No other functionality.

  12. Move pal(lette) content

  13. Form 44: geef nieuwe locatie op voor palette: alle goederen naar die palette.

  14. Pal(lette) picking Prepare a palette for picking for an outgoing order. (form 40)

Vragen

  1. GRC/Non GRC etc. Betekenis ?
  2. NPU, betekenis ?
  3. Database met invoices ?

Form ReturnsInTake

  • Unit name: Forms.PickMethod
  • Form name: PickMethodForm
  • Old form name: form26 (scanner app), form28

Synopsis

Form to register and handle returns.

Functionalities

  1. Button to Execute NewReturn action. As long as no return was started, all other functionality is disabled.
  2. Edit to display return number. On enter key, execute DisplayReturn action.
  3. Checkbox 'Damaged'.
  4. Only enabled when no return is started.
  5. Button to execute DisplayReturn action.
  6. Dropdown to enter return reason (ReturnReason)
  7. radio button: duty free/duty cleared.
  8. Grid with return articles.
  9. Grid with return invoices.
  10. Edit for article code.
  11. On enter key, action SearchArticle is executed.
  12. Button for SearchArticle action.
  13. Edit for lot number.
  14. On enter key, action CheckLotNo is executed.
  15. Button for CheckLotNo is executed.
  16. Edit for Palette number.
  17. Only active when "damaged" is checked.
  18. Button to execute AddInvoice action.
  19. Button to execute AddArticle action.
  20. Button to execute ReturnToStock action.
  21. Button to execute CheckPalette action.
  22. Button to execute PickPalette action.
  23. Button to execute ReturnsToStock action.
  24. Button to execute MovePalette action.
  25. Button to execute NewPalette action.

Actions

Displayreturn

  1. Enabled when the return number edit is non-empty, and the return number differs from the current one.
  2. When executed, fetches the return record and the details.

NewReturn

  1. Enabled while no new return is active.
  2. Show NewReturnDialog dialog. If it returns with modalResult=mrOK then note the invoice ID, damaged and supplier ID. Determine transaction type:
  3. RET (niet damaged)
  4. RETDGRC (damaged)
  5. RETD (damaged)
  6. RETFGRC (refurbished)
  7. RETDGRC (damaged)

AddInvoice

  1. Enabled when a return is displayed.
  2. When executed, the user is asked to supply invoice details using the AddInvoiceToReturnForm form.
  3. The stock code is determined based on the supplier and damaged checkbox:
  4. Damaged:
    1. 'S' voor guthy renker
    2. 'K2' voor niet Guthy renker
  5. Niet damaged:
    1. '75'
  6. The list of invoices is refreshed if the form returns mrOK as modal result.

AddOrder

  1. Enabled when a return is displayed.
  2. When executed, the user is asked to supply invoice details using the AddOrderToReturnForm form.

ReturnToStock

  1. Enabled when a return is displayed.
  2. When executed, all data is saved to the server if need be, and the service call Returns.MoveReturnToStock is executed.
  3. On success, a message dialog is shown: 
    Moved :result articles to stock.
    where result is the return result of the function. The article grid is refreshed.

NewPalette

  1. Only enabled when 'Damaged' is checked.
  2. When executed, executes the Returns.AllocatePalette service call and enters the result in the pallete number edit.

CheckPalette

  1. Always enabled.
  2. Show the form PaletteContentForm modally. If the palette edit contains a number, pass it on to the form.

PickPalette

  1. Always enabled.
  2. Shows the PickPaletteForm form modally.
  3. If a return order is filled in, it is passed to the form.
  4. if a palette is filled in, it is passed to the form.

MovePalette

  1. Always enabled.
  2. Shows the MovePaletteForm form modally.

ReturnsToStock

  1. Always enabled.
  2. Show the ReturnsToStock form (replacing the current one)

SearchArticle

  1. Enabled when there is an article number.
  2. When executed, activates the ArticleFromBarCode view. If empty, an exception is raised: 
    The article :ArticldeCode does not exist.
  3. If FLOTNO is Y then the lot number edit is enabled,
  4. If FLOTNO is not equal to Y then the lot number edit is disabled,
  5. The article expiry time is recorded.

AddArticle

  1. Enabled when
  2. a return is active
  3. an article code has been filled in.
  4. an article quantity has been filled in.
  5. When executed, the Returns.AddArticleToReturn service call is executed.
  6. The article-related edits (code, quantity, lot) are cleared, the details refreshed.

Tables/Views

  • ReturnArticles 
    SELECT
  *
FROM
  INVDETAILS
  INNER JOIN Retur ON (INVDETAILS.INVOICE = 'RET'+Retur.ID)
WHERE
  (Retur.ID=:ReturnID)
  (TransactionType=:TransactionType)
ORDER BY
  INVDETAILS.ID DESC
  • ReturnInvoices 
    SELECT
   RetNo, ARTCODE, QTY, STOCKCODE, ItemStatus, CCODE, LOCATION, CREATIONDATE, PCNAME, ReturnDate,
   OriginalInvoiceNumber, TenantOrg, OriginalFileID,  Prepaid, ReturnReason, SpecialInstructions RetSource
FROM
  RETURDETGR
WHERE
  (RetNo=:ReturnID)