public void showFields(tableId tableId,FormGridControl formGridControl1, FormBuildDataSource formDataSource1)
{
FormStringControl formStringControl1,formStringControl2;
DictTable dictTable;
DictTable dictTable1;
DictTable dictTable2;
fieldId fieldId;
int i;
int t;
int fieldCnt;
Query Q1;
str ColValue[];
str strQuery;
object formRunCaller;
;
formRunCaller = element.args().caller();
testId1=formRunCaller.MethodA();
dictTable1 = new DictTable(_TestColumn.TableId);
// dictTable2 = new DictTable(_TestRows.TableId);
dictTable = new DictTable(tableId);
select * from _TestColumn where _TestColumn.QId == _Question.QId && _TestColumn.TestId==testId1 ;
if(_TestColumn)
{
ColValue[1] = _TestColumn.Col1;
ColValue[2] = _TestColumn.Col2;
ColValue[3] = _TestColumn.Col3;
ColValue[4] = _TestColumn.Col4;
ColValue[5] = _TestColumn.Col5;
ColValue[6] = _TestColumn.Col6;
ColValue[7] = _TestColumn.Col7;
ColValue[8] = _TestColumn.Col8;
ColValue[9] = _TestColumn.Col9;
ColValue[10] = _TestColumn.Col10;
//ss
ColValue[11]=_TestColumn.Col11;
ColValue[12]=_TestColumn.Col12;
ColValue[13]=_TestColumn.Col13;
ColValue[14]=_TestColumn.Col14;
ColValue[15]=_TestColumn.Col15;
ColValue[16]=_TestColumn.Col16;
//ss
}
for (i=1; i<=16; i++) { if(ColValue[i] != "")
{
fieldId = dictTable.fieldCnt2Id(i);
formStringControl1 = formGridControl1.addDataField(formDataSource1.id() ,fieldId2Ext(fieldId, 1));
formStringControl1.label(ColValue[i]);
}
else
{
continue;
}
}
//formGridControl1.dataSource(_TestRows); }
This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info...