=CONCATENATE("'",A1,"'",",")

axbuild.exe xppcompileall /s=01 /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin"

?

C:\Program Files\Microsoft Dynamics AX\60\Server\DAX\bin

=VLOOKUP(B2,'AX Customer Stagging Table'!A:A,1,0)
=VLOOKUP(B2,'AX Customer Stagging Table'!A:B,2,0)

=CONCATENATE("'",A1,"'",",")
AWE_DF_31728_GLSummarySecurity

enrollmentId = subStr(conpeek(c,1),0,strLen(conPeek(c,1))-1);

Add to the query the following;

AX enrollment number

Cancel yes/no

Cancel date

Recurring pattern
Range of recurrence

=IF(A2<>A3,"Last","")

=IF(A2=A1,C1&","&B2,B2)
=IF(A2<>A3,"Last","")

Recurring pattern
Range of recurrence

=IF(A2=A1,C1&","&B2,B2)
=IF(A2<>A3,"Last","")

zero in class for on hold effective
1 in job on hold effective

select purchid, itemid, LINENUMBER,LINEAMOUNT, INVENTREFID
From [dbo].[PURCHLINE]
where purchid = 'PO-aomm-000004406' AND LINENUMBER IN (2,3)

BEGIN TRAN
UPDATE [dbo].[PURCHLINE]
SET INVENTREFID = 'SO-aomm000000468'
where purchid = 'PO-aomm-000004406' AND LINENUMBER IN (2,3)