Skip to main content
Answer

EXOPRT Scenarios - Using LEFT() Function

  • September 25, 2024
  • 2 replies
  • 49 views
D
Freshman I

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)

 

 

Best answer by hdussa

Hello @DuncanParnell ,

 

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

= Left([DAC.FinPeriodID], 2)

 

 

    2 replies

    hdussa
    Jr Varsity I
    Forum|alt.badge.img+1
    • hdussa
    • Jr Varsity I
    • Answer
    • September 25, 2024

    Hello @DuncanParnell ,

     

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

    = Left([DAC.FinPeriodID], 2)

     

     

    ~ Harish Dussa
    Chris Hackett
    D
    Freshman I
    • DuncanParnell
    • Author
    • Freshman I
    • September 25, 2024

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

    =LEFT([Document.FinPeriodID],2)

     

    Thanks Harish

    Chris Hackett
    hdussa
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved