Thursday, May 23, 2013

Upload Financial Dimension Value For Dynamic AX 2012

Here goes the scenario for upload financial dimension value for Dynamic AX 2012

Example : You have financial dimension : Department and you want to insert or add  financial dimension value into it.

here goes the scripts :
static void TCN_DPRcreateDimensionValue(Args _args)
{
DimensionValueService service;
DimensionValueContract dimensionValueContract;
TCN_FinancialDimensionValueTemp dimTemp;


service = new DimensionValueService();
dimensionValueContract = new DimensionValueContract();
try
{
while select dimTemp order by FinancialDimension
{

dimensionValueContract.parmDescription(dimTemp.FinancialDimensionDescription); //financial dimension value description
dimensionValueContract.parmValue(dimTemp.FinancialDimensionValue); //financial dimension value;
dimensionValueContract.parmDimensionAttribute(dimTemp.FinancialDimension); //financial dimension
service.createDimensionValue(dimensionValueContract);
}

}
catch
{
ttsAbort;
}
info("Hore Sukses");
}

Good Luck
Please suit for your needs :D
Dwipa
READ MORE - Upload Financial Dimension Value For Dynamic AX 2012

Thursday, May 16, 2013

SRSS Reporting Format Report Date In Visual Studio 2010 with Dynamic AX 2012

1. Print page number like Page 1 of 2
="Page "&Globals!PageNumber &" of "&Globals!TotalPages

2. Print current date with prefix like Jakarta, 1 April 2013
="Jakarta, " & day(Globals!ExecutionTime) & " " & monthname(month(Globals!ExecutionTime)) & " " & year(Globals!ExecutionTime)

3.Print date with passing parameter from dataset dynamic ax 2012 //ex. param is  InvoiceDate
="Jakarta, " & day(Fields!InvoiceDate.Value) & " " & monthname(month(Fields!InvoiceDate.Value)) & " " & year(Fields!InvoiceDate.Value)

4. Print date without timestamp
=Format(Fields!Start_Date.Value,"dd/MM/yyyy")

5. Print number
=RowNumber(nothing)


6. Print or counting amount of records on table or matrix
=CountRows("Tablix1")

7. Print only one records in row
=IIF(Rownumber("Tablix1") >1,"","Solar Beban LMM")


READ MORE - SRSS Reporting Format Report Date In Visual Studio 2010 with Dynamic AX 2012