Skip to main content
Answer

EXPORT Scenarios - Best way to determine DAC name for Field?

  • October 7, 2024
  • 2 replies
  • 65 views
D
Freshman I

I am building an Export scenario based on Invoices and Memos.

I am able to successfully select and include the Item Description field in my export. I would like to use a LEFT() function to select only the left 40 characters, but I am struggling to figure out the DAC prefix for this field or I do not have the proper syntax.

When I look at the SYMappingField, it shows me that the “Object” name is Transactions, but when I add that to my function, it does not validate.

What is the best way to determine a field’s DAC ?

OR, am I having a syntax issue?

=Left( [Transactions.InventoryID!Descr], 40)

 

 

Best answer by Laura03

Hello @DuncanParnell ,

When I’m looking for Data Class and field name, I find the field in the User Interface (on Receipts transaction screen in this case), then click Customization, Inspect Element, and click on the field I’m interested in:

When using the field name in calculations on Export Scenario screen, [transactions.TranDesc] should work fine.

Does this answer your question?

 

Laura

    Laura03

    2 replies

    Laura03
    Captain II
    Forum|alt.badge.img+19
    • Laura03
    • Captain II
    • Answer
    • October 7, 2024

    Hello @DuncanParnell ,

    When I’m looking for Data Class and field name, I find the field in the User Interface (on Receipts transaction screen in this case), then click Customization, Inspect Element, and click on the field I’m interested in:

    When using the field name in calculations on Export Scenario screen, [transactions.TranDesc] should work fine.

    Does this answer your question?

     

    Laura

    ~ Laura Barber, WM Synergy
    Chris Hackett
    D
    Freshman I
    • DuncanParnell
    • Author
    • Freshman I
    • October 7, 2024

    Thanks Laura. That helps. Looks like in my example, I just needed the “friendly” field name:  [Item Description] (without the “Transactions”).

    Laura03
    Chris Hackett
    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