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

By: Avaap
Date: February 15, 2015

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:

COMPANY PO-NUMBER REC-NUMBER STATUS
6000 60000000000301 139 9
6000 60000000000300 138 9
6000 60000000000274 137 1
6000 60000000000275 136 1

 

 

After:

COMPANY PO-NUMBER REC-NUMBER  
6000 60000000000301 139 Archived / Closed
6000 60000000000300 138 Archived / Closed
6000 60000000000274 137 Released
6000 60000000000275 136 Released

 

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!

Our Headquarters

Avaap USA, LLC
510 Thornall Street, Suite 250, Edison, NJ 08837

Phone: 732.710.3425
Fax: 732.243.9550
Email: info@avaap.com

Avaap Midwest 
6 West Fifth Street, 8th Floor, St Paul, MN 55102

Avaap EHR 
70 Madison Street, Suite 2610, Chicago, IL 60602

Global Center of Excellence 
Chennai ONE, IT SEZ, Upper Stilt, Pallavarm-Thoraipakkam, 200 ft Road, Thoraipakkam, Chennai 600096. INDIA

Avaap Europe
Stanmore House 64-68 Blackburn Street Radcliffe, Manchester M26 2JS. England

Avaap Spain
Travessera de Gracia, 73-79 Barcelona, Spain 08006

Technical assistance for Avaap Managed Services and Product customers: support@avaap.com