void createGraph1()
{
//SalesLine salesline;
LedgerBudget ledgerBudget;
int i,k;
str month;
// date createddate;
#macrolib.ChartFx
;
graphics1 = Graphics::newGraphicsTitlesLayout(ChartX1, 100, 200,'Title', 'X', 'Y', 'z',1 ,1, 1, 1);
graphics1.create();
graphics1.parmTitle("MonthWise Comparison(G)");
graphics1.parmTitleXAxis('Month');
graphics1.parmTitleYAxis('Amount');
ChartX1.Chart3D(true);
ChartX1.toolBar(true);
//graphics.Gallery(9);
graphics1.parmHeight(350);
graphics1.parmWidth(450);
AllocApr=0;
AllocMay=0;
AllocJun=0;
AllocJul=0;
AllocAug=0;
AllocSept=0;
AllocOct=0;
AllocNov=0;
AllocDec=0;
AllocJan=0;
AllocFeb=0;
AllocMar=0;
while select * from LedgerBudget where LedgerBudget.Key!="" //ledgerBudget.AccountNum==ledgerTable.AccountNum
{
// DivisionName=divnm;
// if (salesline.createdDate >= fromDate &&
// salesline.createdDate <= toDate)
//
{
//switch(strFmt('%1',MthOfYr(LedgerJournalTable::findledgerJournalTrans.JournalNum).PostedDate)))
switch(strFmt('%1',MthOfYr( LedgerBudget.createdDate)))
{
case '4':
// info(strFmt('%1 %2', Year(_date), MthOfYr(_date) ));
AllocApr += LedgerBudget.Amount;
break;
case '5':
AllocMay += LedgerBudget.Amount; break;
case '6':
AllocJun += LedgerBudget.Amount;
break;
case '7':
AllocJul += LedgerBudget.Amount; break;
case '8':
AllocAug += LedgerBudget.Amount;
break;
case '9':
AllocSept += LedgerBudget.Amount;
break;
case '10':
AllocOct += LedgerBudget.Amount;
break;
case '11':
AllocNov += LedgerBudget.Amount;
break;
case '12':
AllocDec += LedgerBudget.Amount;
break;
case '1':
AllocJan += LedgerBudget.Amount;
break; case '2':
AllocFeb += LedgerBudget.Amount; break;
case '3':
AllocMar += LedgerBudget.Amount; break
; }
}
for (k=0;k<12;k++)
{
if (k==0)
{
// if(AllocJan!=0)
{
graphics1.loadData("Jan","",AllocJan);
}
}
if (k==1)
{
// if(AllocFeb!=0)
{
graphics1.loadData("Feb","",AllocFeb);
}
}
if (k==2)
{
// if(AllocMar!=0)
{
graphics1.loadData("Mar","",AllocMar);
}
}
if (k==3)
{
// if(AllocApr!=0)
{
graphics1.loadData("Apr","",AllocApr);
}
}
if (k==4)
{
// if(AllocMay!=0)
{
graphics1.loadData("May","",AllocMay);
}
}
if (k==5)
{
// if(AllocJun!=0)
{
graphics1.loadData("Jun","",AllocJun);
}
}
if (k==6)
{
// if(AllocJul!=0)
{
graphics1.loadData("Jul","",AllocJul);
}
}
if (k==7)
{
// if(AllocAug!=0)
{
graphics1.loadData("Aug","",AllocAug); } }
if (k==8)
{
// if(AllocSept!=0)
{
graphics1.loadData("Sept","",AllocSept); } }
if (k==9)
{
// if(AllocOct!=0)
{
graphics1.loadData("Oct","",AllocOct);
}
}
if (k==10)
{
// if(AllocNov!=0)
{
graphics1.loadData("Nov","",AllocNov);
}
}
if (k==11)
{
// if(AllocDec!=0)
{
graphics1.loadData("Dec","",AllocDec);
}
}
}
graphics1.showGraph();
}
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...