Inventoryscanlist

Report InventoryScanList

• Filename: InventoryScanList
• Title: Inventory Scan List
• Sample: Unit96 (form96)

Synopsis

Print scan list for an inventory

SQL

SELECT
  INVENTORYDET.*, NAME2, GROUPE
FROM
  INVENTORYDET
  LEFT JOIN ARTICLE ON (NAME=ARTCODE)
WHERE
  (IDNO=:IDNO)
--  {CustomFilter}
ORDER BY
  ARTCODE ASC

Parameters

• IDNO Inventory ID
• CustomFilter Custom filter, must start with "AND"

Accessible in forms

1. Inventory