Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Can I use substr on account.all in UDF in SLA?

in Subledger Accounting & Accounting Hub 1 comment

We are trying to use a user-defined formula to get value of an individual segment (which is not defined in as one of the segments like "Intercompany Segment" etc) from the revenue account.


The code that we wrote was :

Substring("Bill-to Site Use Revenue Account"."All",32,4)

For some reason it does not seem to be pulling the expected value.


However, if we try to use a segment labelled as "Intercompany Segment" instead of "All", it does seem to work.

For example, "Bill-to Site Use Revenue Account"."Intercompany Segment"


Does anyone have an experience with using Substr on Account.All kind of source?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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