Skip to main content

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( LTransactions.InventoryID!Descr], 40)

 

 

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, rtransactions.TranDesc] should work fine.

Does this answer your question?

 

Laura

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

Reply


Terms & ConditionsCookie settings
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