Skip to main content

I am building an Export Scenario using data from the Invoices and Memos screen name.

I am mapping the Post Period column from the Invoice Summary Source Object which contains an example value of  "082024"

I would like to use the LEFT function to only extract the "08" value for Period.

 

Can functions be used on the “Field / Action Name” column and if so, what is the syntax for the LEFT function on the Invoice Summary / Post Period field?

I have tried the following, but none have worked. I receive errors from Missing Operand to Invalid Hdr when running my Export Scenario:

=LEFT(FinPeriodID, 2)

=LEFT(>FinPeriodID], 2)

=LEFT(>Post Period], 2)

 

 

Hello @DuncanParnell ,

 

I haven’t used the function. How about try using the DAC.Field in the function.

= Left(eDAC.FinPeriodID], 2)

 

 


I was able to use the function by specifying the DAC, in this case “Document”

=LEFT(EDocument.FinPeriodID],2)

 

Thanks Harish


Reply