NEXL Expressions for JEs in Cash Module

Last updated: September 15, 2026

  • Month: {{SPLIT(posting_date, "-")[1] == "01" ? "January" : SPLIT(posting_date, "-")[1] == "02" ? "February" : SPLIT(posting_date, "-")[1] == "03" ? "March" : SPLIT(posting_date, "-")[1] == "04" ? "April" : SPLIT(posting_date, "-")[1] == "05" ? "May" : SPLIT(posting_date, "-")[1] == "06" ? "June" : SPLIT(posting_date, "-")[1] == "07" ? "July" : SPLIT(posting_date, "-")[1] == "08" ? "August" : SPLIT(posting_date, "-")[1] == "09" ? "September" : SPLIT(posting_date, "-")[1] == "10" ? "October" : SPLIT(posting_date, "-")[1] == "11" ? "November" : "December"}}

  • Year: {{SPLIT(posting_date, "-")[1] == "01" ? "January" : SPLIT(posting_date, "-")[1] == "02" ? "February" : SPLIT(posting_date, "-")[1] == "03" ? "March" : SPLIT(posting_date, "-")[1] == "04" ? "April" : SPLIT(posting_date, "-")[1] == "05" ? "May" : SPLIT(posting_date, "-")[1] == "06" ? "June" : SPLIT(posting_date, "-")[1] == "07" ? "July" : SPLIT(posting_date, "-")[1] == "08" ? "August" : SPLIT(posting_date, "-")[1] == "09" ? "September" : SPLIT(posting_date, "-")[1] == "10" ? "October" : SPLIT(posting_date, "-")[1] == "11" ? "November" : "December"}} {{SPLIT(posting_date, "-")[0]}}

  • Year: {{SPLIT(posting_date, "-")[0]}}

  • Month Year: {{SPLIT(posting_date, "-")[1] == "01" ? "January" : SPLIT(posting_date, "-")[1] == "02" ? "February" : SPLIT(posting_date, "-")[1] == "03" ? "March" : SPLIT(posting_date, "-")[1] == "04" ? "April" : SPLIT(posting_date, "-")[1] == "05" ? "May" : SPLIT(posting_date, "-")[1] == "06" ? "June" : SPLIT(posting_date, "-")[1] == "07" ? "July" : SPLIT(posting_date, "-")[1] == "08" ? "August" : SPLIT(posting_date, "-")[1] == "09" ? "September" : SPLIT(posting_date, "-")[1] == "10" ? "October" : SPLIT(posting_date, "-")[1] == "11" ? "November" : "December"}} {{SPLIT(posting_date, "-")[0]}}

  • Prior Month Year: {{SPLIT(posting_date, "-")[1] == "01" ? "December" : SPLIT(posting_date, "-")[1] == "02" ? "January" : SPLIT(posting_date, "-")[1] == "03" ? "February" : SPLIT(posting_date, "-")[1] == "04" ? "March" : SPLIT(posting_date, "-")[1] == "05" ? "April" : SPLIT(posting_date, "-")[1] == "06" ? "May" : SPLIT(posting_date, "-")[1] == "07" ? "June" : SPLIT(posting_date, "-")[1] == "08" ? "July" : SPLIT(posting_date, "-")[1] == "09" ? "August" : SPLIT(posting_date, "-")[1] == "10" ? "September" : SPLIT(posting_date, "-")[1] == "11" ? "October" : "November"}} {{SPLIT(posting_date, "-")[1] == "01" ? SPLIT(posting_date, "-")[0] - 1 : SPLIT(posting_date, "-")[0]}}

  • giQuarter & Years: {{"Q" + (SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "01" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "02" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "03" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "04" ? "2" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "05" ? "2" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "06" ? "2" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "07" ? "3" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "08" ? "3" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "09" ? "3" : "4") + " " + SPLIT(FIRST(left_bank_lines).posting_date, "-")[0]}}

  • Prior Quarter & Years: {{"Q" + (SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "01" ? "4" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "02" ? "4" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "03" ? "4" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "04" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "05" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "06" ? "1" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "07" ? "2" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "08" ? "2" : SPLIT(FIRST(left_bank_lines).posting_date, "-")[1] == "09" ? "2" : "3") + " " + SPLIT(FIRST(left_bank_lines).posting_date, "-")[0]}}

  • Full Bank Line (left): {{FIRST (left_bank_lines).memo}}

  • Full Bank Line (right): {{FIRST (right_bank_lines).memo}}

  • Employee Name (RMPR Rules): {{SPLIT(SPLIT(FIRST(left_bank_lines)["memo"], "RMPR ")[1], " ORIG")[0]}}

  • Customer Reference Number: {{FIRST(left_bank_lines).metadata.customer_reference_number}}

  • Working Pattern: {{FIRST(left_bank_lines).metadata.<field_name>}}

  • Date: {{FIRST (left_bank_lines).posting_date}}