Articleswithmessage
Report ArticlesWithMessages
- Filename: ArticlesWithMessages
- Title: Articles with pop-up messages [and supplier :Supplier]
- Sample: Unit193
Synopsis
List of articles which have a pop-up message associated to them (of a certain supplier)
Note: this is an export to excel in original warta, maybe this must be done automatically as well.
SQL
SELECT
NAME as Artcode,
NAME2 as ArtDescr,
Pop_up_flag as Reception_Msg,
Pop_up_flag_del as Delivery_Msg,
Pop_up_flag_mov as Move_Msg
FROM
ARTICLE
WHERE
len(isnull(Pop_up_flag, '')+isnull(Pop_up_flag_del, '')+isnull(Pop_up_flag_mov, ''))>0
-- {CustomFilter}
ORDER BY
ARTCODE
Parameters
- CustomFilter macro which can contain a filter on supplier.
- Supplier Supplier, if any.