0

Sequential letter

Hi, I need to add a sequential letter (A, B, C, D, ...) for the invoice number like 

"MyComp/123/" + A + "/" + year(now())

please help, thank you

2 replies

null
    • Mconneen
    • 6 yrs ago
    • Reported - view

    What are you going to do when you hit Z?  Loop back to AA?   Off the top of my head.. Create an invoice suffix table.. Prepopulate row by row A - Z, AA - ZZ..... as you use them.. mark them used ...  to find the first unused.. use a first with the select ... something like. 

    first(select('Inovice Suffix')[Used=null])

    • dwiandi_gmailcom
    • 6 yrs ago
    • Reported - view

    thank you, that is my option for now. I hope this can be a feature embedded in NX.

    regards

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1218Views