7.07 Auto Form Mode

Below is example on Auto Today Filter for Sales Invoice

(SL_IV.DOCDATE = CAST('Today' AS DATE))

Below is example on Auto Current Month Filter for Sales Invoice

EXTRACT(Month FROM SL_IV.DOCDATE) = EXTRACT(Month FROM CAST('Today' AS DATE)) AND EXTRACT(Year FROM SL_IV.DOCDATE) = EXTRACT(Year FROM CAST('Today' AS DATE))

Below is example on Auto Last Month & Current Month Filter for Sales Invoice

EXTRACT(Month FROM SL_IV.DOCDATE) = (CASE EXTRACT(Month FROM CAST('Today' AS DATE)) WHEN 1 THEN 12 ELSE EXTRACT(Month FROM CAST('Today' AS DATE)) -1 END) AND EXTRACT(Year FROM SL_IV.DOCDATE) = (CASE EXTRACT(Month FROM CAST('Today' AS DATE)) WHEN 1 THEN EXTRACT(Year FROM CAST('Today' AS DATE)) -1 ELSE EXTRACT(Year FROM CAST('Today' AS DATE)) END) OR EXTRACT(Month FROM SL_IV.DOCDATE) = EXTRACT(Month FROM CAST('Today' AS DATE)) AND EXTRACT(Year FROM SL_IV.DOCDATE) = EXTRACT(Year FROM CAST('Today' AS DATE))

Notes :

Make sure the script is 1 line ONLY