May 28 2019 04:34 PM
I have customer transaction item data in a file and am trying to add an alphanumeric invoice number field to each line item (like: 2019-FI-001) before importing them into an accounting application. On each subsequent transaction line I wish to perform logic to determine if the customer number is the same as the previous line and if so keep the invoice number the same, otherwise increment by one. I could do this by splitting the counter (001) and concatenating it to the prefix (2019-FI-) but wondering is there is a function that can do this like the fill series sequencing logic does automatically in a drag fill?
May 29 2019 12:24 AM