What's new in Customer Journeys?

Connect and learn more!
Manage User-Defined Formulas Sintax — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Manage User-Defined Formulas Sintax

Received Response



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;"_")" .

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!