Manage User-Defined Formulas Sintax
Summary:
Hi,
we need to transfer an information from AR Receipt to GL line reconciliation reference.
The information is store in the file "Comments"(receipt header) and in the Receipt number, formatted like ****-****_YYYYY.
To transfer the information in GL we want to use the SLA module with an User-defined-formula. We are facing the followinjg problem :
- The field "Comment" it's not in the available list of sources. There is insted an "RCT_COMMENT" but if my understanding is correct, it's related to a table "views" that is always emply.
- The second option is to do a substring of the Receipt number. In a structure like ****-****_YYYY we only need digit up to "_" . Moreover the number of digit is not fix, so i can't use the classic "substring ( start, end)" , but i need some sintax like the excel "=TEXTBEFORE(data;"_")" .
0