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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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