static void Datatypes_container_functions(Args _args)
{
container con;
;
// conins - Insert values to the container
con = conins(con, 1, "Toyota");
con = conins(con, 2, 20);
con = conins(con, 3, 2200.20);
con = conins(con, 4, "BMW");
con = conins(con, 5, 12);
con = conins(con, 6, 3210.44);
// condel - Delete the third and the fourth element
// from the container
con = condel(con, 3, 2);
// conpeek - Read values from the container
info(conpeek(con,1));
info(conpeek(con,2));
info(conpeek(con,3));
info(conpeek(con,4));
// connull - Reset the container
con = connull();
// conlen - Get the length of the container
info(strfmt("Length: %1",conlen(con)));
}
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...