Ask the Avaap Expert: How can I create a DME string query with an actual description?

If you create a DME (Query) in MS Add-Ins with a status field and want to convert the numeric value to the actual description, save your DME file and then open it in TextPad (or Notepad, etc.) and edit the .dme file to add ,xlt to the status field. Save it and when you open it within MS Add-Ins and run it, the results will come back with the status description.

 

“DEVEL2B~PO~PORECEIVE~2~1~600~Created with Query Wizard 10.0.109~0~1~0~F

LWSN104~~COMPANY~2~~PO-NUMBER~0~~REC-NUMBER~2~~STATUS,xlt~2~

NEW~~0

Sheet1~A~1~TRUE~FALSE~FALSE

 

Before:

COMPANYPO-NUMBERREC-NUMBERSTATUS
6000600000000003011399
6000600000000003001389
6000600000000002741371
6000600000000002751361

 

 

After:

COMPANYPO-NUMBERREC-NUMBER 
600060000000000301139Archived / Closed
600060000000000300138Archived / Closed
600060000000000274137Released
600060000000000275136Released

 

Have a question about how to do something in Infor Lawson? Send us an email and we’ll feature your challenge and a solution in an upcoming post!

Get the latest thought leadership from Avaap delivered to your inbox weekly!

* indicates required

Expert Insights

Trending resources

The Complete Guide to ACA Setup and Configuration (PDF)

This presentation takes a deep dive into setup and configuration for the Affordable Care Act (ACA) inside Infor Benefits Administration.…
Leveraging Change Management When Moving to the Cloud

Leveraging Change Management When Moving to the Cloud

Start with the end in mind: Optimize your future state by leveraging the current state…
Spilling the Tea: Three Things You Should Know Before an ERP Implementation

Spilling the Tea: Three Things You Should Know Before an ERP Implementation

Have you implemented ERP in the cloud? There are many people who are first-timers to…

If you create a DME (Query) in MS Add-Ins with a status field and want to convert the numeric value to the actual description, save your DME file and then open it in TextPad (or Notepad, etc.) and edit the .dme file to add ,xlt to the status field. Save it and when you open it within MS Add-Ins and run it, the results will come back with the status description.

 

“DEVEL2B~PO~PORECEIVE~2~1~600~Created with Query Wizard 10.0.109~0~1~0~F

LWSN104~~COMPANY~2~~PO-NUMBER~0~~REC-NUMBER~2~~STATUS,xlt~2~

NEW~~0

Sheet1~A~1~TRUE~FALSE~FALSE

 

Before:

COMPANYPO-NUMBERREC-NUMBERSTATUS
6000600000000003011399
6000600000000003001389
6000600000000002741371
6000600000000002751361

 

 

After:

COMPANYPO-NUMBERREC-NUMBER 
600060000000000301139Archived / Closed
600060000000000300138Archived / Closed
600060000000000274137Released
600060000000000275136Released

 

Have a question about how to do something in Infor Lawson? Send us an email and we’ll feature your challenge and a solution in an upcoming post!